SAS base 123 训练题 免费

A00-201

merge work.employee work.salary; by fname; run;

Which one of the following statements explains why the program failed execution?

A. The SORT procedures contain invalid syntax.

B. The merged data sets are not permanent SAS data sets.

C. The data sets were not merged in the order by which they were sorted. D. The RUN statements were omitted after each of the SORT procedures.

Answer: C

QUESTION 21

The following SAS SORT procedure step generates an output data set: proc sort data = sasuser.houses out = report; by style; run;

In which library is the output data set stored?

A. WORK B. REPORT C. HOUSES D. SASUSER

Answer: A

QUESTION 22

The following SAS DATA step is submitted: libnametemp 'SAS-data-library'; data temp.report; set sasuser.houses; newvar= price * 1.04; run;

Which one of the following statements is true regarding the program above?

A. The program is reading from a temporary data set and writing to a temporary data set. B. The program is reading from a temporary data set and writing to a permanent data set. C. The program is reading from a permanent data set and writing to a temporary data set. D. The program is reading from a permanent data set and writing to a permanent data set.

Answer: D

QUESTION 23

Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

Actualtests.com - The Power of Knowing

A00-201

A. libname sasdata 'SAS-data-library'; data sasdata.mydata; copy mydata; run;

B. libname sasdata 'SAS-data-library'; data sasdata.mydata; keep mydata; run;

C. libname sasdata 'SAS-data-library'; data sasdata.mydata; save mydata; run;

D. libname sasdata 'SAS-data-library'; data sasdata.mydata; set mydata; run;

Answer: D

QUESTION 24

The following SAS DATA step is submitted: data sasdata.atlanta sasdata.boston work.portland work.phoenix;

set company.prdsales;

if region = 'NE' then output bostan; if region = 'SE' then output atlanta; if region = 'SW' then output phoenix; if region = 'NW' then output portland; run;

Which one of the following is true regarding the output data sets?

A. No library references are required.

B. The data sets listed on all the IF statements require a library reference. C. The data sets listed in the last two IF statements require a library reference. D. The data sets listed in the first two IF statements require a library reference.

Answer: D

QUESTION 25

The following SAS DATA step executes on Monday, April 25, 2000: data newstaff; set staff;

start_date=today();

Actualtests.com - The Power of Knowing

A00-201

run;

Which one of the following is the value of the variable START_DATE in the output data set?

A. a character string with the value '04/25/2000'

B. a character string with the value 'Monday, April 25, 2000'

C. the numeric value 14725, representing the SAS date for April 25, 2000 D. the numeric value 04252000, representing the SAS date for April 25, 2000

Answer: C

QUESTION 26

The following SAS program is submitted: data work.new; mon= 3; day = 23; year =2000;

date = mdy(mon,day,year); run;

Which one of the following is the value of the DATE variable?

A. a character string with the value '23mar2000' B. a character string with the value '03/23/2000'

C. a numeric value of 14692, which represents the SAS date value for March 23, 2000 D. a numeric value of 3232000, which represents the SAS date value for March 23, 2000

Answer: C

QUESTION 27

The following SAS program is submitted: data revenue; set year_1;

var1 = mdy(1,15,1960); run;

Which one of the following values does the variable named VAR1 contain?

A. 14 B. 15

C. 1151960 D. '1/15/1960'

Answer: A

QUESTION 28

The following SAS program is submitted: data work.report;

Actualtests.com - The Power of Knowing

A00-201

set work.sales_info; if qtr(sales_date) ge 3; run;

The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.

How many of the original twelve observations in WORK.SALES_INFO are written to the WORK.REPORT data set? A. 2 B. 3 C. 6 D. 9

Answer: C

QUESTION 29

The following SAS program is submitted:? libnametemp 'SAS-data-library'; data work.new; set temp.jobs;

format newdate mmddyy10.; qdate= qtr(newdate);

ddate= weekday(newdate); run;

proc print data = work.new; run;

The variable NEWDATE contains the SAS date value for April 15, 2000. What output is produced if April 15, 2000 falls on a Saturday?

A. Obs newdate qdate ddate 1 APR152000 2 6

B. Obs newdate qdate ddate 1 04/15/2000 2 6

C. Obs newdate qdate ddate 1 APR152000 2 7

D. Obs newdate qdate ddate 1 04/15/2000 2 7

Answer: D

QUESTION 30

A raw data record is shown below: 07Jan2002

Which one of the following informats would read this value and store it as a SAS date value?

Actualtests.com - The Power of Knowing

A00-201

A. date9.

B. ddmonyy9. C. ddMMMyy9. D. ddmmmyyyy9.

Answer: A

QUESTION 31

The contents of the SAS data set PERM.JAN_SALES are listed below: VARIABLE NAME TYPE idnumcharacter variable

sales_datenumeric date value

A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.

Which one of the following SAS DATA steps correctly creates this raw data file?

A. libname perm 'SAS-data-library'; data_null_;

set perm.jan_sales;

file 'file-specification' dsd = ',';

put idnum sales_date : mmddyy 10.; run;

B. libname perm 'SAS-data-library'; data_null_;

set perm.jan_sales;

file 'file-specification' dlm = ',';

put idnum sales_date : mmddyy 10.; run;

C. libname perm 'SAS-data-library'; data_null_;

set perm.jan_sales; file 'file-specification';

put idnum sales_date : mmddyy 10. dlm = ','; run;

D. libname perm 'SAS-data-library'; data_null_;

set perm.jan_sales; file 'file-specification';

put idnum sales_date : mmddyy 10. dsd = ','; run;

Answer: B

QUESTION 32

The contents of the SAS data set named PERM.STUDENTS are listed below:

Actualtests.com - The Power of Knowing