Greetings, I am trying to update an existing record set so I can update a flag for the most recent entry that can be used for reporting purposes and I have hit a wall and need help. I have, and cannot alter, data in this format although it is a bit more random in the order: data work.records;
input ToolID Date $ Outcome $ Flag;
datalines;
12345 01/01/2022 Pass 0
12345 04/01/2022 Fail 0
12345 02/01/2022 Fail 0
12345 12/01/2021 Pass 0
12345 03/01/2022 Pass 0
98765 03/01/2022 Fail 0
98765 02/01/2022 Pass 0
65471 02/01/2022 Fail 0
;
run; What I need to do is update the flag to be equal to 1 where it is the records max(date) data work.records;
input ToolID Date $ Outcome $ Flag;
datalines;
12345 01/01/2022 Pass 0
12345 04/01/2022 Fail 1
12345 02/01/2022 Fail 0
12345 12/01/2021 Pass 0
12345 03/01/2022 Pass 0
98765 03/01/2022 Fail 1
98765 02/01/2022 Pass 0
65471 02/01/2022 Fail 1
;
run; I have tried creating a temp table and hold the max date and tool id, but I keep hitting a wall on how to update the flag. Nothing I have tried has been successful at doing the update, but that makes sense as I am only so so when it comes to SAS programming and I tend to use the PROC SQL more then anything else. There has to be a simple way to do this! HELP!!
... View more