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
Explain data_null_?
What are the new features included in the new version of SAS Programming Language?
What does the trace option do?
what is the use of proc contents and proc print in sas? : Sas-administrator
what is treatment emergent events and treatment emregent adverse event
How do you define proc in sas? : sas-grid-administration
how to generate the test data in sas without input data? : Sas-administrator
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
Differentiate between proc means and proc summary.
Do you know the features of sas?
What are the five ways to do a table lookup in sas? : sas-grid-administration
Which command is used to perform sorting in sas program?
What is the use of divide function?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
What are the functions used for character handling?