Still not finding anything. Here is the sysout, if this helps: 187 %ITRATE(P0,N1,N1OUT,1,P1);RUN; NOTE: Table TOOL1.N1OUT created, with 65 rows and 23 columns. MPRINT(ITRATE): PROC SORT; MPRINT(ITRATE): BY OSEQ PPN PPR CPN CPR; SYMBOLGEN: Macro variable D resolves to 1 SYMBOLGEN: Macro variable C resolves to N1OUT NOTE: There were 65 observations read from the data set TOOL1.N1OUT. NOTE: The data set TOOL1.N1OUT has 65 observations and 23 variables. NOTE: The PROCEDURE SORT used 0.00 CPU seconds and 15722K. 189 %ITRATE(P1,N2,N2OUT,2,P2);RUN; NOTE: Table TOOL2.N2OUT created, with 28 rows and 23 columns. NOTE: There were 28 observations read from the data set TOOL2.N2OUT. NOTE: The data set TOOL2.N2OUT has 28 observations and 23 variables. NOTE: The PROCEDURE SORT used 0.00 CPU seconds and 16978K. 191 %ITRATE(P2,N3,N3OUT,3,P3);RUN; NOTE: Table TOOL3.N3OUT created, with 826 rows and 23 columns. NOTE: There were 826 observations read from the data set TOOL3.N3OUT. NOTE: The data set TOOL3.N3OUT has 826 observations and 23 variables. NOTE: The PROCEDURE SORT used 0.01 CPU seconds and 18002K. 193 %ITRATE(P3,N4,N4OUT,4,P4);RUN; NOTE: Table TOOL4.N4OUT created, with 6973 rows and 23 columns. NOTE: There were 6973 observations read from the data set TOOL4.N4OUT. NOTE: The data set TOOL4.N4OUT has 6973 observations and 23 variables. NOTE: The PROCEDURE SORT used 0.27 CPU seconds and 16982K. 195 %ITRATE(P4,N5,N5OUT,5,P5);RUN; NOTE: Table TOOL5.N5OUT created, with 108 rows and 23 columns. NOTE: There were 108 observations read from the data set TOOL5.N5OUT. NOTE: The data set TOOL5.N5OUT has 108 observations and 23 variables. NOTE: The PROCEDURE SORT used 0.01 CPU seconds and 17494K. 197 %ITRATE(P5,N6,N6OUT,6,P6);RUN; NOTE: Table TOOL6.N6OUT created, with 106 rows and 23 columns. NOTE: There were 106 observations read from the data set TOOL6.N6OUT. NOTE: The data set TOOL6.N6OUT has 106 observations and 23 variables. NOTE: The PROCEDURE SORT used 0.01 CPU seconds and 18262K. 199 %ITRATE(P6,N7,N7OUT,7,P7);RUN; NOTE: Table TOOL7.N7OUT created, with 392 rows and 23 columns. MPRINT(ITRATE): PROC SORT; MPRINT(ITRATE): BY OSEQ PPN PPR CPN CPR; SYMBOLGEN: Macro variable D resolves to 7 SYMBOLGEN: Macro variable C resolves to N7OUT WARNING: The total length of all variables in the BY list must be less than or equal to 4092 bytes. The host sort cannot be used. The internal SAS sort will be used; this may impact performance. NOTE: There were 392 observations read from the data set TOOL7.N7OUT. WARNING: Host sort not available; SAS sort was used. NOTE: The data set TOOL7.N7OUT has 392 observations and 23 variables. NOTE: The PROCEDURE SORT used 0.06 CPU seconds and 29654K. Since I am always sorting 23 variables, I fail to see why the length would change. Any help would be greatly appreciated.
... View more
