subsetting using the IF statement

[pamelisa]

Hi!

am new to SAS and stuck.  trying to get a subset of my data using this code:

data  sasuser.op2;
set sasuser.op
if DEPRES = 1;
run;
proc freq;
tables DEPRES;
run;

[Reeza]

---

@pamelisa wrote:

Hi!

am new to SAS and stuck.  trying to get a subset of my data using this code:

data  sasuser.op2;
set sasuser.op
if DEPRES = 1;
run;
proc freq;
tables DEPRES;
run;

You forgot a semicolon after the SET statement.

Please include your log and a detailed explanation of what your problem is....you never actually say what happens or what's not working so I'm guessing at the issue right now.

[art297]

Of course, if you don't actually need the subset file, the following would run faster:

proc freq data=sasuser.op (where=(DEPRES = 1));
  tables DEPRES;
run;

Art, CEO, AnalystFinder.com

[pamelisa]

Thank you!!

[WarrenKuhfeld]

Your SET statement is missing a semicolon.