Test Your SAS Skills

Educational
Paths
On Site
Education
Public
Courses

Virtual Learning

Success
Stories

SAS Certification

Links Left
  Home
  Consulting
  Education
  Contact Us
  Clients
  Employment
  Site Map
 

 

 

This questionnaire assesses a candidate's current SAS knowledge base and technical background.  Based on this information we can  recommend those courses that will most benefit each candidate. All information fields must be completed to receive your test results.

Please fill out the following information:

Mr. Ms. Dr.

Name:
Title:
Organization:
Department:
Street Address:
City/State/Zip:
Telephone Number:
Fax Number:
E-mail Address:

What class (or topic) are you interested in attending?

 
 

Please answer the following questions:

1) Which of the following will SAS do?

A Create tabulations
B Produce graphs
C Build menu systems
D Allow access to databases
E All of the above

2) A SAS program can contain:

A Data step code only
B Proc step code only
C Data and proc step code
D A or C
E A or B or C

3) A semicolon is not always necessary to end a SAS statement.

True
False

4) Which of the following statements is not used with raw data?

A Where
B Input
C Datalines
D Infile
E Cards

5) The automatic variable _N_ is always equal to:

A The number of records read
B The number of observations
C Both A and B
D The maximum of A and B
E The number of loops through the data step

6) The Program Data Vector appears when reading:

A Flat files
B SAS files
C Raw data following Datalines; or Cards;
D A and C
E A, B, and C

7) The result of the following PROC SORT DATA=SAVED.DEMOG; BY DESCENDING GENDER STATUS; RUN; is:

A Gender and status sorted in descending order
B Gender sorted in descending order and status sorted in ascending order
C Descending, gender, and status, all sorted in ascending order
D Sorted first by status, then gender, in ascending order
E A syntax error

8) Once a Libname statement is submitted, that libref is assigned only for the current SAS session.

True
False

9) A tool used to print a report of a SAS data set's descriptor is:

A The PUT _ALL_; statement in the data step
B Proc Print with the DESCRIPTOR option
C The INPUT; statement with no arguments
D Proc Contents
E None of the above

10) WORK.ONE references a permanent SAS data, while ONE references a temporary SAS data set.

True
False

11) A SAS data set with 10,000 records and a numeric variable called AMOUNT is read. The statement AMOUNT = AMOUNT*2; results in:

A The value of AMOUNT is squared
B The value of AMOUNT is doubled
C The program will abort because a number doubled 10,000 times will be too big to handle.
D The program will abort with a syntax error.
E Once the value of AMOUNT is missing, all records following will show it missing.

12) The statement DROP GRADE; still allows the variable GRADE to be used in that data step.

True
False

13) The SUBSTR function is a character function.

True
False

14) The two statements RETAIN VALUESUM 0; VALUESUM=VALUESUM+VALUE; give the identical results in all cases to the statement VALUESUM+VALUE.

True
False

15) The statement X = ROUND(26.3,10)-1; will give X the value of:

A 30
B 25.3
C 29
D 25
E missing

16) The _ERROR_ variable gives a count of the number of data errors in the record.

True
False

17) If SAS data sets work.one and work.two have twenty and thirty observations respectively, then DATA THREE; SET ONE TWO; RUN; will yield a data set with how many observations?

A 20
B 30
C 50
D 10
E It depends on the data

18) Two SAS data sets are sorted on a variable IDNO and then merged by IDNO. However one of the data sets has duplicates of IDNO. The result is:

A An error message
B Dropping of duplicate IDNO records.
C The information from the matching observations replicated with the duplicates.
D Only the duplicate IDNO records.
E Missing values on the duplicate IDNO records.

19) A format statement in a data step changes the actual data values.

True
False

20) Which of the following are not acceptable key words in a Proc Format Value statement?

A OTHER
B LOW
C HIGH
D MISSING
E A and D

21) FSEDIT is used for editing a one screen of observations at a time.

True
False

22) FSVIEW can be used for both browsing and editing SAS data.

True
False

23) SAS Assist is a combination of Help and Tutorial series of screens for students.

True
False

24) What is available from Proc Means?

A Mean
B Sum
C Maximum and minimum
D Standard Deviation
E All of the above

25) Which proc is used to find the median?

A Summary
B Freq
C Contents
D Univariate
E Means

 
 

Additional Information

Computing environment (please check all that apply):

PC
OS/2
Windows 3.1
Windows NT
Windows 2000
Windows 95
Windows 98
Macintosh
UNIX: (Specify hardware vendor)
MVS/TSO
VM/CMS
Open VMS
Other: (Please specify)
   
 
 

Copyright Notice