it's a macro variable 1 I need to use a condition to check the value , 2 else send another email. ( i found that there is no possibility to do an elseif if in macro variable mode) , limiting this to only 2 conditions... ... View more

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

the transpose macro is also not working ( surprisingly) since it seems it doesn't have the 'oocurs twice' problem. It is missing variables : I have for instance 429 rows in data have, after the transpose macro I have 152 columns 😞 , they are ordered well ( blanks if there is no value on that variable) but oher variables just disappeared... maybe reverting back and trying to find a solution with the proc transpose ? ... View more

Thanks for the reply,   1) but this is not working because name of the variable:  text_id occures twice or more, ex: same subject could have 'color' many times...   2) Also i'm interested to keep the names of the variables in text_id 1 time only at the top ..   Thank you again     ... View more

data have ; infile datalines missover; 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 var4 hollywood 15555 first_name Janne 15555 last_name grey 15555 birht_date 10091950 10/9/1950 15555 var1 orange 15555 sex f female 15555 var2 Xmen 16666 first_name bruce 16666 last_name banner 16666 var1 green ; run; Thanks forthe clarification, the abovementioned code is the have data. thanks for your return : ... View more

Hi, thank for clarification, I believe that I'll need the transposition ( with the proc or the macro one that is mentioned here thanks to Art , I mean I have to transpose from vertical to horizontal anyway... there will not be too complicated calculations, I mean something like this:   ... View more

Update. My apologies, I havae recreated the table and the results differs from the first post.   here is the image of what data I want - the first step ( because i'll have to perform some calculations afterward) Thanks for your support.   ... View more

Thanks Dear All for your great ideas, I'm still brainstorming it, will return to you after i've tried some steps. 1) I found that the column data got mixed if a new variable appears ( because of difference of number of variables for different Id's), I'm thinking to create a sort of condition ( but still don"t know how to write the conditions to create an empty record if a variable of one of the ID's is missing. 2) Did not concider if the name could be the same, is this a real concern ? what could be another solution to that ? create temporary variables for first name and last name ? ( maybe I have not understood well this ..) Thank you and have a wonderful week 🙂 ... View more

Thank you for the precision. Here is the example, I would like to use data from table want into new one with this example, in fact it will be more complex, but I'd like to start with simple things 🙂 As You see the variables that belongs to first Id differs from the second ID... Thanks again. ... View more

Thank you for the response,   first_name last_name , they are actually in rows format, i would like to transpose them ( sort of order by..) sorry about the long variables, it's not the problem right now, the problem is if the variables are missing - because I name all the variables when I try to transpose.  (as I told you the number of rows differs based on the variables first_name and last_name ... View more

Thank you for response   the entries are included in the columns:   first_name last_name variable1_belongs_to_that_person variable2_belongs_to_that_person variable3_belongs_to_that_person variable4_belongs_to_that_person and so on then another first_name last_name variable comes in with columns that belongs to this person.. and it's reapeating. the number of columns that belongs to subjects differs if there is no transposition way how to transform these columnt into rows ?    The idea is to transpose : trasnform columns into rows , to add sens to the data AND perform some basic classification.   regarding 32 characters, i just used the var followed by names of the columns , I believe their number was too long... ... View more