Base SAS to SQL Conversion

[Amarnadh]

Hi Team,

I would like to convert the code from Base SAS to SQL, if yes what is the procedure 

[Kurt_Bremser]

Learn both environments and put work into it. There is no "magic button" that does this for you.

[Reeza]

Don’t attempt a line by line conversion. 

Determine what the code does and write from scratch in SQL. Otherwise you’ll have inefficient code. 

[PaigeMiller]

---

@Amarnadh wrote:

Hi Team,

I would like to convert the code from Base SAS to SQL, if yes what is the procedure 

---

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?

Anyway, in these threads there is also good advice.

https://communities.sas.com/t5/General-SAS-Programming/Proc-sort-with-nodupkey-in-proc-sql/m-p/41614...

https://communities.sas.com/t5/General-SAS-Programming/How-to-do-in-proc-sql/m-p/416248