Good point! I tried and failed at the 1st step, when I used the code below, there was no error reported so I thought the libname and connection should be OK. libname DB mysql user = userid password = mypassword schema=dbschema server="thisistheserver.com" port = 3311; It seems do have some problems... Here is the SAS code I used to pull data from DB.existingdata and it do work, please help me on how to upload data if possible, proc sql; connect to mysql (server="thisistheserver.com" port=3311 user=userid password=mypassword); create table want as select * from connection to mysql ( select * from dbschema.existingdata ); disconnect from mysql; quit;
... View more