Hi, I am having this warning:
Which procedure gave you that warning? Please supply the code.
And is there something to identify the 1327 observations (missing values etc)?
Use proc freq to get frequency counts?
Usually a message like this means that there are observations with missing values that were dropped from the analysis. If you are using a FREQ statement, the WARNING tells you the sum of the frequencies for the observations that are dropped.
The easiest way to handle this is to pre-process the data to exclude observations that will be dropped. This is called restricting the data to "complete cases" or "listwise deletion." For ways to do this, see the artlcle "Complete cases: How to perform listwise deletion in SAS."
After you have filtered out the missing values, you can use PROC MEANS to count the remaining frequency count to decide if there is sufficient data left:
proc means data=CompleteCases sum;
var freq;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.