how to fix missing IDs

[Ken_oy]

This dataset was imported from an excel file.

raw SAS dataset as the follows:

ID    v1   v2

12    2    3

.     3    4

.     8    9

41   2    3

.     3    4

.     8    9

.     3    4

.     8    9

14    2    3

.     3    4

.     8    9

data wanted:

ID    v1   v2

12    2    3

12    3    4

12    8    9

41    2    3

41    3    4

41    8    9

41    3    4

41    8    9

14    2    3

14    3    4

14    8    9

Any easier way to do this ? thanks

[Astounding · Accepted solution]

One way:

data want;

   set have;

   retain new_id;

   if id ne . then new_id=id;

   drop id;

   rename new_id=id;

run;

Good luck.

[Ken_oy]

Thanks Astounding. :smileylaugh:

[data_null__]

This is basically an LOCF problem and if you have more that a couple of variables that need to be carried forward you might find this helpful.

data missid;
   input ID v1 v2;
   retain dummy 1;
   cards;
12    2    3
.     3    4
.     8    9
41   2    3
.     3    4
.     8    9
.     3    4
.     8    9
14    2    3
.     3    4
.     8    9
;;;;
   run;
data fillid(drop=dummy);
   update missid(obs=0) missid;
   by dummy;
   output;
   call missing(of v1-v2);
   run;