topic Re: Variable to express date ranges in SAS Procedures

Variable to express date ranges

omega1983 — Tue, 22 Oct 2013 23:28:28 GMT

data _null_;

BPM = INTNX('Month',&pbd_date,-1,'b');/*1st day LM*/

EPM = INTNX('Month',&pbd_date,-1,'e');/*Last day last Month*/

CALL SYMPUT('pmb',BPM);

CALL SYMPUT('pme',EPM);

run;

%put &pmb &pme

I want to assign a variable name called LastMth to encompass a range between BPM and EPM (or all of last month). I want to be able to use this in a datastep to capture records that fall within the entire month(last month).

For example something like LastMth = range between &pmb and &pme ??

then I want to use it in a datastep like this

data want_&LastMth

set something;

run;

Re: Variable to express date ranges

Mit — Tue, 22 Oct 2013 23:32:36 GMT

could you please give us some sample data and expected output data?

Re: Variable to express date ranges

art297 — Tue, 22 Oct 2013 23:54:59 GMT

i'm NOT suggesting this is the best way to accomplish what you want, but are your data and problem similar to the one described at: https://communities.sas.com/message/185021#185021

Re: Variable to express date ranges

Reeza — Tue, 22 Oct 2013 23:58:15 GMT

If you want monthly data try yearmon7. or yymm6. format for your dates which will group all data into months instead of days.