How to remove Note : The query required remerging summary statistics. in SQL

[raja777pharma]

Hi Team,

I have written below code by using proc sql to get maximum value by group values.

proc sql;
create table max_lengths_ds as
select max(var_length) as max_length
          ,dataset,variable,label,source_var
from input
group by dataset,varible,lable;
quit;

But i am gettting below Note , i am not understand why this note is coming and how to remove.

Thank you,

Rajasekhar

[Kurt_Bremser · Accepted solution]

You have a variable (source_var) in your SELECT that is neither the subject of a summary function nor part of the GROUP BY clause. Either remove it from the SELECT, or add it to the GROUP BY.

[japelin]

I think it is because the number of rows generated from the following two sql is different.
Try to run it by adding source_var to group by.

proc sql;
create table max_lengths_ds_1 as
select max(var_length) as max_length
from input
group by dataset,varible,lable;
quit;

proc sql;
create table max_lengths_ds_2 as
select dataset,variable,label,source_var
from input
group by dataset,varible,lable;
quit;