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
Describe crosslist option in tables statement?
do you need to know if there are any missing values? : Sas programming
Explain how merging helps to combine data sets.
explain the difference between proc means and proc summary?
what is broad cast agent? : Sas-bi
What is program data vector (pdv) and what are its functions?
what is data integration? : Sas-di
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
what is star schema? : Sas-di
what is null hypothesis? why do you consider that?
What is the role of sas grid administrator? : sas-grid-administration
Name any two sas spawners? : sas-grid-administration
What are the difference between sas functions and procedures?
Have you used macros? For what purpose you have used? : sas-macro
Which statement does not perform automatic conversions in comparisons?