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

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

raja777pharma — Tue, 01 Mar 2022 06:37:47 GMT

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

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

Kurt_Bremser — Tue, 01 Mar 2022 07:14:30 GMT

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.

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

japelin — Tue, 01 Mar 2022 07:21:17 GMT

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;