Classdata - Proc Summary

SimonMorehen — Tue, 30 Apr 2013 14:41:07 GMT

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

Re: Classdata - Proc Summary

Reeza — Tue, 30 Apr 2013 14:54:27 GMT

what does classdata2 look like? Can you show a short summary?

If it looks correct, it sounds like a tech support question to me.

topic Re: Classdata - Proc Summary in SAS Procedures

Classdata - Proc Summary

Re: Classdata - Proc Summary