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

[pcfriendly]

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 

[data_null__ · Accepted solution]

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

[pcfriendly]

Thanks data_null_; & Arthur,

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

Cheers

[art297]

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