Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    1

    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.

    many thanks,
    Dan

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You need a SAS tool called CEDA to do that.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •