Thread: mysqldump from SAS database?
07-20-10, 14:12 #1Registered User
- Join Date
- Jul 2010
Unanswered: mysqldump from SAS database?
Hello. At my workplace the db managers join and make data available in a few tables from a large variety of Oracle databases to the wider group of scientists in SAS data tables as this is what many people use as their statistical software. We are moving from this though and many of us are now using R for statistics and other open source solutions such as MySQL and postgreSQL. My problem is that I now want to dump the SAS databases in a format like mysqldump does for quick import into MySQL. I know that SAS can export individual tables but this requires a lot of time and I would need to reimport many tables about every six months. I am looking for relatively quick and robust solutions. This tends to be the kind of thing that proprietary software does not do because it allows people to migrate away from these products too easily.
Does anyone know how to dump SAS databases in a format like mysqldump? Is there already a SAS solution or a SAS script available that can do this.
07-20-10, 14:27 #2Resident Curmudgeon
Provided Answers: 54
- Join Date
- Feb 2004
- In front of the computer
You need a SAS tool called CEDA to do that.
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.