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



hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?..

Answer / muthyam reddy

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

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?..

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

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?..

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

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?..

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

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?..

Answer / lavanya

data date;
input date datetime18.;
format date datetime20.;
cards;
05sep2005:00:00:00
run;

Is This Answer Correct ?    0 Yes 2 No

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?..

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

Post New Answer

More SAS Interview Questions

At compile time when a SAS data set is read, what items are created?

5 Answers  


What do you understand by the term Normal Distribution?

0 Answers  


why is a stop statement needed for the point=option on a set statement? : Sas programming

0 Answers  


how do u validate sas program

3 Answers   Accenture,


what is the usage for assigning error=1 in a dataset ?

2 Answers   Satyam,






Compare sas with other data analytics tools.

0 Answers  


What do you feel about hardcoding?

4 Answers   Oracle,


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

0 Answers   Accenture,


what other sas products have you used and consider yourself proficient in using? : Sas programming

0 Answers  


What has been your most common programming mistake?

4 Answers   Wipro,


Tell e how how dealt with..

0 Answers   Wipro,


What does the RUN statement do?

0 Answers   Quintiles,


Categories