Hi,
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;
run;
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
1. Use the ODS output instead
2. Use proc tabulate instead
3. Calculate manually.
Option 1 or 2 would be my suggestions.
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 ;
Ksharp
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.