Help using Base SAS procedures

PROC SQL

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,041
Accepted Solution

PROC SQL

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


Accepted Solutions
Solution
‎05-29-2014 09:55 AM
Super User
Super User
Posts: 7,977

Re: PROC SQL

Posted in reply to robertrao

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


All Replies
Solution
‎05-29-2014 09:55 AM
Super User
Super User
Posts: 7,977

Re: PROC SQL

Posted in reply to robertrao

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.

Learner
Posts: 1

Re: PROC SQL

Hi

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

Trusted Advisor
Posts: 2,116

Re: PROC SQL

Posted in reply to Arbind1983_SAS

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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