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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.