The following SAS program is submitted:
Data_null;
set old (keep = prod sales 1 sales2);
file `file-specification';
put sales1 sales2; run;
Which one of the following default delimiters separates the fields in the raw data file created?
A. : (colon)
B. (space)
C. , (comma)
D. ; (semicolon)
The SAS data set WORK.AWARDS is listed below:
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the following represents how the observations are sorted?
A. Wang 3 Gerard 3 Wang 2 Amy 2 Wang 1 Amy 1
B. Wang 3 Wang 2 Wang 1 Gerard 3 Amy 2 Amy 1
C. Wang 3 Wang 1 Wang 2 Gerard 3 Amy 2 Amy 1
D. Wang 1D.Wang 1 Wang 2 Wang 3 Gerard 3 Amy 1 Amy 2
The SAS data set named COMPANY.PRICES is listed below:
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?
A. 0
B. 2
C. 4
D. 6
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 one of the following represents the values of the AMOUNT and WORD variables?
A. amount word 5 DOG
B. amount word 5 CAT
C. amount word 7 DOG
D. amount word 7 " " (missing character value)
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;
The following SAS program is submitted:
proc sort data=work.employee;
by descending fname;
proc sort data=work.salary;
by descending fname;
data work.empdata;
merge work.employee
work salary;
by fname;
run;
Which one of the following statements explains why the program failed execution?
The SORT procedures contain invalid syntax.
The merged data sets are not permanent SAS data sets. The data sets were not merged in the order by which they were sorted. The RUN statements were omitted after each of the SORT procedures.
A.
B.
C.
D.
Which one of the following ODS statement options terminates output being written to an HTML file?
A. END
B. QUIT
C. STOP
D. CLOSE
On which portion(s) of a SAS data set does the PRINT procedure report?
A. the data portion only
B. the descriptor portion only
C. the descriptor portion and the data portion
D. neither the data portion nor the descriptor portion
The following SAS program is submitted:
data work.one;
x = 3;
y = 2;
z = x ** y;
Which one of the following is the value of the variable Z in the output data set?
A. 6
B. 9
C. (missing numeric value)
D. The program tails to execute due to errors.
The SAS data set BANKS is listed below:
BANKS
name rate
FirstCapital 0.0718
DirectBank 0.0721
VirtualDirect 0.0728
The following SAS program is submitted:
data newbank;
do year = 1 to 3;
set banks;
capital + 5000;
end;
run;
Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?
A. 0 observations and 0 variables
B. 1 observations and 4 variables
C. 3 observations and 3 variables
D. 9 observations and 2 variables
