Syntax to Export .spo file to .doc file

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

Syntax to Export .spo file to .doc file

Michael Mitchell-3
Greetings

  I am using SPSS 15 and am searching for a way to, via syntax, do this
process...

File
  Open
    Output
      test.spo

File
  Export
    (select word document as destination)
    (name the file test.doc)
     OK

I need to do this for a large number of files and am tiring of doing so via
the point and click menus.

I would be most grateful for help on this!

Many thanks,

Michael Mitchell

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: Syntax to Export .spo file to .doc file

Peck, Jon
SPSS 15 has new commands, OUTPUT OPEN/SAVE/CLOSE etc.  It does not have an export command.  It is very easy to do this with programmability, however, if you use some of the supplemental modules from SPSS Developer Central (www.spss.com/devcentral).  You could also do this with a SaxBasic script.

Here is a Python programmability example.  It opens every spo file in the directory c:/temp/parts and exports it as a Word file.  Other export formats can also be used, and there are options similar to what you see in the Export dialog box.

begin program.
#export all spo files in a specified directory as pdf
import spss, viewer, glob

spolist = glob.glob("c:/temp/parts/*.spo")
app = viewer.spssapp()
exportcount = 0
for f in spolist:
    spss.Submit("OUTPUT OPEN FILE='%s'" % f)
    app.ExportDesignatedOutput(f.rstrip(".spo"), format="Word")
    exportcount+= 1
    spss.Submit("OUTPUT CLOSE NAME=*")

print "Number of files exported:", exportcount
end program.

The viewer module requires some other (free) installs detailed in the information in that module

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Michael Mitchell
Sent: Saturday, March 08, 2008 1:12 PM
To: [hidden email]
Subject: [SPSSX-L] Syntax to Export .spo file to .doc file

Greetings

  I am using SPSS 15 and am searching for a way to, via syntax, do this
process...

File
  Open
    Output
      test.spo

File
  Export
    (select word document as destination)
    (name the file test.doc)
     OK

I need to do this for a large number of files and am tiring of doing so via
the point and click menus.

I would be most grateful for help on this!

Many thanks,

Michael Mitchell

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

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