DATA Step, Macro, Functions and more

Adding count to proc freq output?

Reply
Contributor
Posts: 50

Adding count to proc freq output?

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:

 1.PNG

 

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: 

 2.PNG

 

Thanks!

Super User
Super User
Posts: 7,413

Re: Adding count to proc freq output?

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;
Ask a Question
Discussion stats
  • 1 reply
  • 182 views
  • 0 likes
  • 2 in conversation