data manipulation question!

gyambqt — Wed, 11 Mar 2015 07:28:57 GMT

Hello experts,

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

Table A:

variable1

aaa

bbb

ccc

ddd

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!

Re: data manipulation question!

Kurt_Bremser — Wed, 11 Mar 2015 07:54:55 GMT

data want;

set have;

retain variable2;

if length(variable1) = 1

then do;

variable2 = variable1;

delete;

end;

run;