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
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.
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.
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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.