how to get first day and last day of month : 1APR2017 00:00:00 AND 30APR2017 23:59:59

[LinusH]

Intnx

[collinelliot · Accepted solution]

Get it from what? From a datetime value, you could use the intnx function.

data _null_;
    dt = '03APR2017:01:04:34'dt;
    fd = intnx('dtmonth', dt, 0, 'B');
    ld  = intnx('dtmonth', dt, 0, 'E');
    put dt datetime. fd datetime. ld datetime.;
run;

Output:

03APR17:01:04:3401APR17:00:00:0030APR17:23:59:59

Or for the current datetime:

data _null_;
    dt = datetime();
    fd = intnx('dtmonth', dt, 0, 'B');
    ld  = intnx('dtmonth', dt, 0, 'E');
    put dt datetime. fd datetime. ld datetime.;
run;

See also: INTNX and INTCK Function Examples.

[JHE]

If dt=today(), this would not working , dt would be dynamic variable .

data _null_;
dt = '03APR2017:01:04:34'dt;
fd = intnx('dtmonth', dt, 0, 'B');
ld = intnx('dtmonth', dt, 0, 'E');
put dt datetime. fd datetime. ld datetime.;
run;

[collinelliot]

Today() gives you a date, so you'd need to change the "dtmonth" to month.

datetime() will give you the current datetime value.

[Reeza]

---

@JHE wrote:
If dt=today(), this would not working , dt would be dynamic variable .

data _null_;
dt = '03APR2017:01:04:34'dt;
fd = intnx('dtmonth', dt, 0, 'B');
ld = intnx('dtmonth', dt, 0, 'E');
put dt datetime. fd datetime. ld datetime.;
run;

---

In the future please make something like this your first post, not just a subject line with no content. When you post only a vague subject  it's a processing of first trying to figure out your question before it can be answered, essentially playing 20 questions, which can be very annoying. 

[RW9]

Maybe elaborate on your questions, post example test data in the form of a datastep, with what the output should look like.  I am guessing:

data want;
  start="01APR2017:00:00:00"dt;
  end=input(cats(put(intnx('month',datepart(start),'e'),date9.),":23:59:59"),datetime.);
  format start end datetime.;
run;

However with nothing to work with and no information...

[JHE]

Thank you, let me try this way .