New SAS User

Completely new to SAS or trying something new with SAS? Post here for help getting started.
BookmarkSubscribeRSS Feed
laxmanpai
Calcite | Level 5

Hi All, Could anyone suggest me as to how can i convert a SAS code to SQL stored procedure.

Is there any tool to convert sas code to SQL.

Awaiting your reply 

 

Regards

pai

2 REPLIES 2
Jagadishkatam
Amethyst | Level 16
I don't think there is any tool to convert the sas code to SQL we need to do that manually by coding in sql.
Thanks,
Jag
Kurt_Bremser
Super User

Yes, there is a tool. It sits between your ears.

 

SAS data step code is quite different from SQL; there are lots of things you can't do with SQL, or can only do with complicated code. Nothing that a simple translation tool could reliably do.

sas-innovate-white.png

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 864 views
  • 1 like
  • 3 in conversation