PROC SQL

[robertrao]

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

[RW9 · Accepted solution]

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]

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]

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