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 (July 2006)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
=========================================================================
Date:         Thu, 13 Jul 2006 02:59:55 -0500
Reply-To:     jmcconnell@Applied-insights.co.uk
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         John McConnell <jmcconnell@APPLIED-INSIGHTS.CO.UK>
Subject:      Re: List Command output
Comments: To: Mark Webb <targetlk@iafrica.com>
Content-Type: text/plain; charset=us-ascii

Hi Mark

If you use the Case Summaries option (from memory this is in thenAnalyze>Reports menu and in syntax SUMMARIZE) you get a list inside a pivot table which is the key to Excel compatibility.

From there you should be able to cut/paste or even export the table to Excel to keep more of the formatting.

hth

john

John McConnell Applied Insights

---------- Original Message ---------------------------------- From: Mark Webb <targetlk@iafrica.com> Reply-To: Mark Webb <targetlk@iafrica.com> Date: Thu, 13 Jul 2006 09:28:01 +0200

>Hi all >I'm using the List Command to list selected respondents and a few variables. >e.g. List Variables = Name Branch Dept Var1 Var2 Var3. > >When I copy & past into Excel all variables listed go into one column. >How can I get a SPSS output that will export into columns - like for example the Frequencies command ? >The print command is much the same. > >Regards > >Mark Webb


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