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,
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.
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.