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 |
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
what is conditional processing?
what is change analysis in sas di ? : Sas-di
what other sas products have you used and consider yourself proficient in using? : Sas programming
What is the order of evaluation of the following operators + - * / ** () ???
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books
Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having <some condition>. Is the above program run correctly, if not why ?
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
What do the mod and int function do? : Sas programming
What is univariate n where it can be used n how...?
What are the advantages of using sas?