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.
Answer Posted / 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 |
Post New Answer View All Answers
which date function advances a date, time or datetime value by a given interval? : Sas programming
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what is null hypothesis? why do you consider that?
what are the considerations when picking a SAS/STAT procedure?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what is hierarchy flattening? : Sas-di
what is hash files in sas and why we are using this one in sas?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
What is the function of output statement in a SAS Program?
Difference between SAS STATA & SPSS?
What are all the problems you faced while validating tables and reports?
what is data integration? : Sas-di
Give e an example of..
Of all your work, where have you been the most successful?