Sorting SPSSX output in Word

[Bob Schacht-3]

When I use CATPCA analysis with ver. 16, and copy the Component Loadings
table to Word, I usually want to sort the table on descending values of
Dimension 1. However, when I try to do this, Word responds in a huff that
"Word cannot sort this table because all of its rows are table headings."
However,  I can paste it into Excel and sort it there. How can I avoid the
annoyance of this extra step?

Bob Schacht

Robert M. Schacht, Ph.D. <[hidden email]>
Pacific Basin Rehabilitation Research & Training Center
1268 Young Street, Suite #204
Research Center, University of Hawaii
Honolulu, HI 96814

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Lemon, John S.]

Bob

 

When a table displays strange behaviour like that in Word I ‘convert the table to text’ with tabs as the delimiters and then ‘convert the text the text to table’ and in 95 cases out of 100 it works – don’t ask me why !!

 

Best Wishes

 

John S. Lemon

Student Liaison Officer

Directorate of Information Technology (DIT) - University of Aberdeen

Edward Wright Building: Room G51

 

Tel:  [phone]

Fax: [phone]

 

Diary ( Free / Busy )

 

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bob Schacht
Sent: Wednesday, May 13, 2009 8:43 PM
To: [hidden email]
Subject: Sorting SPSSX output in Word

 

When I use CATPCA analysis with ver. 16, and copy the Component Loadings

table to Word, I usually want to sort the table on descending values of

Dimension 1. However, when I try to do this, Word responds in a huff that

"Word cannot sort this table because all of its rows are table headings."

However,  I can paste it into Excel and sort it there. How can I avoid the

annoyance of this extra step?

 

Bob Schacht

 

Robert M. Schacht, Ph.D. <[hidden email]>

Pacific Basin Rehabilitation Research & Training Center

1268 Young Street, Suite #204

Research Center, University of Hawaii

Honolulu, HI 96814

 

=====================

To manage your subscription to SPSSX-L, send a message to

[hidden email] (not to SPSSX-L), with no body text except the

command. To leave the list, send the command

SIGNOFF SPSSX-L

For a list of commands to manage subscriptions, send the command

INFO REFCARD

The University of Aberdeen is a charity registered in Scotland, No SC013683.