BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
robertrao
Quartz | Level 8

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

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

View solution in original post

3 REPLIES 3
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

Arbind1983_SAS
Calcite | Level 5

Hi

I have a similar issue but my sql consists declare and begin statement and some array which has been written in SQL.

Doc_Duke
Rhodochrosite | Level 12

You need to start a new thread.  A lot of people won't even look at this one because it is marked 'Answered.'

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1476 views
  • 0 likes
  • 4 in conversation