Exporting all SPOs in given folder to Excel

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Exporting all SPOs in given folder to Excel

Jignesh Sutar
...not quite straight forward as the subject title suggests.

Each SPO contains the output of a forward stepwise logistic regression.
Each, is also titled (TITLE command) by the dependent variable.

I would like to export only the Title and the 'Variables in the Equation'
pivot tables, ignoring everything else. Note there are also 2 'Variables in
the Equation' tables, one for block zero (i.e. the constant only) and the
second for the stepwise procedure.

Would it also be possible to export only the final step from the Variables
in the Equation pivot table? This isn't essential but it could be a added
benefit if it can be implemented into some script/python program.

If anyone has anything close to carry out the steps above, that would be
excellent. And your help would be much appreciated. I don't fancy manually
copying and pasting over 80 SPOs! Plus it would be good to have something
like this developed if there was a need for it in the future.

Many thanks
Jignesh

=====================
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