topic Re: Creating a total variable in a dataset from proc freq in SAS Procedures

Creating a total variable in a dataset from proc freq

sarahsasuser — Thu, 02 May 2013 19:26:25 GMT

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

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

Reeza — Fri, 03 May 2013 00:14:47 GMT

1. Use the ODS output instead

2. Use proc tabulate instead

3. Calculate manually.

Option 1 or 2 would be my suggestions.

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

Ksharp — Fri, 03 May 2013 02:57:12 GMT

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