最新なSASInstitute A00-211問題集（275題）、真実試験の問題を全部にカバー！

質問 1：
The following SAS program is submitted:
data work.totalsales (keep = monthsales{12} );
set work.monthlysales (keep = year product sales);
array monthsales {12} ;
do i=1 to 12;
monthsales{i} = sales;
end;
run;
The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?
A. The program executes with warnings and creates the WORK.TOTALSALES data set.
B. The program fails execution due to syntax errors.
C. The program executes without errors or warnings and creates the WORK.TOTALSALES data set
D. The program fails execution due to data errors.
正解：B

質問 2：
Given the SAS data set WORK.ORDERS:

The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".
Which of the following statement will correctly create the value and assign it to ship_note?
A. ship_note=catx(' ','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);
B. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);
C. ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);
D. ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);
正解：B

質問 3：
The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile 'file specification';
input num chars$;
run;
ONE
NUMCHAR
----------------
123
323
177
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?
A. No output is generated.
B. NUM CHAR1 772
C. NUM CHAR1 233 231 77
D. NUM CHAR1 233 23
正解：A

質問 4：
The contents of the raw data file EMPLOYEE are listed below:
--------10-------20-------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 = 'Sue' then input age 7-8;
else input idnum 10-11;
run;
Which one of the following values does the variable AGE contain when the name of the employee is "Sue"?
A. 40
B. 33
C. . (missing numeric value)
D. 30
正解：A

質問 5：
The following SAS program is submitted:
Data WORK.COMPRESS;
ID = '1968 05-10 567';
NewID = compress (ID, "-");
run;
What will the value of NewID be in the WORK.COMPRESS data set?
A. 1968 05-10 567
B. 19680510567
C. 1968 0510 567
D. 196805-10567
正解：A

質問 6：
Which one of the following SAS system options prevents the page number from appearing on a report?
A. NONUMBER
B. NOPAGENUM
C. NOPAGE
D. NONUM
正解：A

質問 7：
Given the data set WORK.DEPARTMENTS:

The following SAS program is submitted:

Which output will be generated?
正解：
Pending

質問 8：
Given the following code:
proc print data=SASHELP.CLASS(firstobs=5 obs=15);
where Sex='M';
run;
How many observations will be displayed?
A. 11 or fewer
B. 10 or fewer
C. 11
D. 15
正解：A