This is the code generated by Enterprise itself. %_eg_conditional_dropds(WORK.TRNSSPLITCOLUMNSQUERY_FOR_C_0001, WORK.TMP0TempTableInput, WORK.TMP1TempLabelText); /* ------------------------------------------------------------------- Sort data set WORK.QUERY_FOR_COM_AVG_AMT_000B ------------------------------------------------------------------- */ PROC SORT DATA=WORK.QUERY_FOR_COM_AVG_AMT_000B(KEEP=Avg_Allowed EPI_FIN_YEAR EPI_TYPE_KEY WAVE) OUT=WORK.TMP0TempTableInput ; BY EPI_TYPE_KEY WAVE; RUN; /* ------------------------------------------------------------------- To prevent log warnings, only process the EG_LABEL statement when necessary. ------------------------------------------------------------------- */ %LET __EG_DROP_LABEL__=; %LET __EG_LABEL_OPT__=; PROC CONTENTS DATA=WORK.QUERY_FOR_COM_AVG_AMT_000B OUT=WORK.TMP1TempLabelText(KEEP=LABEL) NOPRINT; RUN; DATA _NULL_; SET WORK.TMP1TempLabelText(WHERE=(LABEL NE "")); CALL SYMPUT("__EG_DROP_LABEL__", "__EG_LABEL__"); CALL SYMPUT("__EG_LABEL_OPT__", "LABEL=__EG_LABEL__"); STOP; RUN; PROC TRANSPOSE DATA=WORK.TMP0TempTableInput OUT=WORK.TRNSSPLITCOLUMNSQUERY_FOR_C_0001(LABEL="Split WORK.QUERY_FOR_COM_AVG_AMT_000B" DROP=__EG_TYPE__ &__EG_DROP_LABEL__ ) NAME=__EG_TYPE__ &__EG_LABEL_OPT__ ; BY EPI_TYPE_KEY WAVE; ID EPI_FIN_YEAR; VAR Avg_Allowed; /* ------------------------------------------------------------------- End of task code. ------------------------------------------------------------------- */ RUN; QUIT; %_eg_conditional_dropds(WORK.TMP0TempTableInput, WORK.TMP1TempLabelText); TITLE; FOOTNOTE; The warning " The variable __EG_LABEL__ in the DROP, KEEP, or RENAME list has never been referenced. " just did not make any sense to me.
... View more