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
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.