A00-211 Online Practice Questions and Answers
The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
A. 0
B. 1
C. 5
D. 60
Given the following raw data record:
----I----10---I----20---I----30 son Travis, The following output is desired: Obs relation firstname 1 son Travis
Which SAS program correctly reads in the raw data?
A. data family ( dIm = `,'); infile `tile 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;
The following SAS program is submitted:
data work.accounting; set work.department; length jobcode $ 12; jobcode='FAl'; run;
The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5. What is the result?
A. The length of the variable JOBCODE is 3.
B. The length of the variable JOBCODE is 5.
C. The length of the variable JOSBODE is 12.
D. The program fails to execute due to errors.
The following SAS program is submitted:
data work.passengers;
if OrigPassengers = . then'
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
TotalPassengers = sum (OrigPassengers, TransPassengers) +0;
run;
What is the value of the TOTALPASSENGERS variable in the output data set?
A. 0
B. 100
C. 200
D. (missing numeric value)
Given the SAS data set ONE:
ONE Obs Dte
1 09JAN2005
2 12JAN2005
The following SAS program is submitted:
data two;
set one;
day =
format dte date9.;
run;
The data set TWO is created:
TWO
Obs Dte Day
1 09JAN2005 1
12 JAN2005 4
Which expression successfully completed the program and created the variable DAY?
A. day(dte)
B. weekday(dte)
C. dayofweek(dte)
D. datdif(dte,'01jan2005'd,'act/act')
The following SAS program is submitted:
What new variables are created?
A. Difcount1, Difcount2 and Difcount3
B. Diff1, Diff2 and Diff3
C. Janpt, Febpt, and Marpt
D. Patients1, Patients2 and Patients3
Given the following data step:
After data step execution, what will data set WORK.GEO contain?
A. Option A
B. Option B
C. Option C
D. Option D
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?
B. 2
C. 5
D. 6
The following SAS program is submitted:
What is the result?
A. The value of the variable Discount in the output data set is 2000. No messages are written to the SAS log.
B. The value of the variable Discount in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
C. The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.
D. The variable Discount in the output data set is set to zero. No messages are written to the SAS log.
The following SAS program is submitted:
Data WORK.COMPRESS; ID = `1968 05-10 567'; NewID = compress (ID, "-"); run;
What will the value of NewID be in the WORK.COMPRESS data set?
A. 1968 05-10 567
B. 19680510567
C. 196805-10567
D. 1968 0510 567