DATA Step, Macro, Functions and more

Base SAS to SQL Conversion

Reply
Contributor
Posts: 33

Base SAS to SQL Conversion

Hi Team,

 

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

Super User
Posts: 10,280

Re: Base SAS to SQL Conversion

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 23,776

Re: Base SAS to SQL Conversion

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. 

Respected Advisor
Posts: 3,061

Re: Base SAS to SQL Conversion


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

--
Paige Miller
Ask a Question
Discussion stats
  • 3 replies
  • 157 views
  • 2 likes
  • 4 in conversation