SASInstitute SAS base programming 認定 A00-201 試験問題:
1. The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;
< insert DO statement here>
total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?
A) do weekly{i} = 1 to 5;
B) A DO loop cannot be used because the variables referenced do not end in a digit.
C) do i = 1 to 5;
D) do i = mon tue wed thu fri;
2. The following SAS program is submitted:
footnote1 'Sales Report for Last Month';
footnote2 'Selected Products Only';
footnote3 'All Regions';
footnote4 'All Figures in Thousands of Dollars';
proc print data = sasuser.shoes;
footnote2 'All Products';
run;
Which one of the following contains the footnote text that is displayed in the report?
A) Sales Report for Last Month
All Products
B) Sales Report for Last Month
All Products
All Regions
All Figures in Thousands of Dollars
C) All Products
D) All Products
All Regions
All Figures in Thousands of Dollars
3. The following SAS DATA step is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
run;
The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5.
Which one of the following is the length of the variable JOBCODE in the output data set?
A) 5
B) The length can not be determined as the program fails to execute due to errors.
C) 8
D) 12
4. The following SAS program is submitted:
data work.totalsales;
set work.monthlysales(keep = year product sales);
retain monthsales {12} ;
array monthsales {12} ;
do i = 1 to 12;
monthsales{i} = sales;
end;
cnt + 1;
monthsales{cnt} = sales;
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 fails execution due to syntax errors.
B) The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.
C) The program fails execution due to data errors.
D) The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations.
5. CORRECT TEXT
The contents of the raw data file TYPECOLOR are listed below:
----|----10---|----20---|----30
daisyyellow
The following SAS program is submitted:
data flowers;
infile 'typecolor';
input type $ 1-5 +1 color $;
run;
Which one of the following represents the values of the variables TYPE and COLOR?
質問と回答:
質問 # 1 正解: C | 質問 # 2 正解: A | 質問 # 3 正解: A | 質問 # 4 正解: A | 質問 # 5 正解: メンバーにのみ表示されます |