|
|
It would be hard to make an option such
as you describe general and efficient. The intended way to do something
like that is to use the companion extension command SPSSINC PROCESS FILES
for this.
PROCESS FILES iterates over a set of
files. It might be all the files in some directory or a wildcard
specification or a list of files produced by SPLIT DATASET.
It takes a syntax file that will be
applied in turn to each file. PROCESS files defines macros and file
handles for the inputs, so you would open each file using the file handle,
do transformations, run procedures, write new files or whatever.
From the syntax help ...
The block of syntax specified in SYNTAX
will be executed for each matching file.
It should include the appropriate command
to read the data file or other inputs.
File handles and macros are defined
to refer to the input file and various output
locations.
The file handles are as follows.
JOB_INPUTFILE: The input file
JOB_DATADIR: The input data directory
JOB_OUTPUTDATADIR: The specified output
data directory or <NONE>
JOB_VIEWERDIR: The specified Viewer
output directory or <NONE>
For a SAV file you could read the data
with the command
GET FILE="JOB_INPUTFILE".
Macros are defined with these same names
except starting with "!". Two
additional macros are defined.
!JOB_DATAFILEROOT: The name of the input
data file without its extension
!JOB_DATAFILEEXT: The extension of the
input data file
Macro text is quoted. Here is
an example of code that might be used in the
syntax file to export output to the
VIEWERDIR in Excel using the data file rootname.
define !out () !quote(!concat(!unquote(!eval(!job_viewerdir)),
"/", !unquote(!eval(!job_datafileroot)), ".xls"))
!enddefine.
output export /xls DOCUMENTFILE =!out.
The text !JOB or JOB is replaced by
the root name specified in MACRONAME.
Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: 720-342-5621
|
Locked
