Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 6249 Views
- I also Faced
- E-Mail Answers
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 |
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)
8 Answers GSK GlaxoSmithKline,
Which is the best training Institute for SAS Business Intelligence course?
I need level 2 to 5 sas using companies in india
Write a SAS macro to calculate number of numbers in an email address
Explain proc univariate?
how does sas handle missing values in sort order? : Sas programming
How is character variable converted into numeric variable and vice versa?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
what are sas/access and sas/connect? : Sas programming
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
Teradata 
