Pearson A00-212 New Attempt

order by 1, 3

order by 1, 3 desc

orderby product, revenue desc

order by product, desc revenue

data three;

set one;

set two key = char1;

run;

data three;

set one;

if char1 in ('new york' 'los angeles');

run;

data three;

set one;

where char1 in ('new york' 'los angeles');

run;

proc sql;

create table three as

select *

from one, two

where one.char1 > two.char1;

quit;

The WHERE statement can be executed conditionally as part of an IF statement.

The WHERE statement selects observations before they are brought into the PDV.

The subsetting IF statement works on observations before they are read into the PDV.

The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.

a is &a

a is cat

a is pig

a is bird