topic Re: Change Frequency Table to Raw Data in SAS Data Management

Change Frequency Table to Raw Data

akosh — Tue, 20 Feb 2018 13:15:08 GMT

I'm a new SAS user here. I have a SAS data set that is a frequency table, and I would like to create a new SAS data set that consists of the frequency table transformed to raw data. For example, the frequency table looks like:

score	count
0	1
1	3
2	4

And the outcome I want is:

score
0
1
1
1
2
2
2
2

That is, the raw data has one observation of 0, 3 observations of 1, and 4 observations of 2. Thank you in advance for any help!

Re: Change Frequency Table to Raw Data

Astounding — Tue, 20 Feb 2018 13:55:30 GMT

Since this is not a standard feature, you need to do a little programming to make it happen.

First, create a SAS data set holding the counts from PROC FREQ:

proc freq data=have;

tables score / noprint out=temp_counts;

run;

Then take that SAS data set and write its contents to a text file:

data _null_;

set temp_counts;

file 'path to a raw data file to hold the results' noprint;

if _n_=1 then put 'score';

do k=1 to count;

put score;

end;

run;

Re: Change Frequency Table to Raw Data

akosh — Tue, 20 Feb 2018 15:24:40 GMT

Thank you so much, very helpful!