SAS Data Preparation for Data Scientists

1. What does PROC CONTENTS display about a dataset?

Data values and frequencies

Variable names, types, and lengths

Summary statistics only

Sorted variable order

Submit

3. Which statement merges two datasets based on a common variable?

APPEND statement

MERGE statement

JOIN statement

COMBINE statement

Submit

5. Which function finds the position of a character in a string?

FIND()

INDEX()

LOCATE()

SEARCH()

Submit

7. What is the primary use of PROC TRANSPOSE?

Converts rows to columns and vice versa

Sorts data alphabetically

Removes duplicate values

Calculates summary statistics

8. Which procedure reorders observations in a dataset?

PROC SORT

PROC TRANSPOSE

PROC FREQ

PROC FORMAT

Submit

10. Which statement prevents a variable from being written to the output dataset?

RETAIN var;

DROP var;

KEEP var;

DELETE var;

11. Which SAS procedure is most commonly used to examine missing values and data distribution?

PROC FREQ

PROC MEANS

PROC UNIVARIATE

PROC PRINT

Submit

13. Which procedure would you use to create new variables based on existing ones?

DATA step

PROC APPEND

PROC SORT

PROC FORMAT

14. What is the purpose of the COMPRESS function in SAS?

Reduces file size

Removes spaces from strings

Compresses numeric values

Reduces dataset rows

Submit

16. Which function converts a character variable to numeric in a SAS DATA step?

CHARNUM()

INPUT()

CONVERT()

TONUMBER()

17. What does the PROC SQL SELECT DISTINCT statement accomplish?

Removes duplicate rows from results

Filters by unique values only

Counts unique values

Sorts data alphabetically

18. Which statement removes observations with missing values in SAS?

DELETE WHERE MISSING(var);

IF MISSING(var) THEN DELETE;

REMOVE MISSING;

DROP MISSING(var);

19. In SAS, what does the missing value symbol represent for numeric variables?

Empty string

Period (.)

NULL

Zero (0)

SAS Data Scientist Data Preparation Quiz

1. What does PROC CONTENTS display about a dataset?

2.

What first name or nickname would you like us to use?

2. The TRIM function in SAS removes ____.

3. Which statement merges two datasets based on a common variable?

4. PROC FREQ with MISSING option displays ____.

5. Which function finds the position of a character in a string?

6. In SAS, the LENGTH statement specifies ____.

7. What is the primary use of PROC TRANSPOSE?

8. Which procedure reorders observations in a dataset?

9. The UPCASE function converts strings to ____.

10. Which statement prevents a variable from being written to the output dataset?

11. Which SAS procedure is most commonly used to examine missing values and data distribution?

12. The SCAN function in SAS is used to ____.

13. Which procedure would you use to create new variables based on existing ones?

14. What is the purpose of the COMPRESS function in SAS?

15. In SAS, the SUBSTR function is used for ____.

16. Which function converts a character variable to numeric in a SAS DATA step?

17. What does the PROC SQL SELECT DISTINCT statement accomplish?

18. Which statement removes observations with missing values in SAS?

19. In SAS, what does the missing value symbol represent for numeric variables?