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 program is submitted;

data work.month; date = put('13mar2000'd,ddmmw10.); run;

Which one of the following represents the type and length of the variable DATE in the output data set?

A. numeric, 8 bytes

B. numeric, 10bytes

C. character, 8 bytes

D. character, 10 bytes

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 numrecords;

infile `file-specification';

input@1 patient $15.

relative$ 16-26@;

if relative = `children' then

input diagnosis $15. @;

else if relative = `parents' then

input @28 doctor $15.

clinic $ 44-53

@54diagnosis $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

The following SAS DATA step is submitted:

data work.accounting; set work.department; length jobcode $ 12; run;

The WORK.DEPARTMENT SAS data set contains a character variable named JOSCODE with a length of 5.

Which one of the following is the length of the variable JOSCODE in the output data set?

A. 5

B. 8

C. 12

D. The length can not be determined as the program fails to execute due to 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 following SAS program is submitted:

data work.products;

Product_Number = 5461;

Item = `1001';

Item_Reference = ltem||'/'IlProduct_Number; run;

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

A. 1001/5461

B. 1001/ 5461

C. . (missing numeric value)

D. The value can not be determined as the program fails to execute due to errors.

The following SAS program is submitted:

proc report data = work.houses nowd;

column style price;

where price < 100000;

title;

run;

Click the Exhibit button to view the output from the REPORT procedure.

Assume permanent variable labels have been assigned.

Which one of the following completes the program and produces the output displayed in the exhibit?

A. define style / display width = 9; define price / sum format = comma9. width = 10;

B. define style / width = 9; define price / sum format = comma9. width = 10;

C. define style / group width = 9; define price / sum format = comma9. width = 10;

D. define style / order width = 9; define price / sum format = comma9. width = 10;

The following SAS DATA step is submitted:

data sasdata.atlanta

sasdata.boston

work.portland work.phoenix;

set company.prdsales;

if region = `NE' then output boston;

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.

The following SAS program is submitted: I

ibname company `SAS-data-library';

proc sort data = company.payroll;

by EmployeelDNumber;

run;

Write access has been granted to the COMPANY library.

Which one of the following represents how the observations are sorted?

A. COMPANY.PAYROLL is recreated in sorted order by EmployeelDNumber.

B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeelDNumber.

C. COMPANYPAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeelDNumber.

D. COMPANY.PAYROLL is recreated in sorted order by EmployeelDNumber, and a new data set PAYROLL is created in sorted order by Emp loyeelDNumber.