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: 288

Re: Getting month and year from Datetime field

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: 288

Re: Getting month and year from Datetime field

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

Hi Colin,

 

That format worked!

 

Thanks much!

SAS Super FREQ
Posts: 8,743

Re: Getting month and year from Datetime field

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

Awesome ,Cynthia! Thanks a lot!

☑ This topic is SOLVED.

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

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