03-08-2017 01:25 PM
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:
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.
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?
03-08-2017 02:55 PM - edited 03-08-2017 06:07 PM
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.
03-08-2017 02:08 PM
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.
01-20-2018 09:49 AM
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！
01-21-2018 05:40 PM
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.
01-22-2018 02:24 AM