A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx. Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel workbook. However, the Excel workbook already contains a worksheet named outdata.
What will happen?
A. The program will produce an error message indicating that the exceldata.xlsx workbook already exists.
B. A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.
C. The program will overwrite the outdata worksheet in the exceldata.xlsx workbook.
D. A second worksheet outdata(2) will be added to the existing exceldata.xlsx workbook.
正解:B
質問 2:
Given the following SAS data set WORK.CLASS:
Name Gender Age
Anna F 23
Ben M 25
Bob M 21
Brian M 27
Edward M 26
Emma F 32
Joe M 34
Sam F 32
Tom M 24
The following program is submitted: data WORK.MALES WORK.FEMALES(drop=age); set WORK.CLASS; drop gender; if Gender="M" then output WORK.MALES; else if Gender="F" then output WORK.FEMALES; run; How many variables are in the data set WORK.MALES?
Select one:
A. 1
B. 3
C. The program does not execute due to a syntax error.
D. 2
正解:D
質問 3:
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. Ipswic h, England
D. Ipswich, 'England'
正解:B
質問 4:
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price".
Which SAS program temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?
A. proc print data = sasuser.houses label; label price = "Sale Price"; run;
B. proc print data = sasuser.houses; price = "Sale Price"; run;
C. proc print data = sasuser.houses; label price = "Sale Price"; run;
D. proc print data = sasuser.houses label; label price "Sale Price"; run;
正解:A
質問 5:
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:

Which statement is true?
A. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.
B. The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.
C. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
D. The by statement in the DATA step causes a syntax error.
正解:B
1203 お客様のコメント
クリック」





铃木** -
A00-231の比較的高度な知識、最新事例など深く広く問われますねぇ