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
what does classdata2 look like? Can you show a short summary?
If it looks correct, it sounds like a tech support question to me.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.