SAS EXAM QUESTIONS AND ANSWERS

SAS EXAM QUESTIONS AND
ANSWERS
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?
- 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? - 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? - 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? -
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? - 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? - 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? - 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? - 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;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER;
else if producttype = 'SOFTWARE' then output SOFT;
run;

How many observations does the HWARE data set contain? - answer- 2

The following SAS program is submitted:
data work.set;
set work.staff(keep = jansales febsales marsales);
array diff_sales{3} difsales1-difsales3;
array monthly{3} jansales febsales marsales;
run;

What represents the new variables that are created? - answer- DIFSALES1,
DIFSALES2, DIFSALES3

The following SAS program is submitted:
data work.test;
array agents{4} $ 12 sales1-sales4;
run;

What represents the variables that are contained in the output data set? - answer-
SALES1, SALES2, SALES3, SALES4

The observations in the SAS data set WORK.TEST are ordered by the values of the
variables SALARY. The following SAS program is submitted:
proc sort data = work.test out = work.testsorted;
by name;
run;

What is the result of the SAS program? - answer- The data set
WORK.TESTSORTED is stored in the ascending order by values of the NAME
variable.

The SAS data set WORK.AWARDS is listed below:
fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2