Export output with syntax

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

Export output with syntax

Drazen Urch
Hello,

I wonder if anyone could help me with some tricky syntax

I'm using SPSS 11,5.

I would like to be able to export output to Word using syntax, I need this
in order to be able to dynamically assign names to exported files. To
clarify I'm using a macro to run a couple of tables (11) through a list of
about 3000 cases, and I need to export each of those table sets to Word
individually. I tried to get this accomplished via scripts but I couldn't
figure out how to pass dynamic names to the said script. Below is the code
I'm working with (minus all the tables):

*Begin macro.
DEFINE !doit().
!DO !ID=6000 !TO 9500.
COMPUTE filter_=(id=!ID).
FILTER BY filter_.
*Begin computing
*Basic Tables.
TABLES
  /FORMAT BLANK MISSING('.')
  /TABLES id_ime > (kolegij)
  BY (STATISTICS) /TITLE =!QUOTE(!CONCAT(!ID))/CAPTION  ''.
FILTER OFF.
!DOEND
!ENDDEFINE.

*Call macro.
!doit.

The outcome of this (after export) should be 6000.doc, 6001.doc ......
9499.doc, 9500.doc

Any and all help you can provide would be priceless! Thanks in advance !


Drazen Urch

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