topic Re: Base SAS to SQL Conversion in SAS Programming https://communities.sas.com/t5/SAS-Programming/Base-SAS-to-SQL-Conversion/m-p/416253#M102193 <P>Don’t attempt a line by line conversion.&nbsp;</P> <P>Determine what the code does and write from scratch in SQL. Otherwise you’ll have inefficient code.&nbsp;</P> Mon, 27 Nov 2017 05:35:43 GMT Reeza 2017-11-27T05:35:43Z Base SAS to SQL Conversion https://communities.sas.com/t5/SAS-Programming/Base-SAS-to-SQL-Conversion/m-p/416250#M102191 <P>Hi Team,</P><P>&nbsp;</P><P>I would like to convert the code from Base SAS to SQL, if yes what is the procedure&nbsp;</P> Mon, 27 Nov 2017 05:25:54 GMT https://communities.sas.com/t5/SAS-Programming/Base-SAS-to-SQL-Conversion/m-p/416250#M102191 Amarnadh 2017-11-27T05:25:54Z Re: Base SAS to SQL Conversion https://communities.sas.com/t5/SAS-Programming/Base-SAS-to-SQL-Conversion/m-p/416251#M102192 <P>Learn both environments and put work into it. There is no "magic button" that does this for you.</P> Mon, 27 Nov 2017 05:28:26 GMT https://communities.sas.com/t5/SAS-Programming/Base-SAS-to-SQL-Conversion/m-p/416251#M102192 Kurt_Bremser 2017-11-27T05:28:26Z Re: Base SAS to SQL Conversion https://communities.sas.com/t5/SAS-Programming/Base-SAS-to-SQL-Conversion/m-p/416253#M102193 <P>Don’t attempt a line by line conversion.&nbsp;</P> <P>Determine what the code does and write from scratch in SQL. Otherwise you’ll have inefficient code.&nbsp;</P> Mon, 27 Nov 2017 05:35:43 GMT https://communities.sas.com/t5/SAS-Programming/Base-SAS-to-SQL-Conversion/m-p/416253#M102193 Reeza 2017-11-27T05:35:43Z Re: Base SAS to SQL Conversion https://communities.sas.com/t5/SAS-Programming/Base-SAS-to-SQL-Conversion/m-p/416368#M102217 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/160607">@Amarnadh</a> wrote:<BR /> <P>Hi Team,</P> <P>&nbsp;</P> <P>I would like to convert the code from Base SAS to SQL, if yes what is the procedure&nbsp;</P> <HR /></BLOCKQUOTE> <P>Lots of questions lately about converting base SAS to SQL. Why? If it works in base SAS, what is the need to convert the code?</P> <P>&nbsp;</P> <P>Anyway, in these threads there is also good advice.</P> <P><A href="https://communities.sas.com/t5/General-SAS-Programming/Proc-sort-with-nodupkey-in-proc-sql/m-p/416144" target="_blank">https://communities.sas.com/t5/General-SAS-Programming/Proc-sort-with-nodupkey-in-proc-sql/m-p/416144</A></P> <P><A href="https://communities.sas.com/t5/General-SAS-Programming/How-to-do-in-proc-sql/m-p/416248" target="_blank">https://communities.sas.com/t5/General-SAS-Programming/How-to-do-in-proc-sql/m-p/416248</A></P> Mon, 27 Nov 2017 13:07:28 GMT https://communities.sas.com/t5/SAS-Programming/Base-SAS-to-SQL-Conversion/m-p/416368#M102217 PaigeMiller 2017-11-27T13:07:28Z