topic Re: Proc SQL in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-SQL/m-p/152010#M11898 <HTML><HEAD></HEAD><BODY><P>Hi Linus - </P><P></P><P>I think I have got it to work!&nbsp; It was a bad alias in the code......it is running now.</P></BODY></HTML> Fri, 24 Jan 2014 16:19:31 GMT jcb267 2014-01-24T16:19:31Z Proc SQL https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-SQL/m-p/152008#M11896 <HTML><HEAD></HEAD><BODY><P>Hi -</P><P></P><P>I have a lot of code that I migrated from SQL to SAS.&nbsp; When I first migrated it, it ran fine.&nbsp; However, now it will not work and nothing major was changed.&nbsp; I have attached the code and a copy of the error messages I am getting in the log, can someone please take a look at this and let me know what to do?&nbsp; This is driving me crazy!</P><P></P><P>Thanks!</P><P></P><P>John</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/11544i870A445873D17D6E/image-size/large?v=1.0&amp;px=600" border="0" alt="Error Log.jpg" title="Error Log.jpg" /></BODY></HTML> Fri, 24 Jan 2014 14:52:30 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-SQL/m-p/152008#M11896 jcb267 2014-01-24T14:52:30Z Re: Proc SQL https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-SQL/m-p/152009#M11897 <HTML><HEAD></HEAD><BODY><P>Quite some code youä'va attached...</P><P>It would been helpful to get the SAS log instead of the status window.</P><P>"Nothing major has changed". Thing is with IT stuff, computers doesn't really distinguish between minor or major changes, if it doesn't work, it doesn't... So, what minor changes are there?</P></BODY></HTML> Fri, 24 Jan 2014 16:16:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-SQL/m-p/152009#M11897 LinusH 2014-01-24T16:16:19Z Re: Proc SQL https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-SQL/m-p/152010#M11898 <HTML><HEAD></HEAD><BODY><P>Hi Linus - </P><P></P><P>I think I have got it to work!&nbsp; It was a bad alias in the code......it is running now.</P></BODY></HTML> Fri, 24 Jan 2014 16:19:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-SQL/m-p/152010#M11898 jcb267 2014-01-24T16:19:31Z Re: Proc SQL https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-SQL/m-p/152011#M11899 <HTML><HEAD></HEAD><BODY><P>WOOHOOO.....</P><P></P><P>it did work......</P></BODY></HTML> Fri, 24 Jan 2014 16:42:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-SQL/m-p/152011#M11899 jcb267 2014-01-24T16:42:27Z