QUESTION 20
The following SAS program is submitted:

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

QUESTION 21
The following SAS program is submitted:
libname sasdata ‘SAS-data-library’;
data test;
set sasdata.chemists (keep = job_code);
if job_code = ‘chem3’
then description = ‘Senior Chemist’;
run;
The variable JOB_CODE is a character variable with a length of 6 bytes.
Which one of the following is the length of the variable DESCRIPTION in the output data set?

QUESTION 22
Which is a valid LIBNAME statement?

QUESTION 23
Given the raw data record DEPT:
—-|—-10—|—-20—|—-30
Printing 750
The following SAS program is submitted:
data bonus;
infile ‘dept’;
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?

QUESTION 24
Given the following raw data records:

The following output data set is desired:

Which SAS program correctly reads in the raw data?

QUESTION 25
The following SAS program is submitted:
data work.test;
First = ‘Ipswich, England’;
City_Country = substr(First,1,7)!!’, ‘!!’England’;
run;
Which one of the following is the length of the variable CITY_COUNTRY in the output data set?

QUESTION 26
The contents of the raw data file CALENDAR are listed below:
——–10——-20——-30
01012000
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?

QUESTION 27
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?

QUESTION 28
The following SAS program is submitted:
data work.month;
date = put(’13mar2000’d,ddmmyy10.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?

QUESTION 29
The contents of the raw data file SIZE are listed below:
——–10——-20——-30
72 95
The following SAS program is submitted:
data test;
infile ‘size’;
input @1 height 2. @4 weight 2;
run;
Which one of the following is the value of the variable WEIGHT in the output data set?

QUESTION 30
The following program is submitted:

Why does the program fail?

QUESTION 31
A user-defined format has been created using the FORMAT procedure.
How is it stored?

QUESTION 32
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;
Why does the program rail to execute?

QUESTION 33
By default, which variables and data values are used to calculate statistics in the MEANS procedure?

QUESTION 34
A raw data file is listed below:

How many observations will the WORK.HOMEWORK data set contain?

QUESTION 35
The following SAS program is submitted:

What is the result?

QUESTION 36
Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

QUESTION 37
Given the following data step:

After data step execution, what will data set WORK.GEO contain?

QUESTION 38
Which step displays a listing of all the data sets in the WORK library?