Thank you for the response Dear Art 🙂 it is working I have digged into it and I found what is happening, but need a fix, here is your code with some modification applied to the 'Hulk' ( since there is more than a green hulk in the comics 🙂 : I have modified and added : 16666, var1, green
16666, var1, grey
16666, var1, red So the whole code will look kile data have ;
infile datalines missover dlm=',';
length ID text_id $12 value $12 details $12;
input ID text_id $ value $ details $;
datalines;
14555, first_name, john
14555, last_name, smith
14555, var1, white
14555, sex, m, male
14555, var3, colt
14555, var3, colt
14555, var3, colt
14555, var 4, hollywood
15555, first_name, Janne
15555, last_name, grey
15555, birht_date, 10091950, 10/9/1950
15555, var1, orange
15555, var1, orange
15555, var1, orange
15555, var1, orange
15555, sex, f, female
15555, var2, Xmen
15555, var5, light*yellow
16666, first_name, bruce
16666, last_name, banner
16666, var1, green
16666, var1, grey
16666, var1, red
;
%transpose(data=have, out=need, by=id, var=value,
id=text_id, use_varname=no, convertid=yes)
proc format;
value $sex
'm'='Male'
'f'='Female'
;
run;
data want(drop=_:);
set need(rename=(birht_date=_birht_date));
birth_date=input(_birht_date,mmddyy8.);
format birth_date date9.;
format sex $sex.;
run;
proc print data=want;
run; How to loop trough var1 ? I mean print each color if its different ? I mean var1= green, var1=greay, var1= red ? also it will be interesting to count the var1 and print the number, like var1_total = 3 ( to use them in future calculations eg, use with date) if the hulk changed a color in each date 🙂 and create new tables... Thanks again for your response
... View more