It is impossible to pass SAS Institute A00-211 exam without any help in the short term. Come to Actualtests soon and find the most advanced, correct and guaranteed SAS Institute A00-211 practice questions. You will get a surprising result by our Up to the minute SAS Base Programming for SAS ® 9 practice guides.
Q17. The following SAS program is submitted: data work.test;
First = 'Ipswich, England'
City = substr(First,1,7);
City_Country = City!!', '!!'England'
run;
Which one of the following is the value of the variable CITY_COUNTRY in the output data set?
A. Ipswich!!
B. Ipswich, England
C. Ipswich, 'England'
D. Ipswich, England
Answer: D
Q18. Which of the following programs correctly invokes the DATA Step Debugger?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C
Q19. The following SAS program is submitted:
libname temp ‘SAS data library’;
data work.new;
set temp.jobs;
format newdate mmddw10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new; run;
The variable NEWDATE contains the SAS date value for April 15. 2005. What output is produced if April 15, 2005 falls on a Friday?
A. Obsnewdate mdate ddate 104/15/2005 APR 6
B. Obs newdate mdate ddate 104/15/2005 4 6
C. Obs newdate mdate ddate 104/15/2005 APR 7
D. Obs newdate mdate ddate 104/15/2005 4 7
Answer: B
Q20. The following SAS program is submitted:
data revenue; set year_1; var1 = mdy(1,15,1960); run;
Which one of the following values does the variable named VAR1 contain?
A. 14
B. 15
C. 1151960
D. '1/15/1960'
Answer: A
Q21. The following output is created by the FREQUENCY procedure:
Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?
A. norowcount nocolcount
B. freq percent
C. norow nocol
D. nocounts
Answer: C
Q22. 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. A LIBNAME statement for the libref TEMP only must be submitted.
B. A LIBNAME statement for the libref SASUSER only must be submitted.
C. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
D. No LIBNAME statement needs to be submitted.
Answer: A
Q23. Which is a valid LIBNAME statement?
A. libname "_SAS_data_library_location_";
B. sasdata libname "_SAS_data_library_location_";
C. libname sasdata "_SAS_data_library_location_";
D. libname sasdata sas "_SAS_data_library_location_";
Answer: C
Q24. After a SAS program is submitted, the following is written to the SAS log:
What changes should be made to the KEEP statement to correct the errors in the LOG?
A. keep=(Product Sales);
B. keep Product, Sales;
C. keep=Product, Sales;
D. keep Product Sales;
Answer: D