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
Comments: To: dbuchanan@sigma3.ca
Content-Type: text/plain; charset="iso-8859-1"

Dan

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)
1
2
3

carol
sacramento ca





> -----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.
>
> TIA
>
> Dan
>