Date Formats

[robertrao]

Hello,

I have 4-Aug-2016 ($20.) , 05-Aug-2016 ($20.) and I want to convert it into a proper date foramt. The following does not work. Could someone suggest a proper method to do it?

data want;

set have;

Date2= input(Date,worddate.);

format Date2 date10.;

run;

Thanks

[RW9 · Accepted solution]

One example:

data have;
  length dt $20;
  dt="4-Aug-2016"; output;
  dt="05-aug-2016"; output;
run;

data want;
  set have;
  d2=input(compress(dt," -"),date9.);
  format d2 date9.;
run;

[robertrao]

Hello,
Just wondering why is there a space before the hyphen when using compress function?

[RW9]

Typo, its not needed.

[robertrao]

First I thought the space is used to let SAS to keep anything before that but then I removed the space and still it worked. Just double checking. Thank you again

[BrunoMueller]

The answer is already solved, just wanted to mention, that the date11 informat can read the dates that are shown.

See sample code below:

data have;
  length dt $20;
  dt="4-Aug-2016"; output;
  dt="05-aug-2016"; output;
run;

data want;
  set have;
  d2 = input(dt, date11.);
  format d2 date9.;
run;