Problem capturing warnings using OMS

[Tim Graettinger]

Hi,

I'm trying to capture the warnings generated when running FREQUENCIES on a
collection of data elements.  OMS is my preferred method so I can capture
the warnings in a dataset for reporting, analysis, etc.  When I run the code
below, all I get is an empty dataset, although the output window and the
syntax window both report warnings (e.g., "No valid cases remain for
FLAG_ProgramCode.  A bar chart or histogram cannot be produced.").  I run a
completely analogous bit of syntax to capture the "Notes" table from the
FREQS run, so I'm baffled why this fails.  Thoughts and help are much
appreciated.
-Tim

--- Syntax below ------------------------------------
* OMS.
DATASET DECLARE  frequencies_warnings.
OMS
  /SELECT TABLES
  /IF COMMANDS=['Frequencies'] SUBTYPES=['Warnings']
  /DESTINATION FORMAT=SAV NUMBERED=TableNumber_
   OUTFILE='frequencies_warnings'
  /TAG='frequencies_warnings'.

* Run freqs on the numeric/nominal fields.
FREQUENCIES VARIABLES=
AsOfQuarter
FLAG_ProgramCode
FLAG_TermsInFullAY
FLAG_Sequence
FLAG_TransferCredits
FLAG_GPA
FLAG_StaffordEligible
FLAG_PLUSDenial
FLAG_EmployerPack
FLAG_RBS
  /STATISTICS=STDDEV MINIMUM MAXIMUM MEAN MEDIAN
  /BARCHART FREQ
  /FORMAT=LIMIT(64)
  /ORDER=ANALYSIS.

* OMSEND.
OMSEND TAG=['frequencies_warnings'].

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

[Rick Oliver-3]

WARNINGS is a separate object type:

SELECT TABLES WARNINGS...etc.

Rick Oliver
Senior Information Developer
Business Analytics (SPSS)
E-mail: [hidden email]



From:        Tim Graettinger <[hidden email]>
To:        [hidden email]
Date:        12/01/2011 01:29 PM
Subject:        Problem capturing warnings using OMS
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hi,

I'm trying to capture the warnings generated when running FREQUENCIES on a
collection of data elements.  OMS is my preferred method so I can capture
the warnings in a dataset for reporting, analysis, etc.  When I run the code
below, all I get is an empty dataset, although the output window and the
syntax window both report warnings (e.g., "No valid cases remain for
FLAG_ProgramCode.  A bar chart or histogram cannot be produced.").  I run a
completely analogous bit of syntax to capture the "Notes" table from the
FREQS run, so I'm baffled why this fails.  Thoughts and help are much
appreciated.
-Tim

--- Syntax below ------------------------------------
* OMS.
DATASET DECLARE  frequencies_warnings.
OMS
 /SELECT TABLES
 /IF COMMANDS=['Frequencies'] SUBTYPES=['Warnings']
 /DESTINATION FORMAT=SAV NUMBERED=TableNumber_
  OUTFILE='frequencies_warnings'
 /TAG='frequencies_warnings'.

* Run freqs on the numeric/nominal fields.
FREQUENCIES VARIABLES=
AsOfQuarter
FLAG_ProgramCode
FLAG_TermsInFullAY
FLAG_Sequence
FLAG_TransferCredits
FLAG_GPA
FLAG_StaffordEligible
FLAG_PLUSDenial
FLAG_EmployerPack
FLAG_RBS
 /STATISTICS=STDDEV MINIMUM MAXIMUM MEAN MEDIAN
 /BARCHART FREQ
 /FORMAT=LIMIT(64)
 /ORDER=ANALYSIS.

* OMSEND.
OMSEND TAG=['frequencies_warnings'].

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

[Tim Graettinger]

The code I posted was pasted thru the user interface (Utilities/OMS Control
Panel).  I selected Output Types=Tables, Command Identifiers=Frequencies,
and Table Subtypes for Selected Commands=Warnings.

Per Rick's suggestion, I did find Warnings under Output Types. So I used
that instead of my previous approach, and that was successful.  A minor
quibble is that I could only direct the output to a file (xml, text, etc.)
rather than to a dataset - but I can certainly work with the text file to
get what I need.  It's just a little less elegant than I was hoping for.

Thanks for getting me unstuck!
-Tim

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

[Jon K Peck]

Since warnings are text, not tabular output, they don't fit into the rectangular structure of a data file.  You can, though, write xml to the xmlworkspace and work with this via programmability.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: [phone]




From:        Tim Graettinger <[hidden email]>
To:        [hidden email]
Date:        12/02/2011 06:35 AM
Subject:        Re: [SPSSX-L] Problem capturing warnings using OMS
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

The code I posted was pasted thru the user interface (Utilities/OMS Control
Panel).  I selected Output Types=Tables, Command Identifiers=Frequencies,
and Table Subtypes for Selected Commands=Warnings.

Per Rick's suggestion, I did find Warnings under Output Types. So I used
that instead of my previous approach, and that was successful.  A minor
quibble is that I could only direct the output to a file (xml, text, etc.)
rather than to a dataset - but I can certainly work with the text file to
get what I need.  It's just a little less elegant than I was hoping for.

Thanks for getting me unstuck!
-Tim

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