Delete from tables

[aloou]

Hello everyone,

I have a table where i want to keep only three years of data.

what i want to do is to delete from the table where (DT_OPER : keep three years).

DT_OPER is of type date like 2019/10/01.

can you help please.

[PeterClemmensen · Accepted solution]

Do something like this

data want;
    set have;
    where DT_OPER >= intnx('year', today(), -3, 's');
run;

[PGStats]

Also, to run an analysis only on those three years you don't need to create a new dataset. You can simply use a WHERE statement when running the procedure. For example:

proc means data=have;
where year(DT_OPER) in (2010, 2011, 2012);
var myVar;
....
run;