SAS认证220道 练习题及详细答案

SAS Certificate Base Practice Questions and Detailed Answers

Chapter 1: Basic Concepts

Chapter 2: Referencing Files and Setting Options

Chapter 3: Editing and Debugging SAS Programs

Chapter 4: Creating List Reports

Chapter 5: Creating SAS Data Sets from Raw Data

Chapter 6: Understanding DATA Step Processing

Chapter 13: Combining SAS Data Sets

Chapter 14: Transforming Data with SAS Functions

Chapter 15: Generating Data with DO Loops

Chapter 16: Processing Variables with Arrays

Chapter 17: Reading Raw Data in Fixed Fields

Chapter 18: Reading Free-Format Data

Chapter 19: Reading Date and Time Values

Chapter 20: Creating a Single Observation from Multiple Records

Chapter 21: Creating Multiple Observations from a Single Record

Chapter 22: Reading Hierarchical Files

1

Chapter 1: Basic Concepts Answer Key

1.

How many observations and variables does the data set below contain?

don't affect the structure of the data set.

2.

How many program steps are executed when the program below is processed?

data user.tables;

infile jobs;

input date name $ job $;

run;

proc sort data=user.tables;

by name;

run;

answer:

a

When it encounters a DATA, PROC, or RUN statement, SAS stops reading statements and

2

executes the previous step in the program. The program above contains one DATA step and

two PROC steps, for a total of three program steps.

3.

What type of variable is the variable AcctNum in the data set below?

b

It must be a character variable, because the values contain letters and underscores, which are

not valid characters for numeric values.

4.

What type of variable is the variable Wear in the data set below?

3

Which of the following variable names is valid?

answer:

c

Variable names follow the same rules as SAS data set names. They can be 1 to 32 characters

continue with any combination of numbers, letters, or underscores.

6.

d

Work. For example, by assigning the libref Profits to a SAS data library, you specify that files

within the library are to be stored until you delete them. Therefore, SAS files in the Sashelp

and Sasuser libraries are permanent files.

7.

In a DATA step, how can you reference a temporary SAS data set named Forecast?

4

level name of the file (for example, Forecast) or the two-level name using the libref Work (for

example, Work.Forecast).

8.

answer:

d

The numeric variable Balance has a default length of 8. Numeric values (no matter how

many digits they contain) are stored in 8 bytes of storage unless you specify a different length.

9.

How many statements does the following SAS program contain?

proc print data=new.prodsale

answer:

c

The five statements are