Test Your SAS Skills

	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)

Click here to go to the top of the page.

Back