Yes. Just make sure to generate valid SAS code. Using the CAT... series of functions can help. %macro mymacro(var1=,var2=,var3=); .... %mend; data _null_; set mydata ; call execute(cats('%nrstr(%mymacro)','(var1=',var1,',var2=',var2,',var3=',var3,')')); run; ... View more

Perfect thanks.. works great. Fairly new to SAS and was just taking bits and pieces to other things I have found.. insufficient Memory was not the error.. Must have clicked on wrong subject when it popped up.   Anyhow.. thanks a lot for your help ... View more

thank you kindly. This is going to save me lots of time every Monday morning. ... View more