Hi Sachin, Yes you are correct in that the macro processor processes the macro before the data step compiler. As such you need to use the data step routine, call execute to invoke your macro instead. The following code should do what you want... array time_interval{4}$ 10 ('month','month3','annual','ytd'); do i=1 to 4; call execute('%get_calcs(' || time_interval{i} || ')'); end; I hope this helps. Cheers, Michelle ... View more

Hi There, The reason why it doesn't work is because the variable id (from the table0 dataset) is character and at compile time the PDV is set up with id being character. The first instance the compiler comes across the id variable is with the set statement. So when you attempt to do the assignment statement the right hand side is a numeric value but the left hand side, the id variable, is defined as character - that is why you get the "NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column)." What you need to do is create a new variable that is numeric and drop your character id variable from your data set. Below is some code that I hope helps. data table1(drop=charId); set table0(rename=(id=charId)); id=input(charId,11.); run; Cheers, Michelle ... View more

Hi Sachin, Is this what you were after? %let a=gross_combined_ratio; %let a=%sysfunc(translate(&a,%str( ),%str(_))); %put _user_; Cheers, Michelle ... View more