topic Re: Date Formats in SAS Programming

Date Formats

robertrao — Mon, 24 Oct 2016 15:05:26 GMT

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

Re: Date Formats

RW9 — Mon, 24 Oct 2016 15:20:02 GMT

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;

Re: Date Formats

robertrao — Mon, 24 Oct 2016 15:25:58 GMT

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

Re: Date Formats

RW9 — Mon, 24 Oct 2016 15:30:10 GMT

Typo, its not needed.

Re: Date Formats

robertrao — Mon, 24 Oct 2016 15:31:57 GMT

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

Re: Date Formats

BrunoMueller — Mon, 24 Oct 2016 15:45:56 GMT

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;