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;
VAR ---Varlistnames---;
OUTPUT OUT=x sum=;
run;
Here there are three products
two genders M F
agex is
18-44
45-54
55-64
65-75
There are 13 grps 1 to 13.
I'm getting a missing value for female 65-75 for each product.Why ?
I'm getting a missing value for female and male 65-75 for each product.Why ?
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_
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.)
Good luck.
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.
I also notice a problem in your code.
Do you have more than two variables needed to analysis ?
OUTPUT OUT=x sum= /autoname ;
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 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.