01-16-2015 02:31 PM
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.
01-16-2015 02:43 PM
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?
01-16-2015 02:59 PM
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
01-16-2015 03:11 PM
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!
01-16-2015 05:10 PM
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.
01-17-2015 10:16 PM
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.