How about this? DATA HAVE; INFILE DATALINES; INPUT ORIG_DATE $; DATALINES; 01/2013 02/2014 04/2012 06/2014 09/2009 12/2008 03/2014 ; RUN; %LET SIXMTH = %SYSFUNC(PUTN(%SYSFUNC(INTNX(MONTH,%SYSFUNC(DATE()), -6, SAME)), DATE9.)); DATA WANT (WHERE = (ORIGDATE BETWEEN DATE() AND "&SIXMTH"D)); SET HAVE; ORGMTH = INPUT(SUBSTR(ORIG_DATE,1,INDEX(ORIG_DATE,'/')-1),BEST2.); ORGYR  = INPUT(SUBSTR(ORIG_DATE,INDEX(ORIG_DATE,'/')+1),BEST4.); ORIGDATE = MDY(ORGMTH,1,ORGYR); FORMAT ORIGDATE DATE9.; RUN; ... View more

orig_date appears as MM\YYYY. When converting this to a date do you want the first day of the month or the last day of the month? ... View more

Did you execute the Proc Format code first? ... View more

We all have to start somewhere. We are here to help when we can. ... View more

How about this? Create a custom format. PROC FORMAT;   PICTURE YMDDT OTHER='%0Y%0M%0D%0H%0M%0S' (DATATYPE=DATETIME); RUN; Create macro variable containing the date and time of right now and use custom format. DATA _NULL_; CALL SYMPUTX ("FNAME","XYZ_ABC_"||TRIM(LEFT(PUT(DATETIME(),YMDDT.)))); RUN; %PUT &FNAME.; ... View more

Hi Lizzy, Are you using the ORACLE Client or OLEDB Client to connect to your ORACLE DB? I worked for a company that used OLEDB to do this and we had a couple of issues, one generated an error very similar to the one you are experiencing.  It appeared to occur only with tables that had dates contained within.  If you know the table structure, try extracting a single field that doesn't contain a date and see if you get the same error, if not try a date field.  In the end we used TO_DATE(TO_CHAR(TRANS_POSTED_DATE,'DD/MM/YYYY'),'DD/MM/YYYY') to extract the relevant dates. I hope this is of some use. Regards, Scott ... View more

Thanks FriedEgg.  I really appreciate how much work you have put into this. ... View more

Hi FriedEgg, There is nothing in the out file and the following in the HeadOut HTTP/1.1 403 Forbidden content-type:application/json; charset=utf-8 x-frame-options:DENY x-mid:9d8aa088047514ddd72fa2ca092775963d2ed955 last-modified:Sun, 06 Jul 2014 07:41:27 GMT status:403 Forbidden date:Sun, 06 Jul 2014 07:41:27 GMT x-ua-compatible:IE=edge,chrome=1 x-transaction:d9024281258f1139 vary:Accept-Encoding pragma:no-cache cache-control:no-cache, no-store, must-revalidate, pre-check=0, post-check=0 x-xss-protection:1; mode=block x-content-type-options:nosniff expires:Tue, 31 Mar 1981 05:00:00 GMT x-runtime:0.00647 set-cookie:guest_id=v1%3A140463248796066399; Domain=.twitter.com; Path=/; Expires=Tue, 05-Jul-2016 07:41:27 UTC set-cookie:_twitter_sess=BAh7CToHaWQiJWViYTU1YTAxMWI5Mzc1NWYxNDRkMGM1ZjgzN2UxZGEyOg9j%250AcmVhdGVkX 2F0bCsIHNieCkcBIgpmbGFzaElDOidBY3Rpb25Db250cm9sbGVy%250AOjpGbGFzaDo6Rmxhc2hIYXNoewAGOgpAdXNlZHsAOgx jc3JmX2lkIiViZDkz%250AZDQ1YTVmYzQ0MWI0M2Q1YWQ3MTU4N2ZkMTRl content-length:105 server:tfe strict-transport-security:max-age=631138519 What does this tell us? ... View more