SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Export data from MySQL/SQL Server to SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Export data from MySQL/SQL Server to SAS

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!SASexport.JPG

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


Accepted Solutions
Solution
‎06-28-2017 11:32 AM
Super User
Posts: 19,810

Re: Export data from MySQL/SQL Server to SAS

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.

View solution in original post


All Replies
Solution
‎06-28-2017 11:32 AM
Super User
Posts: 19,810

Re: Export data from MySQL/SQL Server to SAS

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.

Occasional Contributor
Posts: 8

Re: Export data from MySQL/SQL Server to SAS

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.

Super User
Posts: 19,810

Re: Export data from MySQL/SQL Server to SAS

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.

Super User
Posts: 5,429

Re: Export data from MySQL/SQL Server to SAS

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.

Data never sleeps
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1977 views
  • 0 likes
  • 3 in conversation