hi i date is 05sep2005; i want the oupput like

05sep2005:00:00:00 ; how it wil come?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

AE datasets names? how many types?

2084


Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2106


how many types prompting framework can be broken down to? : Sas-bi

640


where are dashboard components are created and maintained? : Sas-bi

581


what is sas database server? : Sas-di

623






What is the difference between match merge and one to one merge?

699


How would you define the end of a macro?

711


what is the Population you used in your project, is it ITT or PP?

2193


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2308


explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

560


Explain proc sort?

684


what is data integration? : Sas-di

624


hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

1692


How would you invoke a macro? : sas-macro

563


What does proc print, and proc contents are used for?

617