I have some duplicates in the data and i want to remove the record that has blank for the variables in the Having clause I want to do this for every unique combination of Reporting_INST_NAME Reporting_INST_AT Reporting_INST_AM FAC_NUM I think the code below is achieving the same? proc sql ;
create table Insttable_without_DupKey as
select DISTINCT Reporting_INST_NAME, Reporting_INST_AT, Reporting_INST_AM, Reporting_FAC_NUM,FAC_NUM,INST_NAME2,INST_NAME,INST_AM, INST_AT,
Strokecentre2,Strokeunit2,TPA_IS,EVT1718_IS,StrokeUnit_FYEAR
from insttable
group by Reporting_INST_NAME, Reporting_INST_AT, Reporting_INST_AM, FAC_NUM
having Strokeunit2 = MAX(Strokeunit2)
and StrokeUnit_FYEAR = max(StrokeUnit_FYEAR)
;
quit;/*259*/
... View more