04-20-2017 11:46 AM
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;
04-20-2017 12:13 PM
04-20-2017 12:16 PM
Today() gives you a date, so you'd need to change the "dtmonth" to month.
datetime() will give you the current datetime value.
04-20-2017 02:24 PM
If dt=today(), this would not working , dt would be dynamic variable .
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.;
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.
04-20-2017 11:48 AM
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...