05-02-2013 03:26 PM
I ran the following proc, but want the total frequency into the dataset. In the dataset below there is a building that has a status of both OK and Overdue. In the output the row total is shown so that I know 2 are listed as overdue and 2 are listed as OK, for a total of 4. How do I get a row total in the dataset?
proc freq data=have;
tables var1*var2/ out=freq ouptct;
I get the following dataset:
var1 var2 count %total %Row %Column
A40 OK 1 0.79 100 4.54
A28 OK 2 1.58 100 9.09
A10 overdue 2 0.79 50 4.54
A10 OK 2 2.38 50 4.54
05-02-2013 10:57 PM
For getting some summary statistical estimators , SQL is a good tool.
select var1,var2,(select count(*) from have where var1=a.var1 ) as total
from have as a
group by var1,var2 ;