how to repeat variable values

[karan96]

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

 after running the code the output is like

    name 

1   AA

2    

3    

4  BB

5 

6 

7

8

9 CC

etc

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

[PeterClemmensen · Accepted solution]

Welcome to the SAS Communities 🙂

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