Formatting corr matrix - only want below diagnol

[jpwi...@umsl.edu]

Does anyone know a fast way to delete the correlations in the top half
of a correlation matrix (above the diagnol)? Any SPSS, Excel, Word,
or WordPerfect solutions would be greatly appreciated.

[Markus Quandt]

Go to http://www.ssicentral.com/, follow the link to 'free
downloads' or such, and download 'full2sym.zip'. This converts
matrices in ASCII files from full to 'lower-half' format, output
goes to another ASCII file.

MQ

--
----------------------------------------------------------------
Markus Quandt qua...@wiso.Uni-Koeln.DE
Universitaet zu Koeln
University of Cologne, Germany

[Clay Helberg]

On Fri, 23 Oct 1998 18:36:20 +0100, qua...@wiso.Uni-Koeln.DE (Markus
Quandt) wrote:

>In article <36308524...@news.umsl.edu>, jpwi...@umsl.edu wrote:
>>Does anyone know a fast way to delete the correlations in the top half
>>of a correlation matrix (above the diagnol)? Any SPSS, Excel, Word,
>>or WordPerfect solutions would be greatly appreciated.
>
>Go to http://www.ssicentral.com/, follow the link to 'free
>downloads' or such, and download 'full2sym.zip'. This converts
>matrices in ASCII files from full to 'lower-half' format, output
>goes to another ASCII file.
>

With SPSS 7.5 and above, there is an autoscript which will do this for
you automatically every time you generate a correlation matrix in
SPSS. To activate it, from the menus choose Edit->Options, select the
Scripts tab, make sure Autoscripts are enabled (checkbox), and make
sure the script called Correlations_Table_Correlations_Create is
active (another checkbox). From that point on, whenever you generate a
correlation table, the script will remove the upper-diagonal portion
of the table, and also highlight significant correlations.

HTH

--Clay

Clay Helberg http://www.execpc.com/~helberg/
SPSS Documentation and Training chel...@spss.com
Speaking only for myself....

[jpwi...@umsl.edu]

This works with one significant problem: when I copy the table to
Excel for formating (Excel's a bit better for that ;> ), the full
matrix gets copied. Can the script be automated to actually delete
the numbers rather than hide them.

I guess a better question is: can _I_ automate the script without
wasting the whole afternoon trying to get it to work.

TIA

[Clay Helberg]

On Mon, 26 Oct 1998 14:52:08 GMT, jpwi...@umsl.edu wrote:

Unfortunately, I don't know of a way to delete the contents of a pivot
table cell via automation. Perhaps someone with more experience will
chime in with a way to do this.

Just out of curiosity, in what way is Excel's table formatting better
than SPSS's? I have found that I can do pretty much any formatting I
want to in SPSS, but perhaps I'm not pushing it to the same limits you
are.

--Clay

[ma...@spss.com]

I was just browsing ...
A way to delete the contents of a pivot table cell via automation.

objDataCellArray.ValueAt(i,j)=""
i is the row index
j is the column index
objDataCellArray is the dataCellArray Object...

David
Please direct all comments/questions to the newsgroup!

In article <3634afb1....@news.uswest.net>,

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[reim...@uvic.ca]

On Saturday, October 24, 1998 at 12:00:00 AM UTC-7, Clay Helberg wrote:
> On Fri, 23 Oct 1998 18:36:20 +0100, qua...@wiso.Uni-Koeln.DE (Markus
> Quandt) wrote:
>
> >In article <36308524...@news.umsl.edu>, jpwi...@umsl.edu wrote:
> >>Does anyone know a fast way to delete the correlations in the top half
> >>of a correlation matrix (above the diagnol)? Any SPSS, Excel, Word,
> >>or WordPerfect solutions would be greatly appreciated.
> >
> >Go to http://www.ssicentral.com/, follow the link to 'free
> >downloads' or such, and download 'full2sym.zip'. This converts
> >matrices in ASCII files from full to 'lower-half' format, output
> >goes to another ASCII file.
> >
>

> With SPSS 7.5 and above, there is an autoscript which will do this for
> you automatically every time you generate a correlation matrix in
> SPSS. To activate it, from the menus choose Edit->Options, select the
> Scripts tab, make sure Autoscripts are enabled (checkbox), and make
> sure the script called Correlations_Table_Correlations_Create is
> active (another checkbox). From that point on, whenever you generate a
> correlation table, the script will remove the upper-diagonal portion
> of the table, and also highlight significant correlations.
>

> HTH
>
> --Clay

>
> Clay Helberg http://www.execpc.com/~helberg/
> SPSS Documentation and Training chel...@spss.com
> Speaking only for myself....

Hello: But my SPSS24 does not have a script when I toggle the script box. Where are these? Which folder do I need to access for these?
Tom

[Bruce Weaver]

On Wednesday, September 6, 2017 at 1:08:40 PM UTC-4, reim...@uvic.ca wrote:
> On Saturday, October 24, 1998 at 12:00:00 AM UTC-7, Clay Helberg wrote:
> > On Fri, 23 Oct 1998 18:36:20 +0100, qua...@wiso.Uni-Koeln.DE (Markus

--- snip a bunch of old posts from 1998 ---

>
> Hello: But my SPSS24 does not have a script when I toggle the script box. Where are these? Which folder do I need to access for these?
> Tom

Hello Tom. A lot has changed since 1998. For one thing, this usenet discussion forum has become a lot less active than it used to be. I suggest you post your question to the SPSSX-L mailing list, which is a lot more active these days. You can join and post via the Nabble archive:

http://spssx-discussion.1045642.n5.nabble.com/

HTH.

[David Marso]

I answered this question on Nabble yesterday.