File Info
| Exam | SAS Base Programming for SAS (r) 9 |
| Number | A00-211 |
| File Name | SASInstitute.A00-211.PassGuide.2018-06-19.131q.vcex |
| Size | 2 MB |
| Posted | Jun 19, 2018 |
| Download | SASInstitute.A00-211.PassGuide.2018-06-19.131q.vcex |
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 EMPLOYEES:
EMPLOYEES
NAME SALARY
-------- ------------
Innis 60000
Jolli 50000
Ellis 55000
Liu 45000
The following SAS program is submitted:
proc print data = employees; where name like ‘_i%’;
run;
What is contained in the output?
- Liu only
- Innis and Ellis only
- Innis, Ellis, and Liu only
- Innis, Jolli, Ellis, and Liu
Correct answer: A
Question 2
Given the SAS data set ONE:
ONE
Obs Dte
----- --------
1 09JAN2005
2 12JAN2005
The following SAS program is submitted:
data two;
set one;
day = <insert expression here>;
format dte date9.;
run;
The data set TWO is created:
TWO
Obs Dte Day
1 09JAN2005 1
12 JAN2005 4
Which expression successfully completed the program and created the variable DAY?
- day(dte)
- weekday(dte)
- dayofweek(dte)
- datdif(dte,’01jan2005’d,’act/act’)
Correct answer: B
Question 3
Read the table:
Given the SAS data set SASUSER.HOUSES:
Obs style bedrooms baths price sqteet street
1 CONDO 2 1.5 80050 1200 MAIN
2 CONDO 3 2.5 79350 1300 ELM
3 CONDO 4 2.5 127150 1400 OAK
4 CONDO 2 2.0 110700 1100 FIFTH
5 TWOSTORY 4 3.0 107250 2100 SECOND
6 TWOSTORY 2 1.0 55650 1600 WEST
7 TWOSTORY 2 1.0 69250 1450 NORTH
6 TWOSTORY 4 2.5 102950 2000 SOUTH
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price It 100000;
<insert DEFINE statement here>
define price / mean width = 9 format = dollar12.;
title;
run;
The following output is desired:
style price
------- ------
CONDO $79,700
TWOSTORY $62550
Which DEFINE statement completes the program and produces the desired output?
- define style / width = 9,
- define style / orderwidth = 9;
- define style / group width = 9;
- define style / display width = 9;
Correct answer: C
Question 4
Given the SAS data set WORKAWARDS:
WORK.AWARDS
FNAME POINTS MONTH
----------- ------------ -----------
Amy 2 4
Amy 1 7
Gerard 3 3
Wang 3 3
Wang 1 12
Wang 1 8
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?
- ENAME POINTS MONTHWang 3 3Wang 1 12Wang 1 8Gerard 3 3Amy 2 4Amy 1 7
- ENAME POINTS MONTHAmy 2 4Amy 1 7Gerard 3 3Wang 3 3Wang 1 8Wang 1 12
- ENAME POINTS MONTH Wang 3 3Wang 1 8Wang 1 12Gerard 3 3Amy 2 4Amy 1 7
- ENAME POINTS MONTHWang 1 12Wang 1 8Wang 3 3Gerard 3 3Amy 1 7Amy 2 4
Correct answer: A
Question 5
The following SAS program is submitted:
libname temp ‘SAS data library’;
data work.new;
set temp.jobs;
format newdate mmddw10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new; run;
The variable NEWDATE contains the SAS date value for April 15. 2005. What output is produced if April 15, 2005 falls on a Friday?
- Obsnewdate mdate ddate104/15/2005 APR 6
- Obs newdate mdate ddate104/15/2005 4 6
- Obs newdate mdate ddate104/15/2005 APR 7
- Obs newdate mdate ddate104/15/2005 4 7
Correct answer: B
Question 6
The contents of the raw data file PRODUCT are listed below:
--------10-------20-------30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile 'product';
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?
- 25.31
- $25.31
- . (missing numeric value)
- No value is stored as the program fails to execute due to errors.
Correct answer: C
Question 7
The following SAS program is submitted:
proc contents data = sashelp.class varnum; quit;
What does the VARNUM option print?
- a list of variable names
- the total number of variables
- a list of the variables in alphabetic order
- a list of the variables in the order they were created
Correct answer: D
Question 8
The following SAS program is submitted:
data test;
set chemists;
jobcode = ‘Chem2’
then description = ‘Senior Chemist’;
else description = ‘Unknown’;
run;
The value for the variable JOBCODE is:
JOBCODE
-------------
chem2
What is the value of the variable DESCRIPTION?
- chem2
- Unknown
- Senior Chemist
- ‘ ‘ (missing character value)
Correct answer: B
Question 9
Given the AIRPLANES data set
AlRPLANES
TYPE MPG
-------- ------
F-18 105
C-130 25
Harrier 75
A-6 110
The following SAS program is submitted:
data gt100;
set airplanes(keep = type mpg load);
load = mpg * 150;
run;
The program fails to execute due to syntax errors.
What is the cause of the syntax error?
- MPG is not a numeric variable.
- LOAD is not a variable in the data set GT100.
- LOAD is not variable in the data set AIRPLANES.
- LOAD must be defined prior to the SET statement.
Correct answer: C
Question 10
Given the raw data file EMPLOYEE:
----I----1 0---I----20---I----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile ‘employee’;
input employee_name $ 1-4;
if employee_name = ‘Ruth’ then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is “Ruth”?
- 11
- 22
- 33
- (missing numeric value)
Correct answer: B
