Converting a .ssd01 to .sas7bdat

Reply
New Contributor
Posts: 4

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?

Super User
Posts: 5,914

Re: Converting a .ssd01 to .sas7bdat

Posted in reply to tyi7689okt
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: 4

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?

Super User
Posts: 4,013

Re: Converting a .ssd01 to .sas7bdat

[ Edited ]
Posted in reply to tyi7689okt

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

 

Super User
Posts: 13,889

Re: Converting a .ssd01 to .sas7bdat

Posted in reply to tyi7689okt

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: 4

Re: Converting a .ssd01 to .sas7bdat

Posted in reply to tyi7689okt

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

Regular Learner
Posts: 1

Re: Converting a .ssd01 to .sas7bdat

Posted in reply to tyi7689okt

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

 

 

Attachment
Super User
Posts: 2,496

Re: Converting a .ssd01 to .sas7bdat

Posted in reply to renzhexiaohou

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

The header will contain something like this:

 

Capture.PNG

 

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

 

 

 

 

 

 

Super User
Posts: 5,914

Re: Converting a .ssd01 to .sas7bdat

Posted in reply to tyi7689okt
Ask a Question
Discussion stats
  • 8 replies
  • 660 views
  • 0 likes
  • 6 in conversation