SAS Base Programming for SAS 9 v1.0

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"?

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?

The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable
COUNTRYFEE with a format or 7.;
The following SAS program is submitted:
data history;
format local fee country fee percent6.;
set realestate;
local fee = local fee / 100;
country fee = country fee / 100;
run;
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

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 age Frequency Percent Percent Percent
F 11 1 10.00 20.00 50.00
12 2 20.00 40.00 40.00
13 2 20.00 40.00 66.67

Total 5 50.00 100.00 -
M 11 1 10.00 20.00 50.00
12 3 30.00 60.00 60,00
13 1 10.00 20.00 33.33

Total 5 50.00 100.00 -
Total 11 2 20.00 100.00
12 5 50.00 100.00
13 3 30.00 100.00

Total 10 100.00 -
Which option correctly completes the program and creates the report?

The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?

Given the raw data file YEARAMT:
----|---10---|---20---|----30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted:
data coins;
infile "˜yearamt"™;
input year quantity;
<insert statement(s) here>
run;
Which statement(s) completed the program and produced a non-missing value for the variable
TOTQUANTITY in the final observation of the output data set?

Given the SAS data set EMPLOYEE INFO:

EMPLOYEE_INFO -

IDNumber -
2542
100.00
3612
133.15
2198
234.34
2198
111.12
The following SAS program is submitted:
proc sort data = employee_info;
<insert BY statement here>
run;
Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

The following SAS program is submitted:
proc format
value score 1 - 50 = "˜Fail"™
51 - 100 = "˜Pass"™;
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?

What is the purpose or the MISSOVER option on the INFILE statement?

The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?

Which statement describes a characteristic of the SAS automatic variable _ERROR_?

Given the following raw data record:
07Jan2005
Which INFORMAT reads this raw data and stores it as a SAS date value?

Which statement correctly computes the average of four numerical values?

The following SAS program is submitted:
libname temp "˜SAS data library"™;
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?