topic Re: PROC SQL error message in SAS Programming https://communities.sas.com/t5/SAS-Programming/PROC-SQL-error-message/m-p/624345#M183914 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/299186">@matoma</a>&nbsp; You need an extra pass. Please calculate your max(salary)-salary in 1st pass perhaps in an in line view and the compute the Avg in the outer query.</P> <P>&nbsp;</P> <P>Example:</P> <PRE><CODE class=" language-sas">proc sql; select 'level 1', avg(t) format=comma12. as Avgdiff from (select max(salary)-salary as t from hw2.mechanicslevel1)</CODE></PRE> <P>You can complete the rest using the above as template</P> Wed, 12 Feb 2020 21:10:14 GMT novinosrin 2020-02-12T21:10:14Z PROC SQL error message https://communities.sas.com/t5/SAS-Programming/PROC-SQL-error-message/m-p/624344#M183913 <P>I'm trying to calculate the average difference from each persons salary from the highest salary for their job title. I keep getting an error that the summary functions are nested in a way that's not supported and can't figure out why. Heres what I have.<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Annotation 2020-02-12 153648.png" style="width: 417px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/36084i71E000AF8FBB1056/image-size/large?v=v2&amp;px=999" role="button" title="Annotation 2020-02-12 153648.png" alt="Annotation 2020-02-12 153648.png" /></span></P> Wed, 12 Feb 2020 20:44:18 GMT https://communities.sas.com/t5/SAS-Programming/PROC-SQL-error-message/m-p/624344#M183913 matoma 2020-02-12T20:44:18Z Re: PROC SQL error message https://communities.sas.com/t5/SAS-Programming/PROC-SQL-error-message/m-p/624345#M183914 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/299186">@matoma</a>&nbsp; You need an extra pass. Please calculate your max(salary)-salary in 1st pass perhaps in an in line view and the compute the Avg in the outer query.</P> <P>&nbsp;</P> <P>Example:</P> <PRE><CODE class=" language-sas">proc sql; select 'level 1', avg(t) format=comma12. as Avgdiff from (select max(salary)-salary as t from hw2.mechanicslevel1)</CODE></PRE> <P>You can complete the rest using the above as template</P> Wed, 12 Feb 2020 21:10:14 GMT https://communities.sas.com/t5/SAS-Programming/PROC-SQL-error-message/m-p/624345#M183914 novinosrin 2020-02-12T21:10:14Z