EG: How to extract month and year from datetime field

[RPYee]

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

[Reeza · Accepted solution]

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

[RPYee]

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 🙂