What about te informat 12. applied to the numeric variable val2 ? Could the number of digit in my global macro var used be an issue ? Such it doesn't work with my initial data.   Regards ... View more

i knew very well that the macro reference were resolved first.  Thanks so much to all !   Regards   ... View more

" the macro variable &val_m2 is resolved by the macro PREprocessor before the data step is compiled and run "   You 're right, thanks.   But i reformulated the problem for simplicity. %macro mymacro(var); %Global used; %let used= %sysevalf(&var +1); %Mend; data need; do i= 1 to 3; if i= 1 then do; x= 2; y= 3; call execute('%mymacro('||x||')'); val2= &used; end; else do; x= x+2; y= (y+2)/2; call execute('%mymacro('||x||')'); val2= &used; end; output; end; run;     Data want:   i x y val2 1 2 3 3 2 4 2.5 5 3 6 2.25 7 ... View more

A wonderfull function this "prxchange".   Thanks Regards ... View more

data haves; infile "...\textfile.txt"; input @"name=" name $ @"id=" id @"size=" size @"type=" type $ ; ;run; ... View more

Thanks, B Regards ... View more

Thanks, works very well with call execute ! Could suggest a smart update if n is the number of rows in data have ? That is 6 in this case. Always without using iml.   Regards  ... View more

Many thanks ! When using proc template, get an error msg. -------------------------------------------- 612  proc transpose data=have out=want; 613    by col1; ERROR: Variable COL1 introuvable. 614    var col2; 615  run; -------------------------------------------- Also as n is very high, will have to "set want" hundreds of times   Regards ... View more

Like this ?   data want; set have; n_position= anydigit(names,1); number= compress(substr(names,n_position),,"kd"); names_want= cats(compress(names,'_',"d"),number); keep names_want; run; ... View more

Thanks! I wanted to say, does others proc make the same job in sas 9.2 ?   Regards ... View more

True, there is no corresponding obs for [xw1 al bk 1t] (from table1) in my table2 example. It is a non valontary omission When I was trying to get something that resembled my data.   Its corresponding obs would have to be a [al 1t] in table2. And it result to the absence of [xw1 al bk 1t] in my final wanted table.   But nevertheless, I very much adhere to what you have proposed [Art297 - Astounding], and this allows me to really obtain what I seek.   Thanking you Regards ... View more

First af all, i apologize for my long absence and i would like to think you (Mr Art297) for your precious help to us. You are right, your question was not responded. Here I answer to it, but as it is so late where i live, i will look deeply to your  last post tomorrow. Thank you again.   First, it looks for the first merging condition and find a same [bk 5t] in both table : Country_one and Counry are equal to (bk) and Time and Count are equal to 5t. Thus,it obtain the value of var6 to var15 as i noted [6 7 8 9 10 11 12 13 14 15] take from the table2. As the values of var1 to var5 are missing in this obs, now it use the second merging condition, that is Country_two = Counry and Time = Count. For this condition, i find [al 5t] for table1 and the same and unique [al 5t] in table2. In this obs, i take the remaining values for var1 to var6.   Thanks and Regards ... View more