populating data based on their frequencies

[dustychair]

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

[novinosrin · Accepted solution]

data want;

set have;

do _n_=1 to frequency;

output;

end;

drop frequency;

run;

[Reeza]

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

---