hi i date is 05sep2005; i want the oupput like
05sep2005:00:00:00 ; how it wil come?
- 6 Answers
- 9899 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
At compile time when a SAS data set is read, what items are created?
What do you understand by the term Normal Distribution?
why is a stop statement needed for the point=option on a set statement? : Sas programming
how do u validate sas program
what is the usage for assigning error=1 in a dataset ?
Compare sas with other data analytics tools.
What do you feel about hardcoding?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
what other sas products have you used and consider yourself proficient in using? : Sas programming
What has been your most common programming mistake?
Tell e how how dealt with..
What does the RUN statement do?
Teradata 
