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
What are pdv and it functions?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
why is a stop statement needed for the point=option on a set statement? : Sas programming
what is proc Index? and what is proc document?
how to do user inputs and command line arguments in sas?
What can you learn from the SAS log when debugging?
Which statement does not perform automatic conversions in comparisons?
What is the difference between INPUT and INFILE ?
what are validation tools that are used in sas? : Sas-administrator
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
how does sas handle missing values in formats? : Sas programming
what is star schema? : Sas-di
which date function advances a date, time or datetime value by a given interval? : Sas programming
what is null hypothesis? why do you consider that?