SAS base 考试必备 70真题（附答案）

A. norowcount nocolcount B. freq percent C. norow nocol D. nocounts

Answer: C

------------------------------------------------------------------

48.The following SAS program is submitted:

data WORK.TEST; drop City;

infile datalines; input

Name $ 1-14 / Address $ 1-14 / City $ 1-12 ;

if City='New York ' then input @1 State $2.; else input; datalines; Joe Conley 123 Main St. Janesville WI

Jane Ngyuen 555 Alpha Ave. New York NY

Jennifer Jason 666 Mt. Diablo Eureka CA ;

What will the data set WORK.TEST contain?

A.

Name Address State -------------- ---------------- ------ Joe Conley 123 Main St.

Jane Ngyuen 555 Alpha Ave. NY Jennifer Jason 666 Mt. Diablo

B.

Name Address City State -------------- ---------------- ----------- ------ Joe Conley 123 Main St. Janesville

Jane Ngyuen 555 Alpha Ave. New York NY Jennifer Jason 666 Mt. Diablo Eureka

C.

Name Address State -------------- ---------------- ------

Jane Ngyuen 555 Alpha Ave. NY

D. O observations,there is a syntax error in the data step.

Answer: A

------------------------------------------------------------------

49.The following SAS program is submitted:

data WORK.TOTALSALES(keep=MonthSales{12});

set WORK.MONTHLYSALES(keep=Year Product Sales); array MonthSales{12}; do i=1 to 12;

MonthSales{i}=Sales; end; drop i; run;

The program fails execution due to syntax errors. What is the cause of the syntax error?

A. An array cannot be referenced on a keep= data set option. B. The keep= data set option should be (keep=MonthSales*).

C. The keep= data set option should be the statement KEEP MonthSales{12}. D. The variable MonthSales does not exist.

Answer: A

------------------------------------------------------------------

50.Given the SAS data set WORK.ONE:

Id Char1 --- ----- 111 A

158 B 329 C 644 D

and the SAS data set WORK.TWO:

Id Char2 --- ----- 111 E 538 F 644 G

The following program is submitted:

data WORK.BOTH;

set WORK.ONE WORK.TWO; by Id; run;

What is the first observation in SAS data set WORK.BOTH?

A. Id Char1 Char2 --- ----- ----- 111 A

B.

Id Char1 Char2 --- ----- ----- 111 E

C.

Id Char1 Char2 --- ----- ----- 111 A E

D.

Id Char1 Char2 --- ----- ----- 644 D G

Answer: A

------------------------------------------------------------------ 51.The following program is submitted:

proc contents data=_all_; run;

Which statement best describes the output from the submitted program?

A. The output contains only a list of the SAS data sets that are contained in the WORK library.

B. The output displays only the contents of the SAS data sets that are contained in the WORK library.

C. The output displays only the variables in the SAS data sets that are contained in the WORK library.

D. The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.

Answer: D

------------------------------------------------------------------

52.Given the SAS data set WORK.EMP_NAME:

Name EmpID ---- ----- Jill 1864 Jack 2121 Joan 4698 John 5463

Given the SAS data set WORK.EMP_DEPT:

EmpID Department ----- ----------

2121 Accounting 3567 Finance 4698 Marketing 5463 Accounting

The following program is submitted:

data WORK.ALL;

merge WORK.EMP_NAME(in=Emp_N) WORK.EMP_DEPT(in=Emp_D); by Empid;

if (Emp_N and not Emp_D) or (Emp_D and not Emp_N); run;