topic Re: Convert $5 formatted variable to ddmmyy date?? in SAS Programming

Convert $5 formatted variable to ddmmyy date??

deleted_user — Mon, 21 Mar 2011 17:13:07 GMT

Ok, I've been on holiday for the past week and seem to have lost all SAS ability. All I'm looking to do is convert a $5 formatted variable to a ddmmyy. date.

For example, I want the value 'JAN11' to be converted to '01JAN11'.

Can anyone help?

Many thanks

Re: Convert $5 formatted variable to ddmmyy date??

SPR — Mon, 21 Mar 2011 17:49:00 GMT

Hello Wacattack,

This is a code:
[pre]
data a;
d="jan11";
date=INPUT("01"||d,anydtdte7.);
format date date7.;
run;
[/pre]
Sincerely,
SPR

Re: Convert $5 formatted variable to ddmmyy date??

deleted_user — Tue, 22 Mar 2011 09:00:14 GMT

Thanks mate, works perfectly

Re: Convert $5 formatted variable to ddmmyy date??

data_null__ — Tue, 22 Mar 2011 15:12:13 GMT

The specific INFORMAT is MONYY

[pre]
116 data _null_;
117 x = 'jan11';
118 d = input(x,monyy.);
119 put d=date9. d=monyy.;
120 run;

d=01JAN2011 d=JAN11
[/pre]