topic subsetting observations with a specific ID in SAS Procedures

subsetting observations with a specific ID

jkf91 — Thu, 18 Aug 2011 20:38:38 GMT

data cig.subset;

set cig.goodpanel;

by household_id;

if household_id=='2002189' then output;

quit;

I am new to SAS, and I'm not sure if the fourth line is done correctly. I tried '=' and '==' and the number without '' and with ''.

Nothing worked. Can someone please help?

Many thanks,

art297 — Thu, 18 Aug 2011 20:49:27 GMT

First you have to know whether houshold_id is numeric or character. Did your log give you an indication of what kind of error you had?

You can discover what type of field it is by running:

proc contents data=cig.goodpanel;

run;

if it is numeric then, in your code, use:

if household_id eq 2002189 then output;

although = would have worked just as well.

if it is character then it may just include extra spaces and you could try

if strip(household_id) eq "2002189" then output;

Let the forum know if that worked and, if not, post your log the next time.

jkf91 — Thu, 18 Aug 2011 21:16:18 GMT

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

I used the following:

data cig.test;

set cig.goodpanel;

by household_id;

if household_id eq 2002189 then output;

quit;

robby_beum — Thu, 18 Aug 2011 21:23:26 GMT

Instead of using "quit;" - use a "run;"