Interested to Buy Any Domain ? << Click Here >> for more details...
hi i date is 05sep2005; i want the oupput like
05sep2005:00:00:00 ; how it wil come?
- 6 Answers
- 10987 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 |
What is the maximum and minimum length of macro variable
In sas admin differentiate between roles and capabilities? : sas-grid-administration
What is SAS informats?
What is the basic structure of a sas program?
Where do you use proc means over proc freq?
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?
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
What is the difference between an informat and a format? Name three informats or formats.
How do dates work in sas?
How would you code the criteria to restrict the output to be produced?
What are the difference between ceil and floor functions in sas?
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
Teradata 
