topic Re: Subset data based on Numeric & Character Variables in SAS Programming

Subset data based on Numeric & Character Variables

apple — Mon, 23 Dec 2013 00:54:16 GMT

I have a dataset with

X: Character Variable

Y: Numeric Variable

I want to obtain the dataset with

X = a or b AND Y= 1

how do I write the code?

I understand that if I use "where" both variables must be of the same type (both character or both numeric).

Thank you

Re: Subset data based on Numeric & Character Variables

Tom — Mon, 23 Dec 2013 01:03:24 GMT

WHERE just want a valid boolean expression.

where (X = 'a' or X='b') AND (Y= 1) ;

Re: Subset data based on Numeric & Character Variables

Jagadishkatam — Mon, 23 Dec 2013 01:36:53 GMT

Alternative code,

Where X in ('a','b') and Y=1;

Thanks,

jag

Re: Subset data based on Numeric & Character Variables

KarthikSrivasthav — Mon, 23 Dec 2013 07:10:51 GMT

Alternately u can use:

Data want;

set have;

if x in ("a","b") then output;

where y=1;

run;

Re: Subset data based on Numeric & Character Variables

yaswanthj — Mon, 23 Dec 2013 08:54:08 GMT

Hi ..

You can use any condition, which is provided by tom, jegadish and karthik. and also you can use proc sql to print the same result. where if you use the proc sql, it should take less time to execute the code rather than using data step. Thanks, yaswanth

proc sql;

select * from sasuser.admit

where actlevel in ('HIGH','LOW')

and fee gt 100;

quit;

Thanks, yaswanth