File Info
| Exam | SAS Base Programming for SAS (r) 9 |
| Number | A00-211 |
| File Name | SASInstitute.A00-211.TestKing.2019-06-21.151q.tqb |
| Size | 3 MB |
| Posted | Jun 21, 2019 |
| Download | SASInstitute.A00-211.TestKing.2019-06-21.151q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Given the SAS data set SASDATA TWO:
SASDATA TWO
X Y
-- --
5 2
3 1
5 6
The following SAS program is submitted:
data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;
What is the result?
- data set SASUSER.ONE has 5 observationsdata set SASUSER.TWO has 5 observationsdata set WORK.OTHER has 3 observations
- data set SASUSER.ONE has 2 observationsdata set SASUSER.TWO has 2 observationsdata set WORK.OTHER has 1 observations
- data set SASUSER.ONE has 2 observationsdata set SASUSER.TWO has 2 observationsdata set WORK.OTHER has 5 observations
- No data sets are output.The DATA step fails execution due to syntax errors.
Correct answer: D
Question 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?
- merge work.employeework.salary (fname = name);
- merge work.employeework.salary (name = fname);
- merge work.employeework.salary (rename = (fname = name));
- merge work.employeework.salary (rename = (name = fname));
Correct answer: D
Question 3
The following SAS program is submitted:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
- 0
- 1
- 5
- 60
Correct answer: D
