Adding count to proc freq output?

hwangnyc — Wed, 17 Aug 2016 13:51:05 GMT

Hi everyone,

I have a basic 2x2 table using this code:

proc freq data=EDB; tables childid*SessionNumber /nocol norow nopercent ; run;

Which gives me this:

I'd like to add another column that will count the number sessionvariables that have any value in them. So the result should look like this:

Thanks!

Re: Adding count to proc freq output?

RW9 — Wed, 17 Aug 2016 14:10:06 GMT

You can do it quite simply in a step after the freq:

data have;
  child=1; session1=3; session2=3; session3=1; session4=0; session5=0;
run;

data want;
  set have;
  array vals session:;
  counts=0;
  do over vals;
    if vals > 0 then counts=counts+1;
  end;
run;

topic Adding count to proc freq output? in SAS Programming

Adding count to proc freq output?

Re: Adding count to proc freq output?