how to repeat variable values

karan96 — Thu, 20 Jun 2019 19:25:13 GMT

data test;
input name $ @@;
datalines;
AA . .
BB . . . . .
CC . 
DD . . .
EE . . . . . . . .
FF
;
run;

after running the code the output is like

name

1 AA

4 BB

9 CC

etc

Q how to repeat values in the missing place of variables.

Re: how to repeat variable values

PeterClemmensen — Thu, 20 Jun 2019 19:34:35 GMT

Welcome to the SAS Communities 🙂

data want(rename=(_name=name));
   set test;
   if name ne '' then _name=name;
   retain _name;
   drop name;
run;