Help using Base SAS procedures

Classdata - Proc Summary

Reply
N/A
Posts: 1

Classdata - Proc Summary

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=_Smiley Happy;

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=_Smiley Happy 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=_Smiley Happy;

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=_Smiley Happy 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

Super User
Posts: 19,815

Re: Classdata - Proc Summary

Posted in reply to SimonMorehen

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

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

Ask a Question
Discussion stats
  • 1 reply
  • 165 views
  • 0 likes
  • 2 in conversation