topic Re: Skip days in an inquery in SAS Programming

Skip days in an inquery

Caro17 — Tue, 21 Jul 2020 09:09:27 GMT

Hey,

I just want to do an inquiry and skip e. g. 30 days always from today. For example, today is 21 July 2020 and I don't want to have the data from 21 June 2020 till 21 July 2020 but all the other data. How can I do this?

In SQL I used trunc and sysdate, e. g. date <= trunc(sysdate-30). Can I use this in SAS as well?

I am using SAS Enterprise Guide Version 7.15 HF2.

Thanx in advanced!

Best regards

Caro

Re: Skip days in an inquery

andreas_lds — Tue, 21 Jul 2020 09:19:27 GMT

What to do depends, as always, on the data you have. If you have a sas-date, you can do something like

date <= today()-30

If you have a datetime-variable, then

datepart(date) <= today()-30

should do it.

Re: Skip days in an inquery

PeterClemmensen — Tue, 21 Jul 2020 09:22:25 GMT

data have;
   do date = '01jan2020'd to '31dec2020'd;
      output;
   end;
   format date ddmmyy10.;
run;

data want;
   set have;
   where date < intnx('day', today(), -30) | date > today();
run;

Re: Skip days in an inquery

Kurt_Bremser — Tue, 21 Jul 2020 10:56:44 GMT

Do you want to skip thirty days, or a month? If it's a month, use the INTNX() function in your WHERE condition.