topic Change date from 'DD/MM/YYYY' to 'YYYYMM' in SAS Enterprise Guide

Change date from 'DD/MM/YYYY' to 'YYYYMM'

pcfriendly — Sun, 15 Dec 2013 21:50:06 GMT

Hi,

I'm using theQuery builder in SAS Enterprise Guide 4.3 & have a date field in my data in the 'DDMONYYYY' format which I want to change to 'MONYY' format.

When I use the Query builder & change the format to 'DTMONYY.w', the results for all rows is 'JAN60'?

Can anyone advise what's happening here?

Thanks

Re: Change date from 'DD/MM/YYYY' to 'YYYYMM'

data_null__ — Sun, 15 Dec 2013 22:36:44 GMT

DTMONYY is for datetime variable you want MONYY for your date(no time) variable.

Re: Change date from 'DD/MM/YYYY' to 'YYYYMM'

art297 — Sun, 15 Dec 2013 22:39:50 GMT

Why not select monyy7. ? The format you selected expects a datetime field.

Re: Change date from 'DD/MM/YYYY' to 'YYYYMM'

pcfriendly — Sun, 15 Dec 2013 23:14:13 GMT

Thanks data_null_; & Arthur,

For some reason I didn't notice the option to select 'Date' instead of 'Date Time' ...

Cheers