Help using Base SAS procedures

Creating a total variable in a dataset from proc freq

Reply
Frequent Contributor
Posts: 104

Creating a total variable in a dataset from proc freq

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

Super User
Posts: 17,888

Re: Creating a total variable in a dataset from proc freq

1. Use the ODS output instead

2.  Use proc tabulate instead

3. Calculate manually.

Option 1 or 2 would be my suggestions.

Super User
Posts: 9,687

Re: Creating a total variable in a dataset from proc freq

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

Ask a Question
Discussion stats
  • 2 replies
  • 203 views
  • 0 likes
  • 3 in conversation