topic how to fix missing IDs in SAS Procedures

how to fix missing IDs

Ken_oy — Tue, 30 Oct 2012 18:16:00 GMT

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

Re: how to fix missing IDs

Astounding — Tue, 30 Oct 2012 18:30:26 GMT

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.

Re: how to fix missing IDs

Ken_oy — Tue, 30 Oct 2012 18:33:58 GMT

Thanks Astounding. :smileylaugh:

Re: how to fix missing IDs

data_null__ — Tue, 30 Oct 2012 19:24:24 GMT

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;