1---+----10---+----20---+---
son Frank 01/31/89
daughter June 12-25-87
brother Samuel 01/17/51
The following program is submitted using this file as input: data work.family;
infile 'file-specification';
statement correctly reads the values for the variable Birthdate as SAS date
values? a. input relation $ first_name $ birthdate date9.;
b. input relation $ first_name $ birthdate mmddyy8.;
c. input relation $ first_name $ birthdate : date9.;
d. input relation $ first_name $ birthdate : mmddyy8.;
Correct answer: ddd
An informat is used to translate the calendar date to a SAS date value.
The date values are in the form of two-digit values for month-day-year, so
the MMDDYY8. informat must be used. When using an informat with list
input, the colon-format modifier is required to correctly associate the
informat with the variable name.You can learn about e informats in
Reading Date and Time Values e the colon-format modifier in Reading Free-
Format Data.
2. A raw data file is listed below.1---+----10---+----20---+---
Jose,47,210
Sue,,108
The following SAS program is submitted using the raw data file above as
input: data employeestats;
age weight;run;The following output is desired:name age weight
Jose 47 210
Sue . 108
Which of the following INFILE statements completes the program and
accesses the data correctly?
a. infile 'file-specification' pad;
b. infile 'file-specification' dsd;
c. infile 'file-specification' dlm=',';
d. infile 'file-specification' missover;
Correct answer: bbb
The PAD option specifies that SAS pad variable length records with
blanks. The MISSOVER option prevents SAS from reading past the end of the
line when reading free formatted data. The DLM= option specifies the comma
as the delimiter; however, consecutive delimiters are treated as one by
default. The DSD option correctly reads the data with commas as delimiters
and two consecutive commas indicating a missing value like those in this raw
data file. You can learn about e the PAD option in Reading Raw Data in Fixed
Fields e the MISSOVER option in Creating Multiple Observations from a
Single Record e the DLM= option and the DSD option in Reading Free-
Format Data.
3. The following program is submitted: data numrecords; infile cards
dlm=','; input agent1 $ agent2 $ agent3
$;cards;jones,,brownjones,spencer,brown;run;What is the value for the
variable named Agent2 in the second observation?
a. brown
b. spencer
c. ' ' (missing character value)
d. There is no value because only one observation is created.
Correct answer: ddd
The CARDS statement enables you to read instream data. Any number
of consecutive commas are considered to be a single delimiter as a result of
the DLM= option, and the length of each variable defaults to 8 bytes.
Therefore, the values jones, brownjon, and spencer are assigned to Agent1,
Agent2, and Agent3, respectively, for the first observation. The rest of the
data on the record is not read by the INPUT statement and is not output to
the data set.You can learn about e the CARDS statement in Creating SAS
Data Sets from Raw Data e the default length of variables in Reading
Free-Format Data.
4. A raw data file is listed below.1---+----10---+----20---+----30---+----
40---+----50
TWOSTORY 1040 2 1SANDERS ROAD $55,850
CONDO 2150 4 2.5JEANS AVENUE $127,150
The following program is submitted using this file as input: data
work.houses; infile 'file-specification';
file correctly?
a. input @1 style $8. +1 sqfeet 4. +1 bedrooms 1.
@20 baths 3. street 16. @40 price dollar8;
b. input @1 style $8 +1 sqfeet 4. +1 bedrooms 1. @20
baths 3. street $16 @40 price dollar8.;
c. input @1 style $8. +1 sqfeet 4. +1 bedrooms 1. @20
baths 3. street $16. @40 price dollar8.;
d. input @1 style $8. +1 sqfeet 4. +1 bedrooms 1. @20
baths 3 street 16. @40 price dollar8.;
Correct answer: ccc
Formatted input requires periods as part of the informat name. The
period is missing from the variables Style and Street in Answer b, the
variable Baths in Answer d, and the variable Price in Answer a (which is also
missing a dollar sign to read the variable Street as a character value).You
can learn about formatted input and informats in Reading Raw Data in Fixed
Fields.
5. The following SAS program is submitted at the start of a new SAS
session:
libname sasdata 'SAS-data-library';
data sasdata.sales;
set sasdata.salesdata;
profit=expenses-revenues;
run;
proc printdata=sales;
run;
The SAS data set Sasdata.Salesdata has ten observations.
Which one of the following explains why a report fails to generate? a. The
DATA step fails execution.
b. The SAS data set Sales does not exist.
c. The SAS data set Sales has no observations.
d. The PRINT procedure contains a syntax error.
Correct answer: bbb
The DATA step creates a permanent SAS data set, Sasdata.Salesdata.
The PRINT procedure is printing a temporary SAS data set, Sales, that is
stored in the Work library. At the beginning of the SAS session, Work.Sales
does not exist.You can learn about e creating permanent data sets with the
DATA step in Creating SAS Data Sets from Raw Data e temporary data
sets in Basic Concepts.
6. Which action assigns a reference named SALES to a permanent SAS
data library?
a. Issuing the command: libref SALES 'SAS-data-library'
b. Issuing the command: libname SALES 'SAS-data-library'
c. Submitting the statement: libref SALES 'SAS-data-library';
d. Submitting the statement: libname SALES 'SAS-data-library';
Correct answer: ddd
The LIBNAME statement assigns a reference known as a libref to a
permanent SAS data library. The LIBNAME command opens the LIBNAME
window.You can learn about the LIBNAME statement in Referencing Files and
Setting Options.
7. The following SAS program is submitted:
data newstaff;
set staff;
run;
Which one of the following WHERE
statements completes the program and selects only observations with a
Hire_date of February 23, 2000?
a. where hire_date='23feb2000'd;
b. where hire_date='23feb2000';
c. where hire_date='02/23/2000'd;
d. where hire_date='02/23/2000';
Correct answer: aaa
A SAS date constant must take the form of one- or two-digit day,
three-digit month, and two- or four-digit year, enclosed in quotation marks
and followed by a d ('ddmmmyy
constants in Creating SAS Data Sets from Raw Data.
8. Which one of the following SAS date formats displays the SAS date
value for January 16, 2002 in the form of 16/01/2002?
a. DATE10.
b. DDMMYY10.
c. WEEKDATE10.
d. DDMMYYYY10.
Correct answer: bbb
The requested output is in day-month-year order and is 10 bytes long,
so DDMMYY10. is the correct format. Although WEEKDATE10. is a valid SAS
format, it does not display the SAS date value as shown in the question
above. DDMMYYYY10. is not a valid SAS date format, and the DATEw. format
cannot accept a length of 10.You can learn about e the DDMMYY10. format in
Creating List Reports e the WEEKDATE10. format in Reading Date and
Time Values.
9. Which one of the following displays the contents of an external file
from within a SAS session?
a. the LIST procedure
b. the PRINT procedure
c. the FSLIST procedure
d. the VIEWTABLE window
Correct answer: ccc
The PRINT procedure and VIEWTABLE window display the values in
SAS data sets. The FSLIST procedure displays the values in external files.
There is no LIST procedure in SAS.You can learn about e the PRINT
procedure in Creating List Reports e the VIEWTABLE window in Referencing
Files and Setting Options.
10. The SAS data set Sashelp.Prdsale contains the variables Region and
Salary with 4 observations per Region. Sashelp.Prdsale is sorted primarily by
Region and within Region by Salary in descending order.The following
program is submitted:
data one;
set sashelp.prdsale;
retain temp;
by region descending salary; if first.region then do;
temp=salary; output; end; if last.region then do;
range=salary-temp; output; end;run;For each region, what is
the number of observation(s) written to the output data set?
a. 0
b. 1
c. 2
d. 4
Correct answer: ccc
The expression first.region is true once for each region group. The
expression last.region is true once for each region group. Therefore, each
OUTPUT statement executes once for a total of 2 observations in the output
data set. You can learn about the FIRST.variable expression and the OUTPUT
statement in Reading SAS Data Sets.
11. The following SAS program is submitted:
proc contents data=sasuser.houses;
run;
The exhibit below contains partial output produced
by the CONTENTS procedure.
Data Set Name SASUSER.HOUSES
Observations 15
Member Type DATA Variables 6
Engine V9 Indexes 0
Created Tuesday, April 22, 2003 03:09:25 PM Observation Length
56
Last Modified Tuesday, April 22, 2003 03:09:25 PM Deleted
Observations 0
Protection Compressed NO
Data Set Type Sorted NO
Label Residential housing for sale
Data Representation WINDOWS_32
Encoding wlatin1 Western (Windows)
Which of the following describes the Sasuser.Houses data set?
a. The data set is sorted but not indexed.
b. The data set is both sorted and indexed.
c. The data set is not sorted but is indexed.
d. The data set is neither sorted nor indexed.
Correct answer: ddd
The exhibit above shows partial output from the CONTENTS procedure,
In the top right-hand column of the output, you see that Indexes has a value
of 0, which indicates that no indexes exist for this data set. Also, Sorted has
a value of NO, which indicates that the data is not sorted.You can learn about
the CONTENTS procedure in Referencing Files and Setting Options.
12. The following SAS program is submitted:
proc sort data=work.test;
by fname descending salary;
run;Which one of the following represents how
the observations are sorted?
a. The data set Work.Test is stored in
ascending order by both Fname and Salary values.
b. The data set Work.Test is stored in descending order by both Fname
and Salary values.
c. The data set Work.Test is stored in descending order by Fname and
ascending order by Salary values.
d. The data set Work.Test is stored in ascending order by Fname and in
descending order by Salary values.
Correct answer: ddd
The DESCENDING keyword is placed before the variable name it
modifies in the BY statement, so the correct description is in descending
order by Salary value within ascending Fname values.You can learn about the
SORT procedure and the DESCENDING keyword in Creating List Reports.
13. The following SAS program is submitted:
data names; title='EDU';
if title='EDU' then Division='Education'; else if title='HR' then
Division='Human Resources'; else Division='Unknown';run;Which one of
the following represents the value of the variable Division in the output data
set? a. Educatio
b. Education
c. Human Re
d. Human Resources
Correct answer: bbb
The length of the variable Division is set to 9 when the DATA step
compiles. Since the value of the variable Title is EDU, the first IF condition is
true; therefore, the value of the variable Division is Education.You can learn
about e the length of a variable in Understanding DATA Step Processing
e IF-THEN statements in Creating and Managing Variables.
14. Which one of the following SAS programs creates a variable named
City with a value of Chicago? a. data work.airports; AirportCode='ord'; if
AirportCode='ORD' City='Chicago';run;
b. data work.airports; AirportCode='ORD'; if AirportCode='ORD'
City='Chicago';run;
c. data work.airports; AirportCode='ORD'; if AirportCode='ORD' then
City='Chicago';run;
d. data work.airports; AirportCode='ORD'; if AirportCode='ORD';
then City='Chicago';run;
Correct answer: ccc
The correct syntax for an IF-THEN statement is: IF expression THEN
statement;In this example, the variable City is assigned a value of Chicago
only if the expression AirportCode='ORD' is true.You can learn about IF-THEN
statements in Creating and Managing Variables.
15. The following SAS program is submitted: data work.building;
code='DAL523'; code='SANFRAN604'; code='HOUS731'; length code $
20;run;Which one of the following is the length of the code variable? a.
6
b. 7
c. 10
d. 20
Correct answer: aaa
The DATA step first goes through a compilation phase, then an
execution phase. The length of a variable is set during the compilation phase
and is Based on the first time the variable is encountered. In this case, the
variable code is set to the length of the text string DAL523 which is 6
characters long. The next assignment statements are ignored during
compilation. The LENGTH statement is also ignored since the length has
already been established, but a note will be written to the log.You can learn
about e the compilation phase of the DATA step in Understanding DATA
Step Processing e the LENGTH statement in Creating and Managing
Variables.
16. Which of the following statements creates a numeric variable named
IDnumber with a value of 4198?
a. IDnumber=4198;
b. IDnumber='4198';
c. length IDnumber=8;
d. length IDnumber $ 8;
Correct answer: aaa
The first reference to the SAS variable in the DATA step sets the
name, type, and length of the variable in the program data vector (PDV) and
in the output SAS data set. The assignment statement IDnumber=4198; is
the first reference and creates a numeric variable named IDnumber with a
default storage length of 8 bytes.You can learn about e creating variables
in the DATA step in Understanding DATA Step Processing e numeric
variables in Basic Concepts.
