topic Re: ways to create flag for old vs new datasets in SAS Programming

ways to create flag for old vs new datasets

HitmonTran — Mon, 30 Nov 2020 17:32:31 GMT

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?

Re: ways to create flag for old vs new datasets

PeterClemmensen — Mon, 30 Nov 2020 17:38:01 GMT

Depends.. Show us your data?

Re: ways to create flag for old vs new datasets

Reeza — Mon, 30 Nov 2020 17:45:11 GMT

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.