A00-211 practice questions, page 7 of 11, with answer review and explanations.
Question 31
Given the AIRPLANES data set - AlRPLANES - TYPE MPG - -------- ------ F-18 105 - C-130 25 - Harrier 75 - A-6 110 - The following SAS program is submitted: data gt100; set airplanes(keep = type mpg load); load = mpg * 150; run; The program fails to execute due to syntax errors. What is the cause of the syntax error?
MPG is not a numeric variable.
LOAD is not a variable in the data set GT100.
LOAD is not variable in the data set AIRPLANES.
LOAD must be defined prior to the SET statement.
Question 32
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"?
11
22
33
(missing numeric value)
Question 33
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?
A LIBNAME statement for the libref TEMP only must be submitted.
A LIBNAME statement for the libref SASUSER only must be submitted.
LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
No LIBNAME statement needs to be submitted.
Question 34
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?
LOCALFEE has format of 9. and COUNTRYFEE has a format of 7.
LOCALFEE has format of 9. and COUNTRYFEE has a format of percent6.
LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.
The data step fails execution; there is no format for LOCALFEE
Question 35
The following SAS program is submitted: proc freq data = class; tables gender * age / ; 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?