topic Delete from tables in New SAS User

Delete from tables

aloou — Fri, 15 Nov 2019 13:19:07 GMT

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.

Re: Delete from tables

PeterClemmensen — Fri, 15 Nov 2019 13:22:45 GMT

Do something like this

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

Re: Delete from tables

PGStats — Sat, 16 Nov 2019 05:16:05 GMT

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;