Want to know Pass4sure A00-211 Exam practice test features? Want to lear more about SAS Institute SAS Base Programming for SAS ® 9 certification experience? Study High quality SAS Institute A00-211 answers to Replace A00-211 questions at Pass4sure. Gat a success with an absolute guarantee to pass SAS Institute A00-211 (SAS Base Programming for SAS ® 9) test on your first attempt.
Q49. You're attempting to read a raw data file and you see the following messages displayed in the SAS Log: What does it mean?
A. A compiler error, triggered by an invalid character for the variable Salary.
B. An execution error, triggered by an invalid character for the variable Salary.
C. The 1st of potentially many errors, this one occurring on the 4th observation.
D. An error on the INPUT statement specification for reading the variable Salary.
Answer: B
Q50. The contents of the raw data file AMOUNT are listed below:
--------10-------20-------30
$1,234
The following SAS program is submitted:
data test;
infile 'amount'
input @1 salary 6.;
if _error_ then description = 'Problems'
else description = 'No Problems'
run;
Which one of the following is the value of the DESCRIPTION variable?
A. Problems
B. No Problems
C. ' ' (missing character value)
D. The value can not be determined as the program fails to execute due to errors.
Answer: A
Q51. 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?
A. numeric, 8 bytes
B. numeric, 10 bytes
C. character, 8 bytes
D. character, 10 bytes
Answer: D
Q52. The following SAS program is submitted:
proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;
run;
Click on the Exhibit button to view the report produced.
style bedrooms baths price
CONDO 2 1.5 80050
3 2.5 79350
4 2.5 127150
2 2.0 110700 RANCH 2 1.0 64000
3 3.0 86650
3 1.0 89100
1 1.0 34550 SPLIT 1 1.0 65850
4 3.0 94450
3 1.5 73650 TWOSTORY 4 3.0 107250
2 1.0 55850
2 1.0 69250
4 2.5 102950
Which of the following SAS statement(s) create(s) the report?
A.
id style;
B.
id style;
var style bedrooms baths price;
C.
id style;
by style;
var bedrooms baths price;
D.
id style;
by style;
var style bedrooms baths price;
Answer: C
Q53. The following SAS program is submitted:
libname rawdata1 'location of SAS data library'
filename rawdata2 'location of raw data file'
data work.testdata;
infile
input sales1 sales2;
run;
Which one of the following is needed to complete the program correctly?
A. rawdata1
B. rawdata2
C. 'rawdata1'
D. 'rawdata2'
Answer: B
Q54. A raw data file is listed below:
RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH'
input sqfeet bedrooms baths street $ price : dollar10.;
run;
How many observations will the output data set contain?
A. 0
B. 3
C. 5
D. 7
Answer: B
Q55. What is the purpose or the MISSOVER option on the INFILE statement?
A. It prevents SAS from loading a new record when the end of the current record is reached.
B. It enables SAS to scan the input data records until the character string that is specified in the @‘character-string’ expression is round.
C. It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement.
D. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement.
Answer: A
Q56. The following SAS DATA step executes on Monday, April 25, 2000:
data newstaff;
set staff;
start_date = today();
run;
Which one of the following is the value of the variable START_DATE in the output data set?
A. a character string with the value '04/25/2000'
B. a character string with the value 'Monday, April 25, 2000'
C. the numeric value 14725, representing the SAS date for April 25, 2000
D. the numeric value 04252000, representing the SAS date for April 25, 2000
Answer: C