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
Can you explain the process of calendar?
what is sas enterprise intelligence architecture? : Sas-bi
Did you used proc test? when?
What are the scrubbing procedures in sas?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
How would you identify a macro variable? : sas-macro
What was the last computer book you purchased? Why?
To what type of programms have you used scratch macros?
How to specify variables to be processed by the freq procedure?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
What is interleaving in SAS?
Mention few capabilities of sas framework.
What is Linear Regression?
how to change the execute of macro
Describe the function and utility of the most difficult SAS macro that you have written?