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

what is the effect of the options statement errors=1? : Sas programming

0 Answers  


· What are some good SAS programming practices for processing very large data sets?

6 Answers   Quintiles,


Difference between SAS STATA & SPSS?

0 Answers  


Name the option to produce a frequency line items rather that a table.

2 Answers  


What is the SAS data set?

0 Answers  






what the use of proc glm

1 Answers   Accenture, C Marc,


what type of graphs we will create(for 2+years candidates)?

0 Answers   Accenture, Icon,


What is difference between (a-z) and (a--z)

8 Answers   Accenture,


Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

0 Answers  


if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record

4 Answers   HSBC,


What system options would you use to help debug a macro? : sas-macro

0 Answers  


What is the use of %include statement?

0 Answers  


Categories