Here's some code that gets you back and forth between char and date formats:   data have; format date datetime18.; date = '23OCT2015:10:40:30'dt; date_char = input(put(date,datetime18.),$18.); run; data want; set have(keep=date_char); format date date9.; date = input(put(date_char,$18.),date9.); run; ... View more

@Patrick, I am back to programming after a long break, and it feels rusty!! One thing I still cannot resolve is the note you have mentioned, i.e. "Character values have been converted to numeric values at the places.." ... View more

Quentin and Chris, Thank you for your input. I have closed the session, reopened and executed the same code - and it works now. Atleast I have learnt something new from you two. ... View more

The code snippet you've posted is not valid SAS syntax.   date = datepart(DDMMMYYY:00:00:00)   Not sure what you're proposing here and why. ... View more

Hello Jaap, That helped. I have installed some older versions, but prod and test are on the same platform now. Installation was okay, some pain was there at the post installation procedure. And those are done too. SAS institute helped as well, in finding some hotfix files. Thank you. ... View more

What version of SAS and EG do you have? What is your "usual" connection time and your "slow" time? Does the slowness vary through the day or is it always slow? I am assuming EG connects to SAS via your SAS metadata server so are all of your SAS servers - metadata and compute server - on the same physical Linux server? ... View more

Like PG has already pointed out, Proc SQL can't product multiple tables in one pass. However, Hash() can offer a one step approach: data ds1 ds2 ds3;   if _n_=1 then do;      declare hash ds1(dateset:'tab2(keep=id)');   ds1.definekey('id');   ds1.definedone();      declare hash ds2(dateset:'tab3(keep=id)');   ds2.definekey('id');   ds2.definedone();      declare hash ds3(dateset:'tab4(keep=id)');   ds3.definekey('id');   ds3.definedone();   end;   set tab1;     if ds1.check() ne 0 then output ds1;   if ds1.check()*ds2.check() ne 0 then output ds2;   if ds1.check()*ds2.check()*ds3.check() ne 0 then output ds3; run; Not tested, so there maybe typos. Haikuo ... View more

In SAS all the dates will be in numeric format that's the reason you are getting value as 18871 in the code above. Just try the below code you will be getting the proper date. E_Date=input(E_Date_Time, mmddyy10.); E_Time=scan(E_Date_Time, -1,' '); E_Date_Time_New=catx(':',put(E_Date, mmddyy10.), E_Time); In the third statement I have converted the numric date to character date again, so that you will get the required date format value. Regards, Moovendhan D ... View more