topic SAS Dates in SAS Programming

SAS Dates

Avenue — Thu, 31 Jul 2014 09:38:52 GMT

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 — Thu, 31 Jul 2014 09:55:58 GMT

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 — Thu, 31 Jul 2014 10:09:52 GMT

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;