I'm trying to assign a max length to a computed column by using a macro variable that has the max length value assigned to it. So far I have been able to assign this macro variable to the computed column formula by using a proc sql statement. For example, if I have a macro variable called QteDispLen which has the value 9: COALESCEC(t2.QuoteDisplayID,t1.QuoteDisplayID) LENGTH=&QteDispLen However, I'm trying to do the same thing but in a query builder in SAS EG. How can I do the same as above but in the formula? So far I have been able to do so using the PUT function as below, but how do I make it dynamic using the QteDispLen macro variable? PUT(COALESCEC(t1.QUOTE_DISPLAY_ID,t2.QUOTE_DISPLAY_ID),$9.)
... View more
