SASInstitute A00-215 問題集

質問 1：
What happens when you submit the code shown below?
data table1 table2;
set sashelp.shoes;
output;
run;
A. Each observation in sashelp. shoes is written to table1 only.
B. The program does not run because there is no data set specified on the OUTPUT statement.
C. Each observation in sashelp. shoes is written to both table1 and table2.
D. Each observation is written twice to table1 and table2.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
The sashelp. class data set has 19 observations.
Given the frequency information about the Age, shown below:

How many observations are written to output data set when the following code is submitted?
A. preteen will have 7 observations and teen will have 12 observations
B. preteen will have 10 observations and teen will have 9 observations
C. preteen will have 7 observations and teen will have 19 observations
D. preteen will have 26 observations and teen will have 31 observations
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Given the input data sets EMPLOYEES and DONATIONS, and the output data set NODONATIONS below:


A. data nodonations;
merge employees (in-inE) donations (in=inD);
by employee_id;
if inE=1 and inD-0;
run;
B. data nodonations;
merge employees (in-inE) donations (in=inD);
by employee_id;
if inE=0 and inD-0;
run;
C. data nodonations;
merge employees (in-inE) donations (in=inD);
by employee_id;
run;
D. data nodonations;
merge employees (in-inE) donations (in=inD);
by employee_id;
if inE=1 and inD-1;
run;
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which program correctly subnets the SASHELP. BASEBALL data set to include only the players in the East Division with 75 or more hits?

A. data bball;
set sashelp.baseball;
where Division = 'East';
where nHits >= 75;
run;
B. data bball;
set sashelp.baseball;
where Division - 'East' or nHits >= 75;
run;
C. data bball;
set sashelp.baseball;
where Division = 'East' and nHits >= 75;
run;
D. data bball;
set sashelp.baseball;
where Division and nHits in ('East' and 75+);
run;
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which statement is true regarding a variable?
A. A character value cannot exceed 200 bytes.
B. A numeric variable can contain digits, decimal point, minus sign, currency symbol, and E for scientific notation.
C. A numeric value must be specified in single or double quotes.
D. A character variable can contain alphabetic characters, numeric digits, and other special characters.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which PROC MEANS statements specifies variables to group the data before calculating statistics?
A. CLASS
B. SUMBY
C. GROUP
D. VAR
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which PROC MEANS program creates the report below?

A. proc means data-esea= ashelp. shoes.
sum Salad;
mean Sales;
by product;
run."
B. proc means data-sashelp. shoes sum mean;
var Sales;
Class Product;
run;
C. Pror moans data-uashelp . shoes sum mean nobe;
by sales;
class product
D. proc means data=sashelp. 'shoes
var Sale;
group Product;
run/
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which program assigns the library reference exlib to the CLASS. XLSX workbook and displays the CLASS_TEST worksheet?
A. libname exlib xlsx "c: \class.xlsx";
proc print data=exlib.class_test;
run;
B. libname exlib xlsx "c:\class";
proc print data=exlib.class_test.xlsx;
run;
C. libname xlsx exlib "c:\class.xlsx";
proc print data=xlsx.class_test;
run;
D. libname exlib xlsx "c:\class.xlsx";
proc print data=class_test.xlsx;
run;
正解：A
解説: (Topexam メンバーにのみ表示されます)