topic Expanding Frequency tables into datasets in SAS Procedures

Expanding Frequency tables into datasets

Greek — Mon, 02 Dec 2013 17:41:38 GMT

Good afternoon,

I am often given frequency tables which I would like to expand into data sets, which are more easy to manipulate. Is there a procedure that I could use?

For example, I would like to expand the frequency table below into the consequent data set.

GIVEN

Age Group	Laid off	Retained
up to 40	2	5
40-49	1	3

DESIRED OUTCOME

Age Group	Employment
Up to 40	Laid Off
Up to 40	Laid Off
Up to 40	Retained
Up to 40	Retained
Up to 40	Retained
Up to 40	Retained
Up to 40	Retained
40-49	Laid Off
40-49	Retained
40-49	Retained
40-49	Retained

Re: Expanding Frequency tables into datasets

Tom — Mon, 02 Dec 2013 17:55:01 GMT

data desired ;

set given ;

employment='Laid Off';

do _n_=1 to laid_off ;

output;

end;

employment='Retained';

do _n_=1 to retained ;

output;

end;

run;

Or you could created a smaller dataset with the a COUNT or FREQ variable. Many procedures will allow you to tell it to use this variable as a weight or frequency.

data want ;

set given ;

employment='Laid Off';

count = laid_off ;

output;

employment='Retained';

count = retained ;

output;

run;

Re: Expanding Frequency tables into datasets

Greek — Mon, 02 Dec 2013 18:16:39 GMT

Briliant!

Thank you!~