IF ONE VARIBLE HAVE A DIFFRENT DATE FORMAT

[rohithrao]

IF ONE VARIBLE HAVE  A DIFFRENT DATE FORMAT how can we read

EX:=

data date;

length d1 $ 10.;

  d1='13sep2002'd;output;

  d1='13/05/2002'd;output;

  d1='2002-05-13'd;output;

  run;

o/p

d1

13sep2002

13/05/2002

2002-05-13

i want to read this in to single format :smileysilly:plz give me answer for this like in D2 varible i want date9. format for these 3 obs

[stat_sas · Accepted solution]

Try this.

data want;

set date;

d2=input(d1,anydtdte10.);

format d2 date9.;

run;

[pankak]

I guess this might help you.

      data want;

    input date anydtdte10.;

   format date date9.;

datalines;

13sep2002

13/05/2002

2002-05-13

;

run;

[rohithrao]

thanks for giving this feedback