Hello, I've recently discovered the classdata option which seems very useful but I am experiencing some very odd results with it. Can anyone explain the following please? Why doesn't the whole of classdata2 get read in? And why is the output dataset empty?! Is there a maximum number of observations in the classdata data set? Thanks, Simon. 156 /*****************************************/ 157 /* Leadgen Name x Loan Type - this works */ 158 /*****************************************/ 159 proc summary data=kpis.leads missing nway; 160 class leadgen_name loan_type; 161 output out=classdata1(drop=_:); 162 run; NOTE: There were 531697 observations read from the data set KPIS.LEADS. NOTE: The data set WORK.CLASSDATA1 has 267 observations and 2 variables. NOTE: PROCEDURE SUMMARY used (Total process time): real time 12.57 seconds cpu time 1.29 seconds 163 proc summary classdata=classdata1 data=kpis.leads exclusive nway; 164 class leadgen_name loan_type; 165 output out=summary(drop=_:) sum(de_accepted)=; 166 run; NOTE: There were 267 observations read from the data set WORK.CLASSDATA1. NOTE: There were 531697 observations read from the data set KPIS.LEADS. NOTE: The data set WORK.SUMMARY has 267 observations and 3 variables. NOTE: PROCEDURE SUMMARY used (Total process time): real time 13.95 seconds cpu time 1.14 seconds 167 /*********************************************/ 168 /* Affiliate x Loan Type - this doesn't work */ 169 /*********************************************/ 170 proc summary data=kpis.leads missing nway; 171 class affiliate loan_type; 172 output out=classdata2(drop=_:); 173 run; NOTE: There were 531697 observations read from the data set KPIS.LEADS. NOTE: The data set WORK.CLASSDATA2 has 16030 observations and 2 variables. NOTE: PROCEDURE SUMMARY used (Total process time): real time 13.50 seconds cpu time 1.71 seconds 174 proc summary classdata=classdata2 data=kpis.leads exclusive nway; 175 class affiliate loan_type; 176 output out=summary(drop=_:) sum(de_accepted)=; 177 run; NOTE: There were 2427 observations read from the data set WORK.CLASSDATA2. NOTE: The data set WORK.SUMMARY has 0 observations and 3 variables. NOTE: PROCEDURE SUMMARY used (Total process time): real time 0.09 seconds cpu time 0.01 seconds
... View more