topic Re: Code To Count in SAS Programming

Code To Count

apple — Thu, 27 Feb 2014 02:25:33 GMT

data stud_Pri (keep =HSE_ID HH_NO Hsehold_Ref_No PriStd_cnt);

set stud_dev;

by Hsehold_Ref_No;

if first.Hsehold_Ref_No then do;

where LVL_OF_EDN in ('0', '1');

PriStd_cnt=0; end;

PriStd_cnt + 1;

if last.Hsehold_Ref_No then output;

run;

I don't understand this code.

If first.Hsehold_Ref_No then do;

where LVL_OF_EDN in ('0', '1');

PriStd_cnt=0;end;

1) What if the first.Hsehold_Ref_No doesn't have LVL_OF_EDN in ('0', '1')? What will SAS do?

2) If the LVL_OF_EDN in ('0', '1') is in the 2nd or beyond record of the same Hsehold_Ref_No, will SAS count it?

Thank you

Re: Code To Count

PGStats — Thu, 27 Feb 2014 02:49:12 GMT

The WHERE statement is NOT an executable statement. This means that it should be moved out of the conditional block. Its effect is to restrict the input data to observations where LVL_OF_EDN is either '0' or '1'.

The datastep logic simply counts the number of observations with LVL_OF_EDN either '0' or '1' within each value of Hsehold_Ref_No.

It is assumed that the input dataset is sorted by Hsehold_Ref_No.

The datastep should read:

data stud_Pri (keep =HSE_ID HH_NO Hsehold_Ref_No PriStd_cnt);

set stud_dev;

by Hsehold_Ref_No;

where LVL_OF_EDN in ('0', '1');

if first.Hsehold_Ref_No then do;

PriStd_cnt = 0;

end;

PriStd_cnt + 1;

if last.Hsehold_Ref_No then output;

run;