sas sql : group by and missing values

Reply
Super Contributor
Posts: 371

sas sql : group by and missing values

Hello,

Please, what is the impact of usinng sql group by and missing values.

Can you show some examples.

 

Super User
Posts: 787

Re: sas sql : group by and missing values


LineMoon wrote:

Hello,

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?

Grand Advisor
Posts: 17,316

Re: sas sql : group by and missing values

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.

http://stackoverflow.com/help/how-to-ask

 

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 151 views
  • 2 likes
  • 3 in conversation