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 |
How will you generate test data with no input data?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
What is program data vector (pdv) and what are its functions?
What are the data types does SAS contain?
what is chi-square test? have you used that?
1 Answers Accenture, Quintiles,
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
what is operational data and operational system? : Sas-di
How to convert HTML file into SAS dataset?
explain the concepts and capabilities of business object? : Sas-bi
what is the difference between infile and input? : Sas-administrator
How do you convert basic cube to transaction cube and transaction cube to basic cube?