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
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
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.