SAX basic question

[Mike P-5]

I'm doing some TS modeling and want to automatically transpose the model
summary table that is produced.

I know I can do this by right clicking the table and bringing up the
autoscripts for the table.  But can't find / remember the command to
transpose.

Can anyone enlighten me please

Mike




Sub TSModel_Table_ModelStatistics_Create(objTable As Object,
objOutputDoc As Object, lngIndex As Long)
'Autoscript
'Trigger Event: ModelStatistics Table Creation after running TSModel
procedure.

End Sub

[Erik Langer Madsen]

Michael

I'm not completely sure whether I get your question right but as I
understand it you have an output in a table defined by various factors.
If this is the case then opening the table by
1 clicking it
2 followed by rightclicking
3 choosing pivoting trays
4 move the variables around in the small window from columns to rows to
layer might help you if your data are organised in a longitudinal format
Good luck
regards Erik

[Erik Langer Madsen]

Michael
Another solution could be to copy the table into excel and use its copy,
paste special, with a tick off in transpose data and then reinsert it into
word or where ever you might need it.

Regards
Erik

[Mike P-5]

Thanks Erik,

This is not quiet what I want, within SPSS there are autoscripts that
fire off when tables are created, (double click into a table and
right-click, you will see edit autoscript)

There is a function that will transpose the table each time the
procedure is run, thus eliminating the need to do this by hand each time

Cheers for your input anyway

Mike

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Erik Langer Madsen
Sent: 11 July 2007 13:11
To: [hidden email]
Subject: Re: SAX basic question

Michael
Another solution could be to copy the table into excel and use its copy,
paste special, with a tick off in transpose data and then reinsert it
into
word or where ever you might need it.

Regards
Erik

________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

[vlad simion]

Hi Michael,

is this what you are looking for:

"_spsspvt.ISpssPivotMgr.TransposeRowsWithColumns"

hth,

Vlad


On 7/11/07, Michael Pearmain <[hidden email]> wrote:

>
> Thanks Erik,
>
> This is not quiet what I want, within SPSS there are autoscripts that
> fire off when tables are created, (double click into a table and
> right-click, you will see edit autoscript)
>
> There is a function that will transpose the table each time the
> procedure is run, thus eliminating the need to do this by hand each time
>
> Cheers for your input anyway
>
> Mike
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Erik Langer Madsen
> Sent: 11 July 2007 13:11
> To: [hidden email]
> Subject: Re: SAX basic question
>
> Michael
> Another solution could be to copy the table into excel and use its copy,
> paste special, with a tick off in transpose data and then reinsert it
> into
> word or where ever you might need it.
>
> Regards
> Erik
>
> ________________________________________________________________________
> This e-mail has been scanned for all viruses by Star. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ________________________________________________________________________
>

--
Vlad Simion
Data Analyst
Tel:      [phone]