Macro perfoms slow on large datasets with large number of char variables I modified it %MACRO UPCASE_ALL(LIB, DS); PROC SQL NOPRINT; SELECT STRIP(NAME)||" = UPCASE( "||STRIP(NAME) || ");" INTO :CODE_STR SEPARATED BY ' ' FROM DICTIONARY.COLUMNS WHERE LIBNAME = UPCASE("&LIB") AND MEMNAME = UPCASE("&DS") AND TYPE = 'char'; QUIT; DATA &DS; SET &DS; &CODE_STR RUN; %MEND; %UPCASE_ALL(WORK,INCD2);
... View more