data manipulation question!

[gyambqt]

Hello experts,

How do I convert table A to table B like following:

Table A:

variable1

a               

aaa           

bbb

ccc

ddd

eee

b

eee

ggg

hhh

jjj

qqq

...

...

Table B

variable1      variable2            

aaa               a

bbb               a

ccc                a

ddd               a

eee               a

eee               b

ggg               b

hhh               b

jjj                   b

qqq                b

...

...

Thanks so much!

[Kurt_Bremser]

data want;

set have;

retain variable2;

if length(variable1) = 1

then do;

  variable2 = variable1;

  delete;

end;

run;