|
You can also use SAS's ODBC driver, if you don't have the appropriate
transport file.
Q.
Is there an alternative way to import SAS files without using the GET
SAS command?
A.
You can import SAS files via ODBC using the Database Capture. The
first thing you need to do is obtain the drivers from the SAS Website
(http:\\www.sas.com). Then you must download the Version 1 Universal
Driver. After downloading the executable file double-click on the file
and it will install itself. This driver on their web page is an
evaluation version usable for a thirty day trial period only. After
installing the driver, use the Database Capture as directed in the
SPSS Base Users Guide appropriate to your version of SPSS for Windows.
NOTE:
The SAS driver will import SAS files with the .SD2 extension but will
NOT import SAS transport files with the .XPT extension.
Gail
SPSS Technical Support.
-----Original Message-----
From: Jaclyn Whitehorn [mailto:jaclyn@BAMA.UA.EDU]
Sent: Wednesday, February 10, 1999 1:28 PM
To: SPSSX-L@UGA.CC.UGA.EDU
Subject: Re: Importing SAS files into SPSS
This procedure should work. I don't know if it's the only
one, though:
Step 1:
Convert your SAS file to a transport file: [This is all done
from SAS]
for one file:
LIBNAME TRANFILE XPORT 'location of
transport file';
LIBNAME INFILE 'directory containing data';
PROC COPY IN=INFILE OUT=TRANFILE;
SELECT dataname;
RUN;
for whole library:
LIBNAME TRANFILE XPORT 'location of
transport file';
LIBNAME INFILE 'directory containing data';
PROC COPY IN=INFILE OUT=TRANFILE;
RUN;
Step 2:
Convert the SAS Transport File to a SPSS file: [In SPSS]
GET SAS DATA='location of transport file'
DSET(dataname) .
SAVE outfile='location and name of SPSS file' .
EXECUTE .
The DSET option is not required. If it is not specified,
the first data
set will be used.
--------------------------------------------------
Jaclyn Whitehorn * User Service Consultant
Seebeck Computer Center * University of Alabama
jaclyn@bama.ua.edu * (205)348-8720
| 
