Please enable JavaScript.
Coggle requires JavaScript to display documents.
SAS BASE Chapter 3: Subsetting Report Data (Print proc (Commands (where…
SAS BASE Chapter 3: Subsetting Report Data
Print proc
Commands
proc print data= ... ;
run;
var
selects variables to include
sum
calculates, displays report totals for numeric var
where
selects observations that meet criteria
char are enclosed in quotation marks
numeric don;t use quotation marks / special char
comparison op
= EQ
~= NE
> GT
>= GE
<= LE
logical op
~ ^ NOT
& AND
| OR
SPECIAL OPERATORS
contains
Between AND
Where SAME AND
IS NULL
IS MISSING
LIKE
% - any number of char
_ exactly one char
IS NULL
= ' '
= .
IS MISSING
= ' '
= .
Variables displayed left to right according to stored order
Options
NOOBS: No observations
SAS Date Constant
Writen in 'ddmm<yy>yy'd
Auto convert data constant to value
Report Size LINESIZE system option
ID statement specifies the variables ot print at beginning of row instead of obs number
Sorting & Grouping Report