A00-201 Online Practice Questions and Answers
The contents of the raw data file CALENDAR are listed below:
----|----10----|----20----|----30
The following SAS program is submitted:
data test;
infile `calendar';
input@1 date mmddyy10.;
if date = `01012000'd then event = `January 1st;
run;
Which one of the following is the value of the EVENT variable?
A. 01012000
B. January 1st
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:
data allobs;
set sasdata.origin (firstobs = 75 obs = 499);
run;
The SAS data set SASDATADRIGIN contains 1000 observations.
How many observations does the ALLOBS data set contain?
A. 424
B. 425
C. 499
D. 1000
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 SASS program is submitted:
data work.sales;
do year = 1 to 5;
do month = 1 to 12;
x+ 1;
end;
run;
Which one of the following represents how many observations are written to the WORK SALES data set?
A. 0
B. 1
C. 5
D. 60
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 following SAS program is submitted:data work.passengers;
data work.passengers;
if OrigPassengers = then
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
NonPaying = 10;
TotalPassengers = OrigPassengers + TransPassengers; run;
Which one of the following is the value of the TOTALPASSENGERS variable in the output data set?
A. 100
B. 110
C. 200
D. (missing numeric value)
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:
proc freq data = sales;
Click the Exhibit button to view the output from the FREQ procedure.
Which one of the following statements completes the program and produces the output?
A. tables region product
B. tables region * product
C. tables product region;
D. tables product * region;
The following SAS program is submitted:
data revenue; set year_1; var1 = mdy(1,15,i960); run;
Which one of the following values does the variable named VAR1 contain?
A. 14
B. 15
C. 1151960
D. `1/15/1960'
The following SAS program is submitted:
data work.test;
Title = `A Tale of Two Cities, Charles J. Dickens'; Word = scan(title,3,' ,`);
run;
Which one of the following is the value of the variable WORD in the output data set?
A. T
B. of
C. Dickens
D. ``(missing character value)