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 |
why a stop statement is needed for the point= option on a set statement?
How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
explain about various caches available in data integrator? : Sas-di
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
what is Global Symbol table and Local symbol table?
Explain proc sort?
for whom is sas data integration studio designed? : Sas-di
where to use sas business intelligence? : Sas-bi
What does proc print, and proc contents are used for?
what is the diff b/w verification validation in sas
what kind of variables are collected in AE dataset?
3 Answers Accenture, Quintiles, SAS,