topic sql summary using by in SAS Procedures

sql summary using by

jkf91 — Thu, 18 Aug 2011 05:06:44 GMT

hi all,

My (wrong) code is as follows:

data cig.years_count2;

set cig.years_count;

by household_id, household_size;

if last.household_id then output;

run;

The data (cig.years_count) looks like this:

I am not sure why this is not working (I only get household_id, year and numyears), but I want to get:

Basically, I want to get rid of year and get house hold_size.

Can someone please tell me how I can do this?

Thanks,

ari14 — Thu, 18 Aug 2011 05:10:13 GMT

You can use the drop statement as follows:

data cig.years_count2 (drop=numyears);

set cig.years_count;

by household_id, household_size;

if last.household_id then output;

run;

jkf91 — Thu, 18 Aug 2011 05:20:21 GMT

no that doesn't do the job. that code gives me numyears = 5 for household_id=2000351. I want to see 4 and 1 as in the second table.

also, i want to keep household_size and drop year. the code you provided do the opposite.

Ksharp — Thu, 18 Aug 2011 08:37:54 GMT

Your code should like:

data cig.years_count2;

set cig.years_count;

by household_id household_size;

if last.household_size then output;

run;

Ksharp