SAS Exam questions with complete solutions

SAS Exam questions with complete
solutions

The following SAS program is submitted:

data work. New;

length word $7;

amount = 7;

if amount = 5 then word 'CAT';

else if amount = 7 then word = 'DOG';

else word = 'NONE!!!';

amount = 5;

run;



Which of the following represents the values of the AMOUNT and WORD variables? - correct
answer ✔✔ amount word

5 DOG



The following SAS program is submitted:

data work.sets

do until (prod gt 6);

prod + 1;

end;

run;



What is the value of the variable PROD in the output data set? - correct answer ✔✔ 7

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

----|----10---|----20---|----30

24613$25.31



The following SAS program is submitted:

data inventory;

infile 'product';

input idnum 5. @10 price;

run;

What is the value of the PRICE variable? - correct answer ✔✔ (missing numeric value)



The following SAS program is submitted:

proc print data = sasuser.houses;

run;

<insert OPTIONS statement here>

proc means data = sasuser.shoes;

run;

What OPTIONS statement resets the page number to 1 for the second report? - correct answer
✔✔ options pageno=1;



A raw data record is listed below:

----|----10---|----20---|----30

son,Travis,



The following output is desired:

,relation firstname

son Travis



What SAS program reads the data correctly? - correct answer ✔✔ data.family;

infile 'file-specification' dlm=',',

input relation $ firstname $;

run;



The following SAS program is submitted and reads 100 records from a raw data file:

data work.total;

infile 'file-specification' end = eof;

input name $ salary;

totsal + salary;

<insert IF statement here>

run;



What IF statement writes the last observation to the output data set? - correct answer ✔✔ if
eof = 1



The following SAS DATA step executes Monday, April 25, 2000:

data newstaff;

set staff;

start_date = today();

run;



What is the value of the variables START_DATE in the output data set? - correct answer ✔✔ the
numeric value 124725, representing the SAS date for April 25, 2000

, The following SAS program is submitted:

data revenue;

set year_1;

var1 = mdy(1,15,1960);

run;



What value does the variable named VAR1 contain? - correct answer ✔✔ 14



The SAS data set named COMPANY.PRICES is listed below:



COMPANY.PRICES

prodidpriceproduttype sales returns

K12S 5.10 NETWORK 15 2

B132S 2.34 HARDWARE 300 10

R18KY2 1.29 SOFTWARE 25 5

3KL8BY 6.37 HARDWARE 125 15

DY65DW 5.60 HARDARE 45 5

DGTY 4.55 HARDWARE 67 2



The following SAS program is submitted:



libname company 'SAS-data-library';

data hware inter soft;

set company.prices (keep = producttype price);

if price le 5.00;