topic Re: filling blanks with duplicate keys in SAS Procedures

filling blanks with duplicate keys

brophymj — Thu, 14 May 2015 13:05:13 GMT

Is there a simple way of duplicating the key until it reaches the next values so

key

5564

blank

5566

becomes

5564

5566

thanks

I have attached my dataset

RW9 — Thu, 14 May 2015 13:22:39 GMT

You can use retain:

data have;

key=5564; output;

key=.; output;

key=5566; output;

run;

data want (drop=key rename=(new_key=key));

set have;

retain new_key;

if key ne . then new_key=key;

run;

Lag would also work if its a new variable.