Date: Tue, 23 Dec 1997 10:07:00 +0000
Reply-To: Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Organization: Crawford Software Consultancy Limited
Subject: Re: SPSS to SAS file conversion utility?
An interesting possibility may have been explored for this.
Has anyone tried DDE to shift data between SAS and SPSS ?
When you only need the table or query content from MS-Access on a batch
basis, you can use DDE instead of the SAS/Access products.
Perhaps the same applies to reading SPSS
It certainly works with other products which "support DDE"
In article <349ED0A3.C24B4A1F@ibm.net>, Tim Churches <tchurch@IBM.NET>
>Allen J. Michielsen wrote:
>> The SAS (free) SPSS Engine only reads the older SPSS transport data
>> files. You have to plan in advance, and specifically create this type
>> of file is you want to use it with SAS. SPSS has told me that they
>> have no plans to continue to provide support for this old engine. > When
>> it 'breaks' in a future SPSS release, it won't be fixed. SAS really should
>> put someone on this as a project and update the engine to read the new
>> SPSS files. This is a big deal in the Windows environment where SPSS is
>> a $600 purchase, and SAS is a much more expensive, annual license.
>Absolutely yes! We are a SAS shop but more and more people are coming to
>us with data in SPSS files. It is absurd that SAS can't read them. Not
>once has anyone ever come along with an SPSS transport file...
>Definitely check out DBMS/COPY. If you license SAS/ACCESS, then consider
>DBMS/Engines. For no more than the cost of a single year's license for
>SAS/ACCESS for PC File formats (so we can read humble dBase and
>spreadsheet files), DBMS/Engines provides an engine which can read and
>write SPSS files (and just about anything else) on the fly - you don't
>even need to convert them. Both nifty and thrifty compared to the
>SAS/ACCESS modules. Details on DBMS/COPY and DBMS/Engines can be found