Adding count to proc freq output?

[hwangnyc]

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!

[RW9]

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;