topic Re: Creating Libnames from MYSQL in SAS Programming

Creating Libnames from MYSQL

sas_Forum — Sat, 15 Dec 2012 06:55:34 GMT

query(1)i am having different schemas in a data base (Database name is Mainsd)in mysql the schemas are like sd1,sd2,sd3,sd4 i want to use the tables in
sas,my first question is i should create different libnames to each schemas how should i create the libnames

Re: Creating Libnames from MYSQL

sas_Forum — Sat, 15 Dec 2012 06:58:56 GMT

2) I want to connect to another database the name of database is Tempsd and this does not have the schemas how can i connect to it by libname

Re: Creating Libnames from MYSQL

Doc_Duke — Tue, 18 Dec 2012 18:56:34 GMT

To, question 1, you can create separate libnames for each schema. The syntax is in the manual. You could also use a passthru query to put the processing burden on the mysql server. Ditto for syntax. (I don't use mysql, so you can look up the syntax as easily as I can.)

I often find it easier to use an interactive tool to connect to the database and get the shells together (I like advanced query tool, but there are lots) and then copy the final product into my SAS passthru.

Doc Muhlbaier

Duke