topic Export data from MySQL/SQL Server to SAS in SAS Data Management

Export data from MySQL/SQL Server to SAS

okcken — Fri, 16 Jan 2015 20:01:21 GMT

Hello,

I am trying to do seamless export of data from a database to SAS. I am trying to follow the Redcap model of downloading three files: SAS file, Pathway mapper and CSV file. Does anyone in the community know how to go about implementing this? Please see the attached file on how they are doing it....Any advice is greatly appreciated!

Sorry, if I am asking this question in the wrong discussion community. If I am, please direct me to the right group.

Thank you!

Ken

Re: Export data from MySQL/SQL Server to SAS

Reeza — Fri, 16 Jan 2015 20:05:02 GMT

The instructions seem pretty clear there, have you tried them?

Download all 3 files, run .bat file, then open .sas file which will import the .csv file.

Or you can probably import the .csv file directly using proc import.

Have you run into issues with this method?

In general, it's actually easier to map and ODBC connection to the DB and then connect to the DB and import it directly. There are methods for doing that on this forum.

Re: Export data from MySQL/SQL Server to SAS

okcken — Fri, 16 Jan 2015 21:17:14 GMT

Thanks, Reeza.

I am trying to figure out what the .bat file does? and how do we create a .sas file? I am trying to create a similar procedure with another system.

Re: Export data from MySQL/SQL Server to SAS

Reeza — Fri, 16 Jan 2015 21:18:59 GMT

Do you need to? Like I mentioned using an ODBC driver is your best bet.

You can also just export to CSV and then the .sas file is a text file essentially. It's a program file that specifies how to import the CSV file most likely.

Re: Export data from MySQL/SQL Server to SAS

LinusH — Sat, 17 Jan 2015 15:15:56 GMT

Ant questions regarding Redcap SW should be asked in their direction.

If you wish to design your own architecture, just need to tell us more about your application, constraints and requirements.