Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to grab data from today-8 and today-30. For example today being November 30th, I would like to grab data between 11/22/2016 and 10/31/2016. I tried below and It is pulling in the past 30 days. I can't have the past 7 days in this file because I will be doing a join with another dataset that has more detail for the last 7 days if that makes sense. The first dataset is like summary (the >=8 days to <= 30) and the second dataset will have the detail for the last 7 days. The reason why I am doing it this way is because just the last 7 days of detail is well into the millions of rows (just for 7 days). Where the summary is hundreds of thousands. I can't have 30 days of detail data.
In my load file I have
Where Date > =(Today()-30) AND Date < = (Today()-8)
This is grabbing from SAS, which I have no control over the data.
Thank you for the help
Martha
That looks like it should work to me, is it a SQL call from SAS?
If it is a SQL SELECT statement you should use a SQL syntax in your where clause. If it is a LOAD statement I agree with previous comment that it looks correct as long your Date field is a date value.
Thank you so much! I had a feeling that was an issue. Good to know that I had that correct, just need to fix that.