SAS Certification Practice Quiz

1. Which statement initiates a DATA step in SAS?

PROC PRINT

DATA

RUN

PROC SQL

2. What is the primary purpose of the RUN statement in SAS?

Execute submitted statements

Define variable names

Create permanent datasets

Close the SAS session

3. Which PROC is used to generate descriptive statistics in SAS?

PROC MEANS

PROC SORT

PROC FORMAT

PROC APPEND

4. In SAS, what does the KEEP statement do?

Sorts dataset observations

Retains specified variables in output

Merges two datasets

Removes missing values

5. Which function combines multiple character strings in SAS?

SUBSTR

LENGTH

CATX

ROUND

6. What is the default length of a character variable in SAS?

4 bytes

8 bytes

32,767 bytes

1 byte

7. Which statement creates a permanent SAS dataset?

DATA _NULL_

DATA WORK.dataset

DATA libref.dataset

DATA TEMP.dataset

8. In PROC SQL, which keyword filters rows after aggregation?

WHERE

HAVING

GROUP BY

ORDER BY

9. What does the SET statement do in a DATA step?

Assigns variable values

Reads observations from input dataset

Sorts data alphabetically

Creates new variables

10. Which PROC sorts a dataset by one or more variables?

PROC SORT

PROC FREQ

PROC TRANSPOSE

PROC UNIVARIATE

11. In SAS, what does the MERGE statement require to join datasets correctly?

Both datasets sorted by key variables

Identical variable names

Same number of observations

Numeric key variables only

12. Which function extracts a substring from a character variable?

TRIM

SUBSTR

UPCASE

SCAN

13. What does PROC FREQ generate by default?

Frequency tables and percentages

Descriptive statistics

Sorted datasets

Regression coefficients

Submit

15. Which PROC outputs a report with statistics organized by groups?

PROC REPORT