NO.27 The following SAS program is submitted:
proc freq data = class;
tables gender * age / <insert option here>;
run;
The following report is created: The FREQ Procedure Table of gender by age
Row Column
Gender ageFrequencyPercent Percent Percent F11110.0020.0050.00 12220.0040.0040.00 13220.0040.0066.67
Total550.00100.00 M11110.0020.0050.00 12330.0060.0060,00 13110.0020.0033.33
Total550.00100.00
Total11220.00100.00 12550.00100.00 13330.00100.00 Total10100.00
Which option correctly completes the program and creates the report?

NO.28 The following SAS DATA step is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
run;
The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5. Which one of the following is the length of the variable JOBCODE in the output data set?

NO.29 The following SAS program is submitted:

What types of variables are DayOfMonth, MonthOfYear, and Year?

NO.30 The following SAS program is submitted:
proc contents data = sashelp.class varnum; quit;
What does the VARNUM option print?

NO.31 The following SAS program is submitted:

What is the initial value of the variable Total in the following program?

NO.32 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?

NO.33 The following SAS program is submitted:
data WORK.OUTDS;
do until(Prod GT 6);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?

NO.34 Which one of the following SAS system options prevents the page number from appearing on a report?

NO.35 The following SAS program is submitted:
data WORK.PRODUCTS;
Prod=1;
do while (Prod LE 7);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?

NO.36 The following SAS program is submitted:

Which statement is true about the output data set?

NO.37 The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?

NO.38 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?

NO.39 The following SAS program is submitted:
Data_null_;
set old; put sales 1 sales2;
run;
Where is the output written?

NO.40 Given the SAS data set WORK.P2000:

And the SAS data set WORK.P2008: The following output is desired:


Which SAS program correctly combines the data?

NO.41 Given the raw data record in the file phone.txt:

Which SAS statement completes the program and results in a value of “James Stevens” for the variableFullName?

NO.42 Given the raw data file EMPLOYEE:
—-I—-1 0—I—-20—I—-30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile ’employee’;
input employee_name $ 1-4;
if employee_name = ‘Ruth’ then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is “Ruth”?

NO.43 The following SAS program is submitted:
data test;
set chemists;
itjobcode = ‘Chem2’
then description = ‘Senior Chemist’;
else description = ‘Unknown’;
run;
The value for the variable JOBCODE is:
JOBCODE
chem2
What is the value of the variable DESCRIPTION?

NO.44 This questions will ask you to provide two missing variable names.
The following SAS program is submitted:
data WORK.TOTAL;
set WORK.SALARY;
by Department Gender;
if First. <insert variable 1 here> then Payroll=0
Payroll+Wagerate;
if Last.<insert variable 2 here>;
run;
The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

NO.45 The SAS data set PETS is sorted by the variables TYPE and BREED.
The following SAS program is submitted:
proc print data = pets;
var type breed;
sum number;
run;
What is the result?

NO.46 Given the SAS data set PEPM.STUDENTS:
PERM.STUDENTS NAME AGE ————— Alfred 14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm ‘SAS data library’; data students; set perm.students;
file ‘file specification’;
put name $15. @5 age 2.;
run;
What is written to the output raw data file?

NO.47 The following output is created by the FREQUENCY procedure:

Which TABLES statement was used to completed the following program that produced the output?
proc freq data=sales;
<_insert_code_>
run;

NO.48 Given the following raw data records in TEXTFILE.TXT:

The following output is desired:

Which SAS program correctly produces the desired output?