topic Importing SQL databases in SAS Programming

Importing SQL databases

SAShole — Fri, 02 Mar 2012 14:18:02 GMT

Hi All,

I have data in the following format, Dataset.sql.dat & Dataset.sql.dat.gpg

Is it possible to bring this data into SAS?

I'm running SAS 9.2 64bit on windows XP

thanks,

Importing SQL databases

LinusH — Fri, 02 Mar 2012 15:25:30 GMT

SAS can probably not read those files directly, if they are database files.

SAS can access them trough a common API, such as ODBC and OLEDB.

Are those SQL Server databases?

Either case, you also need a database server up and running to answer calls from SAS via above mentioned API:s.

You aslo probaly need a SAS licence for aprpia te SAS/ACCESS product.

Importing SQL databases

SAShole — Fri, 02 Mar 2012 18:25:16 GMT

It turend out the .sql part was just naming convention (and therefore not an extension) and the .dat part was a generic extension that the client uses and the .gpg is associated with compression.

I changed the .dat to .txt and opened it up in an editior and it was Pipe delimted!

Thanks for your response.

Importing SQL databases

BobD — Sat, 03 Mar 2012 00:01:35 GMT

FYI, the ".gpg" extension usually means it is an encrypted file (using GnuPG, here if interested http://www.gnupg.org/). It's not a "compressed" file per se; although gog normally compresses a file during encryption, you cannout uncompress it yourself. The one without ".gpg" on the end is probably the decrypted copy of the same file.

And note that you did not need to rename the file with ".txt". If it's just a plain text file, any editor can open it by that name.