topic Re: convert ddmonyy:hh:mm:ss.ss to mmyyyy in SAS Procedures

convert ddmonyy:hh:mm:ss.ss to mmyyyy

danirecchia — Thu, 24 Jan 2013 16:13:13 GMT

Hello,

on my dataset I have a column in date format such as "12Sep07:0:0:0" and I want to convert this in to "Sep07" I tried put(mmyyyyp8.) and another variations but without success.

Do you have any idea how to convert this variable?

Many thanks!

Daniela

Re: convert ddmonyy:hh:mm:ss.ss to mmyyyy

AncaTilea — Thu, 24 Jan 2013 17:02:54 GMT

How about this,Daniela?

data temp;

date = '12Sep07:00:00:00'dt;*your date;

date_1 = put(datepart(date),monyy.);*your desired date;

run;

Good luck.

Anca.

Re: convert ddmonyy:hh:mm:ss.ss to mmyyyy

danirecchia — Fri, 25 Jan 2013 09:36:52 GMT

Hello Anca,

it worked! Tahnk you very much.

Kind regards,

Daniela

Re: convert ddmonyy:hh:mm:ss.ss to mmyyyy

AncaTilea — Fri, 25 Jan 2013 15:17:15 GMT

Great,Daniela.

Would you mark it as answered