DATA Step, Macro, Functions and more

Creating Libnames from MYSQL

Reply
Frequent Contributor
Posts: 140

Creating Libnames from MYSQL

HI

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

Frequent Contributor
Posts: 140

Re: Creating Libnames from MYSQL

HI

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


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

Trusted Advisor
Posts: 2,113

Re: Creating Libnames from MYSQL

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

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