Hi, I have one dataset like id date ex: id date 1 13 1 1

Hi, I have one dataset like
id date ex: id date
1 13 1 13Oct2011
2 14 2 14Oct2011
3 15 3 15Oct2011 --->this is the current date
here i want date format like 13Oct2011,14Oct2011 how we can
modify the numeric to date format plz answer.

Question Posted / ram

4 Answers
4730 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 ..

Answer / ramesh

data inter3;
input id 1-2 dat ;
cards;
1 13
2 14
3 15
;
run;

data inter4;
set inter3;
format dat1 date9.;
dat1=dat;
run;

Is This Answer Correct ?

0 Yes

0 No

Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 ..

Answer / naveen

proc sql;
select *
from qqq
format date date9.;
quit;

Is This Answer Correct ?

0 Yes

0 No

Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 ..

Answer / alok karan

proc format ;
invalue newinformat 13="13oct2011"d 14="14oct2011"d 15="15oct2011"d;
run;
data ii;
input id date:newinformat.;
datalines;
1 13
2 14
3 15
;
run;
proc print data=ii;
format date date9.;
run;

Is This Answer Correct ?

0 Yes

0 No

Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 ..

Answer / kiran

data dsn;
input id date;
format date date9.;
cards;
1 13
2 14
3 15
;
run;

Is This Answer Correct ?

2 Yes

3 No

Post New Answer