@sri1 wrote:
Hi all,
I have the following code where the classification variable has 0 observations.Is there any way I can avoid warning "A class or frequency variable is missing on every observation" in log and still get the 0 count
proc summary data=test nway completetypes; class var1 var2/preloadfmt; output out =ptest; run;
Values of var1 are all missing , is there any way I can get 0 count for type var1*var2 and avoid the above message in log
Appreciate your reply.
Regards
Sri
Missing details, such as the Format definitions that are assigned to BOTH variables Var1 and Var2.
You should show the entire code and all messages from the log. It is possible that you have additional information that formats are not acceptable for the Preloadfmt option.
Example:
40 proc summary data=sashelp.class completetypes;
41 class sex age/preloadfmt ;
42 format age f2.;
43 var height ;
44 output out=want max=;
45 run;
WARNING: The format for variable Age cannot be preloaded. A finite set of formatted values cannot
be produced from the format. The format is not recognized, is a SAS format, calls a
function, or contains a nested format in its definition. Preload will have no effect.
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.WANT has 21 observations and 5 variables.
NOTE: PROCEDURE SUMMARY used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
So the definition of the formats may play a very significant role as well.
... View more