Date: Thu, 13 Jul 2006 02:59:55 -0500
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: John McConnell <jmcconnell@APPLIED-INSIGHTS.CO.UK>
Subject: Re: List Command output
Content-Type: text/plain; charset=us-ascii
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.
---------- Original Message ----------------------------------
From: Mark Webb <email@example.com>
Reply-To: Mark Webb <firstname.lastname@example.org>
Date: Thu, 13 Jul 2006 09:28:01 +0200
>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.