ways to create flag for old vs new datasets

[HitmonTran]

Hi,

I have to create a listing for raw AE (adverse events) data.  This listings need to be rerun everytime we have a new data.  I need to create a flag to identify old records(previous data) vs. new record(new data).  What would be the best way to create the flag?    

[PeterClemmensen]

Depends.. Show us your data?

[Reeza]

Create a view that has the data and include the reporting date/event date or date you enter it into the table. Then add a dynamic variable that's set if the maximum date is the date and set that to 1 or True or whatever you'd like.

proc sql;
create view want as
select *, case when report_date = max(report_date) then f "New"
else "Old" end as flag
from have;
quit;

Then report using the view, not the table. Or add that similar logic to your append process.