Split File and OMS Output

[Craig Johnson]

I'm running some descriptives and am outputting the results using OMS to a spss data file.  I have ~157 different tables being output.  Is it possible to replace the table number with the TITLE of the individual table so I know what split was used?  Or maybe there is a simple way to recode the table number?  Any insight into automating the mapping back to descriptions of what those tables are would be helpful.  

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

[Maguin, Eugene]

This may not be useful to you but since you mention ‘split file’ it sounds like you might be doing this:

 

Split files by xx.

Descriptives y1.

 

If so, you might find the means command to be a good substitute.

 

Even if you were doing descriptives on y1 to y10 you might find means to be a better command that split files + descriptives.

 

Gene Maguin

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Craig J
Sent: Wednesday, March 25, 2015 1:16 PM
To: [hidden email]
Subject: Split File and OMS Output

 

I'm running some descriptives and am outputting the results using OMS to a spss data file.  I have ~157 different tables being output.  Is it possible to replace the table number with the TITLE of the individual table so I know what split was used?  Or maybe there is a simple way to recode the table number?  Any insight into automating the mapping back to descriptions of what those tables are would be helpful.  

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

[Andy W]

Are you perhaps using SPLIT FILE SEPARATE? Because if you use SPLIT FILE LAYERED it does return a variable associating the specific split in the output table. Example below - in the second table Var1 holds the split file fields.

**************************************************.
SET SEED 10.
INPUT PROGRAM.
LOOP #j = 1 TO 10.
  LOOP #i = 1 TO 10.
    COMPUTE Cat = #j.
    COMPUTE X = RV.NORMAL(#j,#j).
    END CASE.
  END LOOP.
END LOOP.
END FILE.
END INPUT PROGRAM.
DATASET NAME TEST.
FORMATS Cat (F2.0).
VALUE LABELS Cat 1 'Test 1' 2 'Test 2' 3 'BLLLLLL'.

*This returns seperate tables, so there is no identfier.
DATASET DECLARE DescTab.
OMS
  /SELECT TABLES
  /IF SUBTYPES = 'Descriptive Statistics'
  /DESTINATION FORMAT=SAV OUTFILE='DescTab'.
SPLIT FILE SEPARATE BY Cat.
DESCRIPTIVES X.
SPLIT FILE OFF.
OMSEND.

*This returns a variable in the table associating it to the split.
DATASET DECLARE DescTab2.
OMS
  /SELECT TABLES
  /IF SUBTYPES = 'Descriptive Statistics'
  /DESTINATION FORMAT=SAV OUTFILE='DescTab2'.
*The default is LAYERED.
SPLIT FILE BY Cat.
DESCRIPTIVES X.
SPLIT FILE OFF.
OMSEND.
**************************************************.

[David Marso]

Which statistics are you extracting that can't be calculated in AGGREGATE?

As Andy stated, SPLIT FILES LAYERED might be a fall back.
----

Craig Johnson wrote

I'm running some descriptives and am outputting the results using OMS to a
spss data file.  I have ~157 different tables being output.  Is it possible
to replace the table number with the TITLE of the individual table so I
know what split was used?  Or maybe there is a simple way to recode the
table number?  Any insight into automating the mapping back to descriptions
of what those tables are would be helpful.

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