Hi Team,
I would like to convert the code from Base SAS to SQL, if yes what is the procedure
Learn both environments and put work into it. There is no "magic button" that does this for you.
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.
@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/How-to-do-in-proc-sql/m-p/416248
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.