Learning SAS? Welcome to the exclusive online community for all SAS learners.

SAS access to ODBC

Reply
Occasional Contributor
Posts: 5

SAS access to ODBC

Hi

I am new to this community so please let me know if this is a stupid question. I have SAS university edition installed. I understand that the unversity edition does not list ACCESS to ODBC as an incluced product. But when I do a proc setinit it said it is included. Does it mean I can connect my university edition of SAS to my MYSQL database? If yes, can anyone show me how to do it?

Thanks

Raymond Wan

SAS Employee
Posts: 147

Re: SAS access to ODBC

Not a stupid question at all!  SAS/ACCESS to ODBC is not included in University Edition and the PROC SETINIT output is a bit misleading.  We actually would love to include the functionality but have some issues including the necessary drivers in the Linux VM that SAS is delivered in.  It's on the wish list and it helps to know that folks are interested.  If there are other use cases out there, please let us know.

Regular Contributor
Posts: 219

Re: SAS access to ODBC

Rwan,

Thinking around the limitations, here is a possible solution you might be able to try.

1 - Use Excel on Windows to link to your MySQL Tables using ODBC.

2 - Use SAS University Edition to Import the Excel sheets you defined in step 1. (SAS/ACCESS to PC File Format)

If this works, then it will give you access to the data, but all the processing would take place in SAS! Not exactly equivalent to using SAS/ACCESS to ODBC, but better than nothing.

Just a thought,

Ahmed

Ask a Question
Discussion stats
  • 2 replies
  • 933 views
  • 0 likes
  • 3 in conversation