SAS P1 L4a

Question 1

How display specific info from data set?

Answer 1

To display specific info from data set,
add statements to PROC PRINT -
select variables, subset observations, sort and group objects, specify titles and footnotes, assign labels to variables

Question 2

PROC PRINT - default display?

Answer 2

PROC PRINT: by default
displays ALL variables / obs in data set
variables appear in order they occur in data set

Question 3

VAR statement does what?

Syntax?

Answer 3

VAR statement: modifies PROC PRINT,
allows to display only variables you want

PROC PRINT data=data_set;
VAR Variable_One Variable_Two etc;
RUN;

Question 4

SUM statement does what?

Syntax?

Answer 4

SUM statement: calculates and displays column totals for requested variable. Will appear at end of report.

SUM Variable_One;

Question 5

WHERE statement:
used for?
output contains?
syntax?

Answer 5

WHERE statement:

• used to subset observations
• output contains only obs that meet conditions in WHERE statement
• defines a condition for selecting observations
• can be any valid SAS expression

WHERE where-expression;

Question 6

What is an expression?

Answer 6

Expression: sequence of operands, operators that form set of instructions

Question 7

What are operands?

Answer 7

Operands:

• character constants - need quotes, case specific
• numeric constants - don’t need quotes or special char
• date constants
• character variables
• numeric variables

Question 8

Which variables can be used?

Answer 8

Must be variable from input data set

Question 9

Operators to use with WHERE?

Answer 9

Operators: can use

comparison: equal, greater than, less than
arithmetic: plus, minus, times, divide
logical: not, and, or

(spelled out because symbols won’t work on flashcard)