How do we convert SAS code to MS SQL?

Reply
Regular Contributor
Posts: 162

How do we convert SAS code to MS SQL?

Hi,

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

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

Super User
Posts: 5,258

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

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.

Data never sleeps
Regular Contributor
Posts: 162

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

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.....

PROC Star
Posts: 1,095

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

Hi, Sheeba

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

Tom

Regular Contributor
Posts: 162

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

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

PROC Star
Posts: 1,095

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

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

Super User
Posts: 3,112

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

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?

Ask a Question
Discussion stats
  • 6 replies
  • 2549 views
  • 0 likes
  • 4 in conversation