Hi,
I have a very lengthy SQL code... COULD someone help me do an equivalent SAS code(preferably PROC SQL) and data steps???
Let me know so that I can post the code.
Thanks
Hi,
The length of SQL code should not matter, just pop a proc sql; before and quit; after. That is presuming that you don't have any non standard SQL statements within the code, and it is using data in SAS. You could maybe post the code, and would have a flick through but I wouldn't expect to re-engineer something.
Hi,
The length of SQL code should not matter, just pop a proc sql; before and quit; after. That is presuming that you don't have any non standard SQL statements within the code, and it is using data in SAS. You could maybe post the code, and would have a flick through but I wouldn't expect to re-engineer something.
Hi
I have a similar issue but my sql consists declare and begin statement and some array which has been written in SQL.
You need to start a new thread. A lot of people won't even look at this one because it is marked 'Answered.'
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.