topic get first day and last day of month FORMAT AS: 1APR2017 00:00:00 AND 30APR2017 23:59:59 in SAS Programming

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

JHE — Thu, 20 Apr 2017 15:38:17 GMT

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

LinusH — Thu, 20 Apr 2017 15:41:40 GMT

Intnx

get first day and last day of month FORMAT AS: 1APR2017 00:00:00 AND 30APR2017 23:59:59

JHE — Thu, 20 Apr 2017 15:41:45 GMT

Re: get first day and last day of month FORMAT AS: 1APR2017 00:00:00 AND 30APR2017 23:59:59

collinelliot — Tue, 04 Dec 2018 16:08:06 GMT

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;

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

RW9 — Thu, 20 Apr 2017 15:48:44 GMT

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...

Re: get first day and last day of month FORMAT AS: 1APR2017 00:00:00 AND 30APR2017 23:59:59

JHE — Thu, 20 Apr 2017 16:13:01 GMT

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;

Re: get first day and last day of month FORMAT AS: 1APR2017 00:00:00 AND 30APR2017 23:59:59

collinelliot — Thu, 20 Apr 2017 16:16:10 GMT

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

datetime() will give you the current datetime value.

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

JHE — Thu, 20 Apr 2017 16:21:31 GMT

Thank you, let me try this way .

Re: get first day and last day of month FORMAT AS: 1APR2017 00:00:00 AND 30APR2017 23:59:59

Reeza — Thu, 20 Apr 2017 18:24:41 GMT

@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.