SAS Dates

[Avenue]

Hi Guys,

I have a numeric date like: 140731.

I will like to convert this to something like this: 20140731000000. Notice that there are six zeros added to the date.

Thanks

[RW9]

Not sure what you want it for, if its just a text string then:

data have;

  attrib mydate format=yymmdd6.;

  mydate='31JUL2014'd;

run;

data want;

  set have;

  attrib char_date format=$200.;

  char_date=compress(put(mydate,yymmdd10.),"-")||"000000";

run;

Alternatively you could look at ISO dates/formats, though those have additional characters in them.

[RW9]

Just to add an example of the ISO dates:

data have;

  attrib mydate format=yymmdd6.;

  attrib mynewdate format=e8601dt19.;

  attrib textver format=$20.;

  mydate='31JUL2014'd;

  mynewdate=input(put(mydate,yymmdd10.)||"T00:00:00",e8601dt19.);

  textver=compress(put(mynewdate,e8601dt19.),"T:- ");

run;