Export data from MySQL/SQL Server to SAS

[okcken]

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

[Reeza · Accepted solution]

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.

[okcken]

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.

[Reeza]

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.

[LinusH]

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.