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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.