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
- 6142 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 |
How to convert HTML file into SAS dataset?
how to delete the duplicates by using proc sql?
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
how do you debug and test your sas programs? : Sas programming
what are all the ways to define macro variable??
2 Answers GSK GlaxoSmithKline,
What are the joins,types of joins and thier functions?
Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.
What is the maximum and minimum length of macro variable
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)
8 Answers GSK GlaxoSmithKline,
In PROC PRINT, can you print only variables that begin with the letter “A”?
What is the use of %include statement?
Teradata 
