Question 16
The contents of the SAS data set PERM.JAN_SALES are listed below:
VARIABLE NAME TYPE
idnum character variable
sales_date numeric date value
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. 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?
Question 17
The following SAS program is submitted:
proc print data = sasuser.houses; run;
proc means data = sasuser.shoes; run;
Which one of the following OPTIONS statements resets the page number to 1 for the second report?
Question 18
The following SAS program is submitted:
data work.clients;
calls = 6;
do while (calls le 6);
calls + 1;
end; run;
Which one of the following is the value of the variable CALLS in the output data set?
Question 19
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?
Question 20
Given the SAS data set PERM.STUDENTS:
PERM.STUDENTS NAMEAGE ---------------- Alfred14 Alice13 Barbara13
Carol14
The following SAS program is submitted:
libname perm 'SAS data library';
data students;
set perm.students;
file 'file specification';
put name $ age;
<insert statement here>
run;
The following double-spaced file is desired as output
Alfred 14
Alice 13
Barbara 13
Carol 14
Which statement completes the program and creates the desired file?