Download SAS Base Programming for SAS (r) 9.A00-211.PassGuide.2018-06-19.131q.vcex
| Vendor: | SASInstitute |
| Exam Code: | A00-211 |
| Exam Name: | SAS Base Programming for SAS (r) 9 |
| Date: | Jun 19, 2018 |
| File Size: | 2 MB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
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
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!