02-11-2017 09:13 AM
Please, what is the impact of usinng sql group by and missing values.
Can you show some examples.
How about you showing examples of "group by and missing values" that you find counterintuitive?
02-11-2017 04:15 PM
To solve a problem like this, consider all situations:
0. No Missing values
1. Missing values in data you're going to summarize
2. Missing values in a GROUP BY variables
3. Missing values in multiple GROUP BY variables
4. Missing values in data and GROUP BY variables.
Generate test data for each scenario and test it. PROC COMPARE can be used to compare the output.
If you run into issues, post the sample test data and the code you used, and the log.
Also, consider reviewing the post here on how to ask a good question.