topic populating data based on their frequencies in SAS Programming

populating data based on their frequencies

dustychair — Fri, 15 Feb 2019 15:55:29 GMT

Hi all,

I have a data set and frequencies like below.

Score frequency

300 3

420 4

312 213

I'd like to have all the data instead of their frequencies like

300

420

312

...

Is there an easy way to populate the data? Or I have to write all of the numbers manually which is crazy,

Thanks

Re: populating data based on their frequencies

novinosrin — Fri, 15 Feb 2019 15:58:35 GMT

data want;

set have;

do _n_=1 to frequency;

output;

end;

drop frequency;

run;

Re: populating data based on their frequencies

Reeza — Fri, 15 Feb 2019 15:59:08 GMT

data want;

set have;

do i = 1 to freq;
    output;
end;

run;

@dustychair wrote:

Hi all,

I have a data set and frequencies like below.

Score frequency

300 3

420 4

312 213

I'd like to have all the data instead of their frequencies like

300

300

300

420

420

420

420

312

312

...

Is there an easy way to populate the data? Or I have to write all of the numbers manually which is crazy,

Thanks