topic Re: Proc Freq Separate Dataset for Each Variable in SAS Programming

Proc Freq Separate Dataset for Each Variable

sasmaverick — Mon, 08 Aug 2016 11:23:26 GMT

I have a proc freq step as follows:

proc freq data=test;

tables v1 v2/out=test_out;

run;

I want the proc freq outputs to be saved in a separate dataset like v1.sas, v2.sas. The step that I have above creates a dataset for only the last variable (v2).

Please help.

Regards

Re: Proc Freq Separate Dataset for Each Variable

RW9 — Mon, 08 Aug 2016 12:05:51 GMT

Why do you want the output to many tables, that really isn't very efficient either here or for future programming. Create one output dataset and use V1*V2 to get variables for each of the by groups, per:

http://support.sas.com/documentation/cdl/en/procstat/63104/HTML/default/viewer.htm#procstat_freq_sect010.htm

You can then apply by group processing, or where clause out the required information.

Re: Proc Freq Separate Dataset for Each Variable

sasmaverick — Mon, 08 Aug 2016 12:22:50 GMT

I am trying to get frequency and percentage for each of the variables
independent of the other variables. Will a cross tab give me the same?

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Proc Freq Separate Dataset for Each Variable

RW9 — Mon, 08 Aug 2016 12:44:09 GMT

It should do, I have no test data to run it on myself, and don't use freq that much so can't think off the top of my head. Try it and see what it gives you (or post test data).

Re: Proc Freq Separate Dataset for Each Variable

Astounding — Mon, 08 Aug 2016 12:56:23 GMT

The simple solution creates multiple output data sets:

proc freq data=test;

tables v1 / out=v1_out;

tables v2 / out=v2_out;

run;

If you have hundreds of variables, this can be automated with macro language.

There also may be ODS-based solutions.

Re: Proc Freq Separate Dataset for Each Variable

Reeza — Mon, 08 Aug 2016 13:05:24 GMT

Use the ODS table.

Proc freq data=have;
Table v1 v2;
ODS output onewayfreqs = want;
Run;

Here's an example to generate a nicely formatted table:

https://gist.github.com/statgeek/e0903d269d4a71316a4e