topic Re: IF ONE VARIBLE HAVE A DIFFRENT DATE FORMAT in SAS Programming

IF ONE VARIBLE HAVE A DIFFRENT DATE FORMAT

rohithrao — Tue, 06 Jan 2015 06:01:16 GMT

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

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 — Tue, 06 Jan 2015 06:50:54 GMT

Try this.

data want;

set date;

d2=input(d1,anydtdte10.);

format d2 date9.;

run;

pankak — Tue, 06 Jan 2015 06:52:59 GMT

I guess this might help you.

data want;

input date anydtdte10.;

format date date9.;

datalines;

13sep2002

13/05/2002

2002-05-13

;

run;

rohithrao — Tue, 06 Jan 2015 07:10:06 GMT

thanks for giving this feedback