How to create binary column base on values in other column and drop duplicates in SAS Enterprise Guide 4GL / PROC SQL?

I have table in SAS Enterprise Guide like below:

• ID - numeric
• COL1 - numeric

And I need to aggregate above table and create column 'TARGET':

• TARGET = 1 for these IDs which at least once have '1' in the column 'COL1'
• TARGET = 0 for these IDs which have never had a '1' in the column 'COL1'

Moreover I need to delete duplicates in ID, so as a result i need something like below :

How can I do that in SAS Enterprise Guide in normal SAS code or in PROC SQL ?

Your logic is equivalent to taking the maximum value of the column for each ID.

proc sql;
create table want as
select ID, max(col1) as Target
from have
group by ID;
quit;