A00-201 Online Practice Questions and Answers

The following SAS program is submitted:

proc means data = sasuser.houses std mean max; var sqfeet run;

Which one of the following is needed to display the standard deviation with only two decimal places?

A. Add the option MAXDEC = 2 to the MEANS procedure statement.

B. Add the statement MAXDEC = 7.2; in the MEANS procedure step.

C. Add the statement FORMAT STD 7.2; in the MEANS procedure step.

D. Add the option FORMAT = 7.2 option to the MEANS procedure statement.

The following SAS DATA step is submitted:

libname temp `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.

The following SAS program is submitted:

data work.report; 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 WORKSALES_INFO are written to the WORKREPORT data set?

A. 2

B. 3

C. 6

D. 9

The following SAS program is submitted:

data work january;

set work.allmonths (keep = product month num_sold cost); if month = `Jan' then output work.january;

sales = cost * num_sold; keep product sales;

run;

Which variables does the WORK.JANUARY data set contain?

A. PRODUCT and SALES only

B. PRODUCT, MONTH, NUM_SOLD and COST only

C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only

D. An incomplete output data set is created due to syntax errors.

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

A comma delimited raw data tile needs to be created from the PERM.JAN_SALES data set.

VARIABLE NAME TYPE idnum character variable sales_date numeric date value

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: mmddyy10.; run;

B. libname perm `SAS-data-library'; data_null_; set perm.jan_sales; file `file-specification' dIm = `,'; put idnum sales_date : mmddyy10.; run;

C. libname perm `SAS-data-library'; data_null_; set perm.jan_sales; file `file-specification'; put idnum sales_date : mmddyq10.dIm = `,'; run;

D. libname perm `SAS-data-library"; data_null_; set perm jan_sales; file `file-specification'; put idnum sales_date: mmddyy10. dsd = `,'; put idnum sales_date: mmddw10. dsd = `,'; run;

The contents or the raw data rile AMOUNT are listed below:

----|----10----|----20----|----30 $1,234

The following SAS program is submitted:

data test; infile `amount'; input@1 salary 6.; run;

Which one of the following is the value or the SALARY variable?

A. 1234

B. 1,234

C. $1,234

D. . (missing numeric value)

The following SAS program is submitted:

data work.company; set work.dept1(keep = jobcode) work.dept2(rename (jcode = jobcode)); run;

Which one of the following is the result?

A. The variable JCODE is written to the output data set.

B. The variable JOBCODE is written to the output data set.

C. Neither variable JOODE nor JOBCODE is written to the output data set.

D. The program fails to execute due to errors.

The following SAS program is submitted:

proc datasets lib = sasuser; contents data = class varnum; quit;

Which one of the following is the purpose of the VARNUM option?

A. to print a list of variable names

B. to print the total number of variables

C. to print a list of the variables in alphabetic order

D. to print a list of the variables in the order they were created

The following SAS program is submitted:

data revenue; set year_1; var1 = mdy(1,15,i960); run;

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

A. 14

B. 15

C. 1151960

D. `1/15/1960'

The following SAS program is submitted:

data numrecords;

mule `file-specification';

mnput@1 patient $15.

relative$ 16-26@;

if relative = `children' then

input @54 diagnosis $15. @;

else if relative = `parents' then

input @28 doctor $15.

clinic $ 44-53

@54 diagnosis $15. @;

input age;

run;

How many raw data records are read during each iteration of the DATA step during execution?

A. 1

B. 2

C. 3

D. 4