A00-201 Online Practice Questions and Answers

The following SAS program is submitted:

data work.test;

array agents{4}$ 12 sales1 - sales4

run;

Which one of the following represents the variables that are contained in the output data set?

A. SALES1, SALES2, SALES3, SALES4

B. AGENTS1, AGENTS2, AGENTS3, AGENTS4

C. None, the DATA step fails because the ARRAY statement can reference only numeric data.

D. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.

The contents of the raw data file PRODUCT are listed below:

----I----10---I----20---I----30

24613 $25.31

The following SAS program is submitted:

data inventory; infile `product; input idnum 5. @10 price; run;

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

A. 25.31

B. $25.31

C. . (missing numeric value)

D. No value is stored as the program fails to execute due to errors.

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

proc sort data = sasuser.houses out = houses;

by style;

run;

proc print data = houses;

run;

Click on the Exhibit button to view the report produced.

Which of the following SAS statement(s) create(s) the report?

A. id style;

B. id style; var style bedrooms baths price;

C. id style; by style; var bedrooms baths price;

D. id style; by style; var style bedrooms baths price;

The SAS data sets WORKEMPLOYEE and WORKSALARY are shown below:

WORK.EMPLOYEE WORK.SALARY

fname age fname salary

Bruce 30 Bruce 25000

Dan 40 Bruce 35000

Dan 25000

The following SAS program is submitted:

data work.empdata;

by fname;

totsal + salary;

run;

Which one of the following statements completes the merge of the two data sets by the ENAME variable?

A. merge work.employee work.salary (fname = name);

B. merge work.employee work.salary (name = fname);

C. merge work.employee work.salary (rename = (fname = name));

D. merge work.employee work.salary (rename = (name = fname));

The following SAS program is submitted:

data work.pieces; do while (n It 6); n + 1; end; run;

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

A. 4

B. 5

C. 6

D. 7

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.

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

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

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

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

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

The contents of the raw data file TEAM are listed below:

----I----10---I----20---I----30

Janice 10

Henri 11

Michael 11

Susan 12

The following SAS program is submitted:

data group;

infile `team';

input name $15. age 2.;

file `file-specification';

put name $15. +5 age 2.;

run;

Which one of the following describes the output created?

A. a raw data file only

B. a SAS data set named GROUP only

C. a SAS data set named GROUP and a raw data file

D. No output is generated as the program fails to execute due to errors.

The following SAS program is submitted:

data work.month; d ate = input('13mar2000',date9.); 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, 9 bytes

C. character, 8 bytes

D. character, 9 bytes

The following SAS program is submitted:

proc means data = sasuser.shoes;

where product in (`Sandal' , `Slipper' , `Boot');

run;

Which one of the following ODS statements completes the program and sends the report to an HTML file?

A. ods html = `sales.html';

B. ods file = `sales.html';

C. ods file html = `sales.html';

D. ods html file = `sales.html';

A raw data record is listed below:

----I----10---I----20---I----30 s On, Travis,

The following output is desired:

relation fristname son Travis

Which one of the following SAS programs reads the data correctly?

A. data family/dIm = ` , `; infile `file-specification'; input relation $ firstname $; run;

B. options dIm = ` , `; data family; infile `file-specification'; input relation $ firstname $; run;

C. data family; infile `file-specification' dim = ` , `; input relation $ firstname $; run;

D. data family, infile `file-specification'; input relation $ firstname $ / dIm = ` , `; run;

A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000. Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?

A. proc print data = sasuser.houses; where price It 60000; where price gt 100000; run;

B. proc print data = sasuser.houses; where price It 60000 or price gt 100000; run;

C. proc print data = sasuser.houses; where price It 60000 and price gt 100000; run;

D. proc print data = sasuser.houses; where price It 60000 or where price gt 100000; run;

The following SAS program is submitted:

options pageno = 1;

proc print data = sasuser.houses;

run;

proc means data = sasuser.shoes;

run;

The report created by the PRINT procedure step generates 5 pages of output.

What is the page number on the first page of the report generated by the MEANS procedure step?

A. 1

B. 2

C. 5

D. 6

The following SAS program is submitted:

data work.test;

set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 - ditsales3;

array monthly{3} jansales febsales marsales;

run;

Which one of the following represents the new variables that are created?

A. JANSALES, FEBSALES and MARSALES

B. MONTHLY1, MONTHLY2 and MONTHLY3

C. DIFSALES1, DIFSALES2 and DIFSALES3

D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3