topic Re: Converting a .ssd01 to .sas7bdat in SAS Programming

Converting a .ssd01 to .sas7bdat

tyi7689okt — Wed, 08 Mar 2017 18:25:46 GMT

I have a .ssd01 file I need to convert to a .sas7bdat file.

I initially tried to do this on linux (where the file was created), but it appears there is no v6 engine in Linux 9.4:

http://support.sas.com/kb/34/762.html

So I attempted it on windows (using data step, proc copy), but SAS on windows does not recognize the files because they were created in Linux.

http://support.sas.com/kb/44/490.html

I have also tried proc cport/cimport and xport, but they seem to require me to use v6 (they say the file does not exist, or the directory is empty).

Does anyone know a way to accomplish this?

Re: Converting a .ssd01 to .sas7bdat

LinusH — Wed, 08 Mar 2017 19:03:47 GMT

As per the note, it couldn't been created in Linux. You need to figure out on what platform it was created.
Where did you the file?

Re: Converting a .ssd01 to .sas7bdat

ballardw — Wed, 08 Mar 2017 19:08:27 GMT

The first support note tells you exactly what the SAS solution would be: To circumvent the problem, convert SAS data sets to the V9 format using SAS 9.xx on an operating system for which there was a SAS 6.xx release.

That would likely also involve a 32 bit system not 64.

Another option is there are some older file format translation problems that may be able to turn the SSD to another format though likely not the latest sasybdat. I would suggest making a CSV file and importing that. Maybe something like DBMSCopy.

Or see if your data source happens to have an original text file and programs to remake the set from scratch.

Re: Converting a .ssd01 to .sas7bdat

tyi7689okt — Wed, 08 Mar 2017 19:11:52 GMT

It was from a server where we keed archived files. So there's no way for me to convert it just using windows or linux?

Re: Converting a .ssd01 to .sas7bdat

SASKiwi — Wed, 08 Mar 2017 23:07:42 GMT

I'd suggest opening a track with SAS Tech Support on this. They may be able to identify the operating system the file was originally created if you can provide a copy for them.

According to the following reference the V6 dataset was created on HP-UX, Sun, Solaris, AIX, or MIP ABI Unix and would have been SAS version 6.09 / 6.10 / 6.11 / 6.12. Linux wasn't supported by SAS then.

http://support.sas.com/documentation/cdl/en/movefile/59598/HTML/default/viewer.htm#a000987012.htm

Re: Converting a .ssd01 to .sas7bdat

tyi7689okt — Tue, 14 Mar 2017 15:39:23 GMT

Thanks everyone for the suggestions. I ended up finding an archived transfer file of the dataset I was able to use.

Re: Converting a .ssd01 to .sas7bdat

renzhexiaohou — Sat, 20 Jan 2018 14:49:34 GMT

Hi:

I'm from China, yubo Xiao an student in a research group in university.

Now i met the same problem as you described in this forum. And the data is important for our research (the data was from 20+ years ago). I have tried several ways but it did't seem to be done (including different version of sas had been used excepted 9.2 32bit SAS).

Might you provide some information or methods about how to complete the data conversion.

Looking forward to your reply！

Best,

yubo

Re: Converting a .ssd01 to .sas7bdat

ChrisNZ — Sun, 21 Jan 2018 22:40:07 GMT

You can open the file in notepad to ascertain how it was created.

The header will contain something like this:

There is binary information, but also a string showing the platform and SAS version used for creation.

Re: Converting a .ssd01 to .sas7bdat

LinusH — Mon, 22 Jan 2018 07:24:05 GMT

Try @ChrisHemedinger's suggestion:
https://communities.sas.com/t5/Base-SAS-Programming/Open-SD2-file-and-convert-to-CSV/m-p/403548/highlight/true#M98063