topic date format required in SAS Programming

date format required

Ashwini — Thu, 15 Mar 2012 10:17:11 GMT

I have a datset like

Stname DOB
A 01mar2005 01:02:04
B 13dec 2001 05:04:06

I want to create below mention dataset from abov dataset like

Stname DOB
A 01\03\2005 01:02:04
B 13\12\ 2001 05:04:06

Kindly help me.

Thanks and Regards,
Ashwini

date format required

Haikuo — Thu, 15 Mar 2012 11:43:30 GMT

First of all, I am not awared of the existance of such a format, but at the same time, I am very ill-informed. Therefore I had to hard-code the following solution:

data want (drop=dob1);

input Stname $ DOB &$25.;

dob1=input(dob,datetime20.);

dob_final=catx(' ',put(datepart(dob1),mmddyy10.),put(timepart(dob1),time.));

cards;

A 01mar2005 01:02:04

B 13dec 2001 05:04:06

;

proc print;run;

Regards,

Haikuo

date format required

Ksharp — Fri, 16 Mar 2012 09:37:55 GMT

proc format;
picture fmt
 low-high='%0d\%0m\%Y %0H:%0M:%0S'(datatype=datetime);
run;
data want ;
input Stname $  DOB & datetime20.;
format dob datetime20.;
dob_final=dob;
format dob_final fmt.;
cards;
A            01mar2005 01:02:04
B            13dec 2001 05:04:06
;
run;

Ksharp