최신SASInstitute SAS 9.4 Base Programming - Performance-based - A00-231무료샘플문제
문제1
CORRECT TEXT
This question will ask you to provide a line of missing code:
Given the SAS data set WORK.EMPLOYEE_UNFO:
The following SAS program is submitted:
In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.
CORRECT TEXT
This question will ask you to provide a line of missing code:
Given the SAS data set WORK.EMPLOYEE_UNFO:
The following SAS program is submitted:
In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.
정답:
byIDNumberExpenses;IDNumberExpenses2542100.003612133.152198234.342198111.12
문제2
Read the table
The following SAS program is submitted:
proc freq data = sales;
<insert TABLES statement here>
run;
The following output is created by the FREQUENCY procedure:
Which TABLES statement(s) completed the program and produced the output?
Read the table
The following SAS program is submitted:
proc freq data = sales;
<insert TABLES statement here>
run;
The following output is created by the FREQUENCY procedure:
Which TABLES statement(s) completed the program and produced the output?
정답: B
문제3
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?
정답: C
문제4
You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:
What does it mean?
You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:
What does it mean?
정답: D
문제5
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?
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
문제6
Given the SAS data set WORK.EMP_NAME:
Given the SAS data set WORK.EMP_DEPT:
The following program is submitted:
How many observations are in data set WORK.ALL after submitting the program?
Given the SAS data set WORK.EMP_NAME:
Given the SAS data set WORK.EMP_DEPT:
The following program is submitted:
How many observations are in data set WORK.ALL after submitting the program?
정답: D
문제7
Which statement about SAS libraries is true? Select one:
Which statement about SAS libraries is true? Select one:
정답: A
문제8
The contents of the raw data file TEAM are listed below:
--------10-------20-------30
Janice 10
Henri 11
Michael 11
Susan 12
The following SAS program is submitted:
data group;
infile 'team';
input name $15. age 2.;
file 'file-specification';
put name $15. +5 age 2.;
run;
Which one of the following describes the output created?
The contents of the raw data file TEAM are listed below:
--------10-------20-------30
Janice 10
Henri 11
Michael 11
Susan 12
The following SAS program is submitted:
data group;
infile 'team';
input name $15. age 2.;
file 'file-specification';
put name $15. +5 age 2.;
run;
Which one of the following describes the output created?
정답: D
문제9
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE WORK.SALARY
fname age fname salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE WORK.SALARY
fname age fname salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?
정답: B
문제10
The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable PROD in the output data set?
The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable PROD in the output data set?
정답: D