04-24-2012 12:52 PM
The Proc Summary shown below is giving a missing value.(There should not be any actually).
PROC SUMMARY DATA=HMOPROD;
BY PRODUCT GENDER AGEX GRP;
OUTPUT OUT=x sum=;
Here there are three products
two genders M F
There are 13 grps 1 to 13.
I'm getting a missing value for female 65-75 for each product.Why ?
04-24-2012 01:23 PM
You probably want the NWAY option.
After reading the other reply and paying more attention I see that NWAY will have no effect as you did not use CLASS.
SUMMARY without CLASS is like a day without sunshine. :smileymischief:
Message was edited by: data _null_
04-24-2012 01:50 PM
There are two possiilities, both easy for you to check.
First, it is possible that the program you posted is different than the one you actually ran. For example, if you were to use a CLASS statement instead of a BY statement you would get missing values in the output. There are other less common differences in the program that could cause this to happen, such as using a preloaded format. But that's one general category: Is this exactly the program that you ran? (The names of the variables in the VAR statement do not matter.)
Second, it is possible that your data contains missing values. Check again! If your program is exactly what you posted, and if PRODUCT is missing on some observations in the output data set, then PRODUCT does take on missing values within the incoming data. (There are obscure variations on this theme, such as running the program first and then changing the data to remove the missing values.)
04-24-2012 02:08 PM
I guess it's also possible that PRODUCT has a format connected with it, that would cause a nonmissing value to print as a blank. That's a stretch, but it is possible.