topic date conversion help in SAS Procedures

date conversion help

raveena — Thu, 28 Jul 2011 17:14:22 GMT

Hi ,

Currently am having the date field EFFDAT and it displaying as

10012010
9012010

and its type is 'number' and format is 'BEST12.' AND informat is 'BEST32.'

I need to display it as 20101001

20100912

Please let me know.

Thanks,

date conversion help

art297 — Thu, 28 Jul 2011 17:39:31 GMT

Would something like the following suffice?

data have;

format datefield best12.;

input datefield;

cards;

10012010

9012010

;

options datestyle=mdy;

data want;

set have;

format datefield yymmddN8.;

datefield=input(put(datefield,best12.),anydtdte.);

run;

date conversion help

vrmkool — Thu, 28 Jul 2011 17:52:53 GMT

you can use something like this :

data x;

input dt ;

cards;

10012010

9012010

;

run;

data y;

set x;

dt1 = input(put(dt,z8.),mmddyy8.);

format dt1 date9.;

run;

Re: date conversion help

ArtC — Sun, 31 Jul 2011 21:12:44 GMT

I would change your format to yymmddN8. so that the value will display in YYMMDD form without any separators between YY and MM and DD.

Note that these solutions are storing a SAS date. This is different than storing the numeric value of 20100901.

Re: date conversion help

art297 — Sun, 31 Jul 2011 22:04:59 GMT

Art, The format I suggested (i.e., yymmddN8.) also displalys without any separators.

Re: date conversion help

ArtC — Mon, 01 Aug 2011 05:46:30 GMT

Art,

You are correct. I was obviously not paying attention.

Art