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 sas database server? : Sas-di

0 Answers  


What are the default statistics that proc means produce?

0 Answers  


Did you used proc lifetest? when?

2 Answers   Accenture, Parexel, Quintiles,


how do you derive descriptive statistics?

1 Answers   Accenture, Quintiles,


what is program data vector? : Sas-administrator

0 Answers  






if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.

2 Answers  


code the tables statement for a single level frequency?

2 Answers  


If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?

8 Answers   HCL,


In the flow of DATA step processing, what is the first action in a typical DATA Step?

9 Answers  


What do the PUT and INPUT functions do?

0 Answers  


What is the function of output statement in a SAS Program?

0 Answers  


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  


Categories