Hey all, I'm finding myself hitting a brick wall here and I'm sure it's silly.
proc sql;
create table recentapplication as
select * from fulltable where
.entered_date > intnx ( "month" , today() , -1 ) ;
It's returning all entries.
If I change it to entered_date > today() - 30 that works though I'm looking to do it from the beginning of previous month whenever I run it.
I'm sure this is just a stupid thing on my part but I'm slowly losing my sanity. Any help would be greatly appreciated.
Thanks,
-Jeff
That's odd, the following program works fine for me. note there is a typo in your code - dot before the entered_date. Are you also sure the entered_date is a date variable? Perhaps post test data where this fails?
data fulltable;
entered_date="03MAR2014"d;
output;
entered_date="12NOV2014"d;
output;
run;
proc sql;
create table RECENTAPPLICATION as
select *
from FULLTABLE
where ENTERED_DATE > intnx("month",today(),-1);
quit;
And that was it. The entered_date was a datetime. Just needed to put in a datepart() and it took care of it. Thanks so much for the help!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.