Help using Base SAS procedures

Expanding Frequency tables into datasets

Accepted Solution Solved
Reply
Contributor
Posts: 45
Accepted Solution

Expanding Frequency tables into datasets

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 GroupLaid offRetained
up to 4025
40-4913

DESIRED OUTCOME

Age GroupEmployment
Up to 40Laid Off
Up to 40Laid Off
Up to 40Retained
Up to 40Retained
Up to 40Retained
Up to 40Retained
Up to 40Retained
40-49Laid Off
40-49Retained
40-49Retained
40-49Retained

Accepted Solutions
Solution
‎12-02-2013 12:55 PM
Super User
Super User
Posts: 6,500

Re: Expanding Frequency tables into datasets

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;


View solution in original post


All Replies
Solution
‎12-02-2013 12:55 PM
Super User
Super User
Posts: 6,500

Re: Expanding Frequency tables into datasets

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;


Contributor
Posts: 45

Re: Expanding Frequency tables into datasets

Briliant!

Thank you!~ Smiley Happy

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 304 views
  • 0 likes
  • 2 in conversation