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

[danirecchia]

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

[AncaTilea · Accepted solution]

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.

[danirecchia]

Hello Anca,

it worked! Tahnk you very much.

Kind regards,

Daniela

[AncaTilea]

Great,Daniela.

Would you mark it as answered