LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 1997, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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> writes >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. >> al > >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 >at http://www.conceptual.com > >Tim Churches

-- Peter Crawford


Back to: Top of message | Previous page | Main SAS-L page