topic subsetting using the IF statement in SAS Data Management

subsetting using the IF statement

pamelisa — Wed, 06 Dec 2017 21:23:13 GMT

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;

Re: subsetting using the IF statement

Reeza — Wed, 06 Dec 2017 21:33:10 GMT

@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.

Re: subsetting using the IF statement

art297 — Wed, 06 Dec 2017 21:47:22 GMT

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

Re: subsetting using the IF statement

pamelisa — Wed, 06 Dec 2017 22:08:50 GMT

Thank you!!

Re: subsetting using the IF statement

WarrenKuhfeld — Wed, 06 Dec 2017 22:30:35 GMT

Your SET statement is missing a semicolon.