SAS Dates

Reply
Occasional Contributor
Posts: 13

SAS Dates

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

Esteemed Advisor
Esteemed Advisor
Posts: 7,232

Re: SAS Dates

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.

Esteemed Advisor
Esteemed Advisor
Posts: 7,232

Re: SAS Dates

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;

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