Help using Base SAS procedures

Variable to express date ranges

Reply
Contributor
Posts: 59

Variable to express date ranges

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;

Frequent Contributor
Frequent Contributor
Posts: 83

Re: Variable to express date ranges

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

PROC Star
Posts: 7,356

Re: Variable to express date ranges

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

Super User
Posts: 17,759

Re: Variable to express date ranges

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

Ask a Question
Discussion stats
  • 3 replies
  • 187 views
  • 0 likes
  • 4 in conversation