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
- 11316 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 |
explain about data integrator metadata reports? : Sas-di
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.
is QUALCOMM using SAS ?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What does a PROC TRANSPOSE do?
What are common programming errors committed in sas
what is prime numbers? how we can get plc write sas code?
Mention sas system options to debug sas macros.
How would you code a merge that will keep only the observations that have matches from both sets.
5 Answers Accenture, Bank Of America,
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
What SAS statements would you code to read an external raw data file to a DATA step?
how do u identify a macro variable
Teradata 
