topic creating multiple observations from single observation in SAS Procedures

creating multiple observations from single observation

park2039 — Tue, 09 Aug 2011 01:47:31 GMT

I am trying to create multiple oservations from single observation as follows.

Can someone please provide SAS codes? Thanks.

From:

id var1 yr

000000001 1 1997

000000001 2 1998

000000001 3 1999

000000001 4 2002

000000002 5 2007

000000003 6 2001

000000003 7 2003

To:

000000001 1 1997

000000001 2 1998

000000001 3 1999

000000001 3 2000

000000001 3 2001

000000001 4 2002

000000002 5 2007

000000003 6 2001

000000003 6 2002

000000003 6 2003

creating multiple observations from single observation

art297 — Tue, 09 Aug 2011 03:04:12 GMT

Your example to: data doesn't explain what you are trying to accomplish. However, the following code should provide enough clues to accomplish what you want:

data want (drop=last: v1 year);

set have (rename=(yr=year var1=v1));

lastyear=lag(year);

lastv1=lag(v1);

if not missing(lastyear) and year ne lastyear+1 then do;

var1=lastv1;

do yr=lastyear+1 to year-1;

output;

end;

var1=v1;

yr=year;

output;

run;

HTH,

Art

creating multiple observations from single observation

mojerry2 — Tue, 09 Aug 2011 06:46:29 GMT

this is a nice example art297.

To people like me who didn't know the "lag" function, it tells you the value from the record before. This is a nice feature to avoid the "retain" function.

creating multiple observations from single observation

Ksharp — Tue, 09 Aug 2011 11:25:16 GMT

Or use merge skill mentioned by Peter.C

data temp;
input  id  : $10.   var1                   yr ;
cards;
000000001                 1                 1997
000000001                 2                 1998
000000001                 3                 1999
000000001                 4                 2002
000000002                 5                 2007
000000003                 6                 2001
000000003                 7                 2003
;
run;
data want(drop=_yr i _id);
 merge temp temp(keep=yr id rename=(yr=_yr id=_id) firstobs=2);
 output;
 if _yr-yr gt 1 and id=_id then do;
                     do i=yr+1 to _yr-1;
                     yr=i; output;
                     end;
                     end;
run;

Ksharp