topic Re: Select data from last 30 days in SAS Enterprise Guide

Select data from last 30 days

AK100 — Wed, 29 Apr 2020 10:04:16 GMT

Hello lads,

I have the following data (just a small example):
Location -- Section -- Date -- Counts

Germany -- SA -- 29/04/2020 -- 20

Germany -- SA -- 28/04/2020 -- 67

Germany -- SA -- 27/04/2020 -- 34

Germany -- SA -- 26/04/2020 -- 56

Germany -- SB -- 29/04/2020 -- 76

Germany -- SB -- 28/04/2020 -- 43

Germany -- SB -- 27/04/2020 -- 44

Germany -- SB -- 26/04/2020 -- 90

The dataset contains data of more that 1 year back, it gets updated every day. I want to select just the counts of the last 30 days (per location and section!). Hope someone can help me out with this..

Thanks in advance 🙂

Re: Select data from last 30 days

Kurt_Bremser — Wed, 29 Apr 2020 10:06:49 GMT

data want;
set have;
where date ge today() - 30;
run;

Re: Select data from last 30 days

AK100 — Wed, 29 Apr 2020 10:13:21 GMT

Thank you 🙂

Re: Select data from last 30 days

AK100 — Wed, 29 Apr 2020 10:19:57 GMT

I assume ge stands for Greater then or Equal?

Re: Select data from last 30 days

Kurt_Bremser — Wed, 29 Apr 2020 10:30:32 GMT

@AK100 wrote:
I assume ge stands for Greater then or Equal?

Correct. The mnemonic for "greater" is gt. I like to use the mnemonics to avoid confusion when a certain character is not readily available on a keyboard, or might be changed somewhere along the way by some software converting it to a Unicode character.

Re: Select data from last 30 days

AK100 — Wed, 29 Apr 2020 11:13:36 GMT

That makes sense 🙂

Re: Select data from last 30 days

AK100 — Wed, 29 Apr 2020 12:54:07 GMT

@Kurt_Bremser

I also tried to do the same for the past 3 months(not 90 days). I figured out the following code (with the help of one of your codes in some other topic):

data want;
set want;
where intnx('month',today(),-3,'same') <= datum <=today();
run;

I wondered if there was an easier code to do this?

Re: Select data from last 30 days

Kurt_Bremser — Wed, 29 Apr 2020 13:09:23 GMT

@AK100 wrote:

@Kurt_Bremser

I also tried to do the same for the past 3 months(not 90 days). I figured out the following code (with the help of one of your codes in some other topic):

data want;
set want;
where intnx('month',today(),-3,'same') <= datum <=today();
run;

I wondered if there was an easier code to do this?

Using the INTNX function for this is the proper way, as it takes care of different month lengths. I see nothing wrong here.

Re: Select data from last 30 days

AK100 — Wed, 29 Apr 2020 13:24:55 GMT

Oke, it works but sometimes when i change -3 in -10 for example (to give me pas 10 months) it still gives me only the past 3. Weird...

Re: Select data from last 30 days

Kurt_Bremser — Wed, 29 Apr 2020 13:56:28 GMT

Please post your data in usable form (data step with datalines), and the code you ran against it. I will test it and see what went wrong.

Re: Select data from last 30 days

AK100 — Wed, 29 Apr 2020 14:49:29 GMT

I'm figuring out how to fix that datastep, hope to have it soon 🙂