BookmarkSubscribeRSS Feed
sarahsasuser
Quartz | Level 8

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

2 REPLIES 2
Reeza
Super User

1. Use the ODS output instead

2.  Use proc tabulate instead

3. Calculate manually.

Option 1 or 2 would be my suggestions.

Ksharp
Super User

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

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 740 views
  • 0 likes
  • 3 in conversation