Date: Tue, 19 Apr 2005 12:35:03 -0700
Reply-To: "Parise, Carol A." <PariseC@sutterhealth.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Parise, Carol A." <PariseC@sutterhealth.org>
Subject: Re: Excel Tables as Input data
Content-Type: text/plain; charset="iso-8859-1"
it may take some manipulation on your part but if you can set up the data with cases going down and variables going across with spss-friendly variable names they you are in business.
id var1 var2 (note that these need to go in the top row)
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On
> Behalf Of
> Dan Buchanan
> Sent: Tuesday, April 19, 2005 12:30 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: Excel Tables as Input data
> I have a number of excel tables containing various
> demographic groupings
> (grouped counts for the most part)of labour force data and
> I'm interested in
> doing some analysis on the content of those tables (e.g. chi
> square). Is it
> possible to have spss (vers 11.5) read and analyse tabulated
> data? If so,
> any assistance on how this might be done would be greatly appreciated.