DATA Step, Macro, Functions and more

date format required

Reply
Frequent Contributor
Posts: 76

date format required

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

Respected Advisor
Posts: 3,156

date format required

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

Super User
Posts: 10,046

date format required

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

Ask a Question
Discussion stats
  • 2 replies
  • 139 views
  • 0 likes
  • 3 in conversation