hi i date is 05sep2005; i want the oupput like
05sep2005:00:00:00 ; how it wil come?
Answers were Sorted based on User's Feedback
data date1;
Date='05sep2005'd;
DateTime=dhms(Date,0,0,0);
put DateTime datetime21.;
format datetime datetime21. date date9.;
run;
second method;
data asd1;
date='05sep2005';
time='00.00.00';
datetime=date||':'||time;
run;
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / siva
date is 05sep2005 but kenny rock taken date as 05sep2005:00:00:00. he is correct if we have date as 05sep2005:00:00:00. what will be code if date is only 05sep2005.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kenny rock
data test_date;
input date;
informat date datetime18;
cards;
05sep2005:00:00:00
run;
proc print data=test_date;
format date datetime18.;
run;
| Is This Answer Correct ? | 14 Yes | 10 No |
Answer / shakeer
data dt;
informat d date9.;
d= '05sep2005'd;
dt=dhms(d,0,0,0);
format dt datetime21.;
proc print;run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / lavanya
data date;
input date datetime18.;
format date datetime20.;
cards;
05sep2005:00:00:00
run;
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / kumar
data test;
input dt : datetime20.;
cards;
05sep2005:00:00:00
;
proc print data=test;
format dt datetime20.;
run;
| Is This Answer Correct ? | 3 Yes | 8 No |
What is the role of sas grid administrator? : sas-grid-administration
what is hash files in sas and why we are using this one in sas?
What is SAS? What are the functions does it performs?
How do you debug macros?
Name statements that are execution only?
What is the basic structure of the SAS base program?
What is the difference between INPUT and INFILE ?
What is the basic syntax style in SAS?
Are you involved in writing the inferential analysis plan? Tables specifications?
What do you know about sas data set?
i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?
Describe a time when you were really stuck on a problem and how you solved it?