topic Re: PROC SQL in SAS Procedures

PROC SQL

robertrao — Thu, 29 May 2014 13:53:28 GMT

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

Re: PROC SQL

RW9 — Thu, 29 May 2014 13:55:54 GMT

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.

Re: PROC SQL

Arbind1983_SAS — Fri, 22 Aug 2014 07:41:04 GMT

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

Re: PROC SQL

Doc_Duke — Fri, 22 Aug 2014 18:53:59 GMT

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