Hello. I frequently use Proc Means and the following code, which was working, is now giving me the following warning: NOTE: Variable MARKET_EQUITY_RATIO_PD__StdDev already exists on file DSTATS.MARKET_BLOOMBERG_DAILY_C_D, using MARKET_EQUITY_RATIO_PD__StdDev2 instead. I have several variables that begin with that prefix (MARKET_EQUITY_RATIO_PD), and each one is giving me this note. However, it is only happening with the STDDEV variables that it is naming automatically. My variables aren't more than 23 characters long (before appending _STDDEV). Any thoughts on what might be causing this problem? %MACRO CREATE_DISTRIBUTION_DATA(INLIB = , DATASET_NAME = , FIELDS = ); PROC MEANS NOPRINT DATA = &INLIB..&DATASET_NAME.; CLASS TICKER; VAR &FIELDS.; OUTPUT OUT = DSTATS.&DATASET_NAME._D N(&FIELDS.) = NMISS(&FIELDS.)= P50(&FIELDS.)= MEAN(&FIELDS.)= P10(&FIELDS.)= P25(&FIELDS.)= P75(&FIELDS.)= P90(&FIELDS.)= STD(&FIELDS.)= MAX(&FIELDS.)= MIN(&FIELDS.)= /AUTOLABEL AUTONAME; RUN; %MEND CREATE_DISTRIBUTION_DATA;
... View more