A.
SAS views can access the most current data in files that are frequently updated.
B.
SAS views can avoid storing a SAS copy of a large data file.
C.
SAS views can decrease programming time.
D.
both A and B are true
Item 18 of 63 Mark item for review
In what order does SAS search for format definitions by default?
A.
1. WORK.FORMATS 2. LIBRARY.FORMATS
B.
1. LIBRARY.FORMATS 2. WORK.FORMATS
C.
There is no default order,
it must be defined by the user.
D.
All user defined libraries that have a catalog named FORMATS, in alphabetic order.
Item 19 of 63 Mark item for review
Given the dataset WORK.STUDENTS:
Name Age ------- --- Mary 15 Philip 16 Robert 12 Ronald 15
The following SAS program is submitted:
%let Value=Philip;
proc print data=WORK.STUDENTS; [_insert_WHERE_statement_] run;
Which WHERE statement successfully completes the program and produces a report?
A.
where upcase(Name)=upcase(&Value);
B.
where upcase(Name)=%upcase(&Value);
C.
where upcase(Name)=\
D.
where upcase(Name)=\
Item 20 of 63 Mark item for review
The following SAS program is submitted:
data WORK.TEMP;
length A B 3 X; infile RAWDATA; input A B X; run;
What is the length of variable A?
A. 3
B. 8
C.
WORK.TEMP is not created - X has an invalid length.
D. Unknown.
Item 21 of 63 Mark item for review
The following SAS program is submitted:
data WORK.NEW;
do i=1, 2, 3;
Next=cats('March' || i ); infile XYZ filevar=Next end=Eof; do until (Eof);
input Dept $ Sales; end; end; run;
The purpose of the FILEVAR=option on the INFILE statement is to name the variable
Next, whose value:
A.
points to a new input file.
B.
is output to the SAS data set WORK.NEW.
C.
is an input SAS data set reference.
D.
points to an aggregate storage location.
Item 22 of 63 Mark item for review
Given the following partial SAS log:
NOTE: SQL table SASHELP.CLASS was created like:
create table SASHELP.CLASS( bufsize=4096 ) (
Name char(8), Sex char(1), Age num, Height num, Weight num );
Which SQL procedure statement generated this output?
A.
CONTENTS FROM SASHELP.CLASS;
B.
CREATE FROM SASHELP.CLASS INTO LOG;
C.
DESCRIBE TABLE SASHELP.CLASS;
D.
VALIDATE SELECT * FROM SASHELP.CLASS;
Item 23 of 63 Mark item for review
Given the SAS data set SASUSER.HIGHWAY:
Steering Seatbelt Speed Status Count -------- -------- ----- ------- ----- absent No 0-29 serious 31 absent No 0-29 not 1419 absent No 30-49 serious 191 absent no 30-49 not 2004 absent no 50+ serious 216
The following SAS program is submitted:
%macro SPLIT; proc sort
data=SASUSER.HIGHWAY
out=WORK.UNIQUES(keep=Status) nodupkey; by Status; run;
data _null_;
set uniques end=Lastobs;
call symputx('Status'||left(_n_),Status); if Lastobs then call symputx('Count',_n_); run;
%local i; data
%do i=1 %to &count; [_insert_reference_] %end; ;
