topic Re: Duplicate Observation in SAS Programming

Duplicate Observation

newbi — Mon, 04 Mar 2013 16:21:58 GMT

Is there any way to create duplicates of an observation in a dataset? I have dataset with EmpID and Entries column. Based on Entries column I would like to
create duplicate observation.

Example: If EmpID – 1000 has Entries = 5 then I would like the output as:

EmpID	Entries
10000	5
10000	5
10000	5
10000	5
10000	5

Thanks

Re: Duplicate Observation

PGStats — Mon, 04 Mar 2013 16:29:58 GMT

Simple :

data myDataSet;

set myDataSet;

do _n_ = 1 to Entries;

output;

end;

run;

Re: Duplicate Observation

newbi — Mon, 04 Mar 2013 16:32:33 GMT

Thanks for the quick reply.