Using MySQL came out handy for us while designing databases for Clinical Trials where in the scalability is not much of an issue. The performance turns poor when a large number of users are simultaneously accessing the database. We are yet to do some benchmarking on a database with around 24 standard CDISC tables, where data will be entered for close to 200 patients.
Here is the small and handy piece of sas code to extract data off of a mySQL database to SAS
/*Importing datasets from SQL to SAS*/
libname sqllibrary ODBC datasrc='DBDRIVER' user=root password=root schema="testdb";
proc copy out=workdb in=testdb;
exclude validation schema_info;
run;
You will need to install the ODBC driver for MySQL before you venture into running this code
Here is the small and handy piece of sas code to extract data off of a mySQL database to SAS
/*Importing datasets from SQL to SAS*/
libname sqllibrary ODBC datasrc='DBDRIVER' user=root password=root schema="testdb";
proc copy out=workdb in=testdb;
exclude validation schema_info;
run;
You will need to install the ODBC driver for MySQL before you venture into running this code
No comments:
Post a Comment