topic Re: How do we convert SAS code to MS SQL? in SAS Programming

How do we convert SAS code to MS SQL?

Sheeba — Mon, 20 Aug 2012 05:11:31 GMT

Hi,

I would like to convert some SAS code to MS SQL.

It would be really great if some one can help me out

Re: How do we convert SAS code to MS SQL?

LinusH — Mon, 20 Aug 2012 10:17:45 GMT

If you have e specific questions about converting program, feel free to post them.

If you need general guidance, you are better off contacting i.e. a SAS/MS consultancy.

Re: How do we convert SAS code to MS SQL?

TomKari — Mon, 20 Aug 2012 14:32:04 GMT

Hi, Sheeba

Email me at gishpuppy.x0k@gishpuppy.com and we can discuss your requirements further offline.

Tom

Re: How do we convert SAS code to MS SQL?

Sheeba — Mon, 20 Aug 2012 19:22:56 GMT

Hi,

Thanks for the response....

Actually I am looking for converting statistical procedures like PROC MEANS, PROC SUMMARY etc to MS SQL.

Is there any tool available for conversion?

It will be really great if you can provide some guidance on this.....

Re: How do we convert SAS code to MS SQL?

Sheeba — Mon, 20 Aug 2012 19:23:44 GMT

Hi,

Thanks for the response....

Actually I am looking for converting statistical procedures like PROC MEANS, PROC SUMMARY etc to MS SQL.

Is there any tool available for conversion?....

your help is greatly appreciated

Re: How do we convert SAS code to MS SQL?

SASKiwi — Mon, 20 Aug 2012 20:15:10 GMT

I am curious to know why you wish to convert PROC MEANS into MS SQL, when you can run this procedure directly on an SQL Server database table and SAS handles all of the conversion, assuming you have an appropriate SAS/ACCESS product licensed like SQL Server. OLE DB or ODBC?

Re: How do we convert SAS code to MS SQL?

TomKari — Mon, 20 Aug 2012 20:16:51 GMT

SAS statistical procedures like PROC MEANS and PROC SUMMARY can be used for a variety of statistical operations, from very simple statistics that can easily be replicated in SQL, to sophisticated results that would be almost impossible to reproduce.

I've never heard of any tools to do this kind of migration. All I can suggest is that you first examine the SAS code, to understand clearly what it is doing, and then search for the equivalent statistical operations using SQL.

When you use the term MS SQL, do you mean that you want to implement these operations in the SQL language for Microsoft SQL Server, or do you intend to use more sophisticated tools like SQL Server Analysis Services?

Tom