https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260192#M50458 <P>What database and which SAS/ACCESS product are you using?&nbsp;</P> Wed, 30 Mar 2016 18:29:38 GMT SASKiwi 2016-03-30T18:29:38Z https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260150#M50448 <P>I am having a problem with date conversion.&nbsp; Sor some reason when I pull information from my datawarehouse using the datapart function in SQL the number ends up with a character format.&nbsp; When I use the same procedure on a different table that has the date formatted the same way, the variable comes down as a numeric.&nbsp; I checked the tables to make sure they are formatted the same way, and they are exactly the same.&nbsp; In the meantime I just pulled the data&nbsp;using SQL in step one, and formatted the data in a "data step" in step two and that works.&nbsp; But I am wordering if this is a common problem.&nbsp; I had been running this job for over 2 years and had no problems.&nbsp; I have enclosed an attachment that details my results.&nbsp; SAS enterprise guide 6.1 64-bit</P> Wed, 30 Mar 2016 16:27:32 GMT https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260150#M50448 pangea17 2016-03-30T16:27:32Z https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260154#M50449 <P>This is a question for tech support.</P> Wed, 30 Mar 2016 16:36:06 GMT https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260154#M50449 Reeza 2016-03-30T16:36:06Z https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260184#M50457 <P>Could it be this?</P> <P>&nbsp;</P> <P><A href="http://support.sas.com/kb/47/918.html" target="_blank">http://support.sas.com/kb/47/918.html</A></P> Wed, 30 Mar 2016 18:16:49 GMT https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260184#M50457 data_null__ 2016-03-30T18:16:49Z https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260192#M50458 <P>What database and which SAS/ACCESS product are you using?&nbsp;</P> Wed, 30 Mar 2016 18:29:38 GMT https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260192#M50458 SASKiwi 2016-03-30T18:29:38Z https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260535#M50570 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/15692">@pangea17</a>&nbsp;I see you "liked" my post. &nbsp;Does that mean it help you solve the problem and if so could you show the code you changed or whatever you did. &nbsp;It would help to know if/how you fixed it. &nbsp;It may be useful to others.</P> Thu, 31 Mar 2016 19:59:32 GMT https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260535#M50570 data_null__ 2016-03-31T19:59:32Z https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260540#M50574 <P>It didn't work as of yet, but my IT department is looking into the problem.</P> Thu, 31 Mar 2016 20:17:54 GMT https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260540#M50574 pangea17 2016-03-31T20:17:54Z https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260546#M50576 <P>Did you try the option?</P> <P>&nbsp;</P> <PRE>A problem will result if later code treats that variable as a DATE rather than as a DATETIME. <BR />The only workaround is to turn off implicit pass-through so that the function is not passed <BR />to the DBMS and is instead processed by SAS. This can be done by setting the <FONT color="#FF0000">DIRECT_EXE= LIBNAME</FONT> option.</PRE> Thu, 31 Mar 2016 20:26:01 GMT https://communities.sas.com/t5/SAS-Programming/datapart-function-works-half-the-time/m-p/260546#M50576 data_null__ 2016-03-31T20:26:01Z