Displaying Only Correlations

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Displaying Only Correlations

Feinstein, Zachary
Brock,

The following autoscript will take care of the correlations part.
Zachary

Sub Correlations_Table_Correlations_Create(objPivotTable As Object,
objOutputDoc As Object, lngIndex As Long)

' Will remove the statistical significance testing and sample size from
correlations output.
Dim objPivotManager As ISpssPivotMgr
Dim objRow As ISpssDimension
Dim intCount As Integer
Set objPivotManager = objPivotTable.PivotManager

' Search for the row dimension named "Statistics" and pivot it to the
first layer dimension:
intCount = objPivotManager.NumRowDimensions
For I = 0 To intCount -1
        Set objRow = objPivotManager.RowDimension(I)
        If objRow.DimensionName  = "Statistics" Then
                objRow.MoveToLayer(0)
                Exit For
        End If
Next

End Sub

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
[hidden email]
Sent: Wednesday, January 10, 2007 10:03 AM
To: [hidden email]
Subject: 2 Queries in 1

Hello Members,

Hopefully 2 quick questions.

First, I want to clean my correlation output table to show only the
correlation coefficients, and for only one side of the matrix.  Is this
possible?  I do not want to have to export the data and manually clean
it.

Second, is perceptual mapping possible, and if so, is it only available
the Categories add-on?  I am new to this concept and am trying to figure
out new and exciting ways to present my analyses.

Any insight will be greatly appreciated,

~ Brock
Reply | Threaded
Open this post in threaded view
|

Re: Displaying Only Correlations

Brock-15
Thanks for getting back to me.  I am extremely new to the concept of using
scripts, but am quite familiar with VBA, as I have used it to automate
results between the Office Products.  That said, I have zero clue as to
where to start with Scripting.  I believe there is an 'autoscript' with
this name already, so where do I include this code that you gave me?  Do I
simply paste it into the pre-existing autoscript?  Do I create a new
script?
Again, I am new so do not hesitate to talk to me like I am 4 years old
because I will not be offended.  The SAX language appears to be slightly
different (scripts read the comments and use it as a description, etc.),
so any jumpstart you can give would be great.

Thanks again,

~ Brock