generating multiple (or repeat) records during data step

JohnnyCanuck — Sun, 03 Aug 2014 17:03:07 GMT

Been a while since I tried this sort of thing with SAS -- probably easy, but at the risk of admitting same...

Suppose I have the following file

Fred 4

Janice 3

James 5

What I'd like to do is take this data set, and re-write it, as follows:

Fred 1

Janice 1

James 1

In other words, the right-hand field in the original data st is the frequency with which I want to repeat the user (first field) in the new file. So, I want 'Fred' to show up 4 times, Janice 3 times, and James 5 times. And, at the end of each record, the number '1'.

Re: generating multiple (or repeat) records during data step

PGStats — Sun, 03 Aug 2014 17:55:15 GMT

Easy indeed. This kind of expansion is rarely needed within SAS. Check the FREQ statement available in most SAS procedures.

data have;

input name $ freq;

datalines;

Fred 4

Janice 3

James 5

;

data want;

set have;

one = 1;

do i = 1 to freq;

output;

end;

drop freq i;

run;

topic Re: generating multiple (or repeat) records during data step in SAS Programming

generating multiple (or repeat) records during data step

Re: generating multiple (or repeat) records during data step