PROC SQL with HAVING MAX not returning newest record.

Sanflo — Thu, 06 Sep 2018 12:10:46 GMT

Hi,

I have wrote some code that should pick up newest date in from a variable but it seems to not work. There are no errors or warning in the log but we do see the "NOTE: The query requires remerging summary statistics back with the original data".

I'm not entirely sure where about it is breaking down as a number of other solutions in the forum mention using the MAX to create a table with just the newest records and also use HAVING instead of SELECT for summary functions. My end goal is to have a report from the data which shows each unique Pzinskey for each case but only the most up to date record.

Many thanks,

Sandy

proc sql;

create table pipeline_base as

select t1.* from HLMI_SS.MAP_FLA_05SEP18 as t1

where datepart(createdate) ge today()-180 and propertyname eq "ProcessStatus"

group by Pzinskey

having max(Createdate)

order by Pzinskey, Createdate desc;

run;

Re: PROC SQL with HAVING MAX not returning newest record.

gamotte — Thu, 06 Sep 2018 12:16:07 GMT

Hello,

Try

having Createdate=max(Createdate)

instead

topic Re: PROC SQL with HAVING MAX not returning newest record. in SAS Programming

PROC SQL with HAVING MAX not returning newest record.

Re: PROC SQL with HAVING MAX not returning newest record.