topic EG: How to extract month and year from datetime field in SAS Enterprise Guide

EG: How to extract month and year from datetime field

RPYee — Thu, 16 Nov 2017 17:47:41 GMT

Using the GUI in Enterprise Guide. I want to create a computed field, based on a datetime field, that will show simply "MMM-YY" for grouping purposes. I can only find help for basic SAS programming, so I'm at a loss.

Thanks, in advance, for your help!!

Rita Yee

Project Engineer

FedEx Express

Re: EG: How to extract month and year from datetime field

Reeza — Thu, 16 Nov 2017 17:50:49 GMT

Compute Column

DATEPART() to obtain date.

Apply a format, MONYY7. for example? I don't see one that exactly matches what you want, so you may need to create your own.

https://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#n0p2fmevfgj470n17h4k9f27qjag.htm

Re: EG: How to extract month and year from datetime field

RPYee — Thu, 16 Nov 2017 17:52:55 GMT

I made that way more difficult than it needed to be 🙂 That "format" step always gets me. I'm always doing things twice because I forget to format it properly on the front end. Sigh

THANKS AGAIN 🙂