date conversion help

[raveena]

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,

[art297]

Would something like the following suffice?

data have;

  format datefield best12.;

  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;

[vrmkool]

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;

[ArtC]

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.

[art297]

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

[ArtC]

Art,

You are correct.  I was obviously not paying attention.

Art