Saturday, July 14, 2007

use "where" statements to print observations for selected critieria

In this example I want to output data for specific ids I've selected in SAS. This turns out to be easier said than done...
The correct syntax for this is as follows.

proc print data=alldat2;
24725 where id=1 or id=2 or id=3;
24726 run;

NOTE: There were 1 observations read from the data set WORK.ALLDAT2.
WHERE id in (1, 2, 3);
NOTE: The PROCEDURE PRINT printed pages 4-14.
NOTE: PROCEDURE PRINT used (Total process time):
real time 22.44 seconds
cpu time 2.51 seconds


voila.