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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: