topic How to duplicate a line in SAS Procedures

How to duplicate a line

trich12 — Mon, 25 Feb 2013 19:53:15 GMT

Hi I have data in groups by specific dates and would like to duplicate the last line of observations for each group. For example, the first group has 10 observations for a certain date, and I would like the 11th line to be an exact duplicate of the 10th line. And I would like to do this for every group. Thank you for your help!

Re: How to duplicate a line

Reeza — Mon, 25 Feb 2013 19:58:53 GMT

proc sort data=have; by group date; run;

data want;

set have;

by group;

if last.group then output;

output;

run;