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.
Answers were Sorted based on User's Feedback
Answer / ramesh
data inter3;
input id 1-2 dat ;
cards;
1 13
2 14
3 15
;
run;
data inter4;
set inter3;
format dat1 date9.;
dat1=dat;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen
proc sql;
select *
from qqq
format date date9.;
quit;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / kiran
data dsn;
input id date;
format date date9.;
cards;
1 13
2 14
3 15
;
run;
| Is This Answer Correct ? | 2 Yes | 3 No |
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
How is character variable converted into numeric variable and vice versa?
Approximately what date is represented by SAS date value of 730
What are the data types that sas contain?
How to test the debugging in sas?
What is difference between Global n Local Macro Variables..?
i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers
What is a method to debug and test your SAS program?
what is metadata? : Sas-bi
Do you prefer Proc Report or Proc Tabulate? Why?
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.