971 お客様のコメント
質問 1：
The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label of "Open Date".
Which SAS program temporarily replaces the label "Open Date" with the label "Starting Date" in the output?
A. proc print data=SASUSER.HOUSES; Open_Date="Starting Date"; run;
B. proc print data=SASUSER.HOUSES label; label Open_Date "Starting Date"; run;
C. proc print data=SASUSER.HOUSES; label Open_Date="Starting Date"; run;
D. proc print data=SASUSER.HOUSES label; label Open_Date="Starting Date"; run;
正解：D
質問 2：
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?
A. merge work.employeework.salary (name = fname);
B. merge work.employeework.salary (rename = (name = fname));
C. merge work.employeework.salary (fname = name);
D. merge work.employeework.salary (rename = (fname = name));
正解：B
質問 3：
Which one of the following is true of the RETAIN statement in a SAS DATA step program?
A. It is only valid in conjunction with a SUM function.
B. It adds the value of an expression to an accumulator variable and ignores missing values.
C. It has no effect on variables read with the SET, MERGE and UPDATE statements.
D. It can be used to assign an initial value to _N_ .
正解：C
質問 4：
Scenario:
This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs. Write a SAS program that will clean the data incert.input36as follows:
Step 1:
create a temporary data set, cleandata36.
In this data set, convert all case.
Then keep only observations with group equal to 'A' or 'B'.
Step 2:
Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.
Step 3:
* Create results.output36 from cleandata36
* Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.
* If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respectivegroup(A,B) calculated in step 2 What is the MEAN Kilograms value for group='A' in the results.output36 data set?
正解：
76.3
質問 5：
Given the following data step:
After data step execution, what will data set WORK.GEO contain?
A. Option C
B. Option A
C. Option D
D. Option B
正解：B
The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label of "Open Date".
Which SAS program temporarily replaces the label "Open Date" with the label "Starting Date" in the output?
A. proc print data=SASUSER.HOUSES; Open_Date="Starting Date"; run;
B. proc print data=SASUSER.HOUSES label; label Open_Date "Starting Date"; run;
C. proc print data=SASUSER.HOUSES; label Open_Date="Starting Date"; run;
D. proc print data=SASUSER.HOUSES label; label Open_Date="Starting Date"; run;
正解：D
質問 2：
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?
A. merge work.employeework.salary (name = fname);
B. merge work.employeework.salary (rename = (name = fname));
C. merge work.employeework.salary (fname = name);
D. merge work.employeework.salary (rename = (fname = name));
正解：B
質問 3：
Which one of the following is true of the RETAIN statement in a SAS DATA step program?
A. It is only valid in conjunction with a SUM function.
B. It adds the value of an expression to an accumulator variable and ignores missing values.
C. It has no effect on variables read with the SET, MERGE and UPDATE statements.
D. It can be used to assign an initial value to _N_ .
正解：C
質問 4：
Scenario:
This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs. Write a SAS program that will clean the data incert.input36as follows:
Step 1:
create a temporary data set, cleandata36.
In this data set, convert all case.
Then keep only observations with group equal to 'A' or 'B'.
Step 2:
Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.
Step 3:
* Create results.output36 from cleandata36
* Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.
* If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respectivegroup(A,B) calculated in step 2 What is the MEAN Kilograms value for group='A' in the results.output36 data set?
正解：
76.3
質問 5：
Given the following data step:
After data step execution, what will data set WORK.GEO contain?
A. Option C
B. Option A
C. Option D
D. Option B
正解：B
Nakai -
丁寧でわかりやすい解説で理解しやすいです。基本から丁寧に解説されているしっかりしたA00-231テキストです。