Converting a .ssd01 to .sas7bdat

Reply
New Contributor
Posts: 3

Converting a .ssd01 to .sas7bdat

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?

Esteemed Advisor
Posts: 5,198

Re: Converting a .ssd01 to .sas7bdat

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?
Data never sleeps
New Contributor
Posts: 3

Re: Converting a .ssd01 to .sas7bdat

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?

Respected Advisor
Posts: 3,062

Re: Converting a .ssd01 to .sas7bdat

[ Edited ]

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

 

Grand Advisor
Posts: 10,210

Re: Converting a .ssd01 to .sas7bdat

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.

 

 

New Contributor
Posts: 3

Re: Converting a .ssd01 to .sas7bdat

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

Ask a Question
Discussion stats
  • 5 replies
  • 152 views
  • 0 likes
  • 4 in conversation