topic Re: Export data into SAS in SAS Data Science

Export data into SAS

okcken — Fri, 16 Jan 2015 19:31:22 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?

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 into SAS

M_Maldonado — Fri, 16 Jan 2015 19:38:25 GMT

Hey Ken,

Enterprise Miner 13.2 and newer have the Save Data node.

If you are on an older version, got your back here:

I hope it helps,

Miguel

Re: Export data into SAS

M_Maldonado — Fri, 16 Jan 2015 19:43:13 GMT

Ken,

My bad... I first read your question as exporting SAS Enterprise Miner data into base SAS. But you need something else right?

Where are you trying to get your data from? what database? and what is a pathway mapper?

I might have a clue of what you need. But it can't hurt to cross post here:

Good luck!

Re: Export data into SAS

okcken — Fri, 16 Jan 2015 19:59:30 GMT

Thanks, Miguel.

Apparently, Redcap has a way to export data from MySQL database for end users via a Pathway Mapper file. Please see this image below. Ken

Re: Export data into SAS

M_Maldonado — Fri, 16 Jan 2015 20:11:18 GMT

I don't know anything about Redcap... but really nice that they can save your data in sas format already!

As long as you can get a csv, or any kind of data format (txt,xslx,ascii delimited, etc), it is really easy to write a sas program to read your data in. The data step is really flexible and powerful for reading in data.

glad you got what you need. take care!

Re: Export data into SAS

PatrickHall — Fri, 16 Jan 2015 22:10:03 GMT

Ken,

IF you have SAS/ACCESS to MySQL that would be more direct. Your MySQL tables would just show in a SAS library, then you could copy and manipulate them as you like inside SAS.

Also, I think the Save Data Node became available in EM 13.1.

Good Luck,

Re: Export data into SAS

overmar — Sun, 18 Jan 2015 03:16:09 GMT

I have used the redcap SAS import before and its straight forward. The last time I did it it gave me a csv file and a sas program which will important everything including enforced formats, if you used a radio button it will output correctly. However if you used a check all that apply response the file can get quite expansive, and then you need to recode things so that multiple columns of responses will be in a single column. Otherwise its a really nice feature.