CODEWITHSUNDEEP
sas
Skaqqs
Skaqqs

Reputation: 4140

How to convert SAS's .SSD to .CSV?

I'm having trouble converting .SSD files to .CSV. I first attempted this with SAS Universal Viewer, but that didn't work. Now I'm using SAS Studio On-Demand for Academics. The data I'm using are from here.

I uploaded two data files (ACCIDENT.SSD and VEHICLE.SSD) from that source to a folder called NASS in SAS Studio and attempted to define that folder as a new library. However, I'm getting hung up on the library creation step.

LIBNAME NASS v6 '/home/u59316558/sasuser.v94/NASS';
PROC EXPORT DATA=NASS.ACCIDENT
            OUTFILE="/home/u59316558/sasuser.v94/CARS.csv"
            dbms=csv replace;

which returns

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 68         
 69         LIBNAME nass v6 '/home/u59316558/sasuser.v94/NASS';
 ERROR: The V6 engine cannot be found.
 ERROR: Error in the LIBNAME statement.
 70         PROC EXPORT DATA=NASS.ACCIDENT
 71         OUTFILE="/home/u59316558/sasuser.v94/CARS.csv"
 72         dbms=csv replace;
 73         
 74         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to 
 WORK.PARMS.PARMS.SLIST.
 ERROR: Libref NASS is not assigned. 
 ERROR: Export unsuccessful.  See SAS Log for details.
 84

How can I convert these .SSD file to .CSV in SAS Studio or otherwise?

Upvotes: 0

Views: 440

Answers (1)

Joe
Joe

Reputation: 63424

Per the Libname engine documentation, you likely cannot read these in directly, with any current version of SAS. .ssd files are v603 or v604 datasets, and unfortunately x64 64-bit SAS does not have the ability to read these in whatsoever, barring reverse-engineering the file format.

As noted in Tom's comment, your best option is likely a third party such as Stat/Transfer or similar which might allow you to read it in, or failing that finding a 32-bit SAS installation - but that's likely difficult to do at this point.

Upvotes: 1

Related Questions