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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.