DATA Step, Macro, Functions and more

Getting month and year from Datetime field

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Getting month and year from Datetime field

Hi All,

 

I am trying to getting month and year from a datetime. field. While I manage to get May2017 from '02MAY17:07:57:59', I need it in the format 052017 i.e month expressed in digits. Can someone please guide how I can achieve it? Please find below the code I tried.

 

DATA date_constants;
datetime = '02MAY17:07:57:59'dt; /* This is a datetime constant */
run;


TITLE “Unformatted Constants”;
PROC PRINT DATA=date_constants;
VAR datetime;
run;


TITLE “Formatted Constants”;
PROC PRINT DATA=date_constants;
VAR datetime;
FORMAT datetime datetime.;
run;

 

data date_tril;
set date_constants;
serve = datepart(datetime);
format serve monyy7.;


PROC PRINT DATA=date_tril;
run;

 

Thanks,

Akhilesh Joshi


Accepted Solutions
Solution
‎05-03-2017 09:46 AM
PROC Star
Posts: 307

Re: Getting month and year from Datetime field

Posted in reply to akhileshJoshi

To be clear, you're not trying to get the month and year from the field. You're extracting the date and then formatting it. I think what you want is mmyyn6. for your format.

View solution in original post


All Replies
Solution
‎05-03-2017 09:46 AM
PROC Star
Posts: 307

Re: Getting month and year from Datetime field

Posted in reply to akhileshJoshi

To be clear, you're not trying to get the month and year from the field. You're extracting the date and then formatting it. I think what you want is mmyyn6. for your format.

Occasional Contributor
Posts: 10

Re: Getting month and year from Datetime field

Posted in reply to collinelliot

Hi Colin,

 

That format worked!

 

Thanks much!

SAS Super FREQ
Posts: 8,868

Re: Getting month and year from Datetime field

Posted in reply to akhileshJoshi

Hi:

  Once you use the DATEPART function, then it should only be a matter of picking the right format, as shown below. As you can see the same date is formatted multiple ways using different formats.

 

cynthia

use_format_nosep.png

Occasional Contributor
Posts: 10

Re: Getting month and year from Datetime field

Posted in reply to Cynthia_sas

Awesome ,Cynthia! Thanks a lot!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 192 views
  • 2 likes
  • 3 in conversation