Help with OMS

[Little, Jonathon]

Dear LISTERS,

RE: OMS COMMAND

I am having trouble with my output HTML file which insists on displaying
the name of the active dataset together with my table.  It shows the
active dataset exactly as set out below.

'Active Dataset'
\\Ntfrd43\Shared$\Health Data\Jonathons data.sav

I have tried setting EXCEPTIF SUBTYPES to not show the active data set
but I am unable to turn this off.  My syntax is shown below.  Any ideas?


OMS
 /SELECT ALL
  /EXCEPTIF SUBTYPES = ['NOTES' 'Active Dataset']
/DESTINATION FORMAT=HTML OUTFILE = !output + '\SR12-B.2.1 - Financial
Year  - ' + !financial_reporting_period + ' - Descriptives ' +
!Census_date + '.htm'
VIEWER =NO.

* General Tables.
TEMPORARY.
  VARIABLE LABELS Fin_year '' Month_FY''.
TABLES
  /FORMAT BLANK MISSING('.')
  /OBSERVATION= Mean Median Percentile25 Percentile50 Percentile75
ValidN
  /GBASE=CASES
  /TABLE=SR_Region > Fin_year > Month_FY   BY Mean + Median +
Percentile25 +
  Percentile50 + Percentile75 + ValidN
  /STATISTICS
  maximum( Mean( F7.2 ) '')
  maximum( Median( F7.2 ) '')
  maximum( Percentile25( F7.2 ) '')
  maximum( Percentile50( F7.2 ) '')
  maximum( Percentile75( F7.2 ) '')
  maximum( ValidN( F7.0 ) '')
 /TITLE  'SR12-B.2.1 - Financial Year  - ' + !financial_reporting_period
+ ' - Descriptives BY Region as at ' + !Census_date + '.'.

OMSEND.


Jonathon Little
WA Department of Health

[Marta Garcia-Granero]

Little, Jonathon escribió:

> I am having trouble with my output HTML file which insists on displaying
> the name of the active dataset together with my table.  It shows the
> active dataset exactly as set out below.
>
> 'Active Dataset'
> \\Ntfrd43\Shared$\Health Data\Jonathons data.sav
>
> I have tried setting EXCEPTIF SUBTYPES to not show the active data set
> but I am unable to turn this off.  My syntax is shown below.  Any ideas?
>

Hi Jonathon,

I got rid of the "active dataset" information in the output with this extra OMS command:

OMS /SELECT ALL
    /IF LABELS='Active Dataset'
    /DESTINATION VIEWER=NO.

Perhaps this will give you clues to modify your OMS commands.

HTH,
Marta

[Peck, Jon]

The SUBTYPES filter in the OMS command applies only to objects that are tables, since other object types do not have subtypes.  You can get rid of non-table objects selecting only tables in your OMS command.  For example,

oms select tables
/destination format=html outfile='c:/temp/stuff.htm'.
get file='c:/spss15/cars.sav'.
freq origin.
omsend.

produces html containing only the frequency table and the Notes table.

If you also do not want the notes table, you could write the following, because Notes IS a table subtype.

oms select tables
/exceptif subtypes="notes"
/destination format=html outfile='c:/temp/stuff.htm'.
get file='c:/spss15/cars.sav'.
freq origin.
omsend.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Little, Jonathon
Sent: Wednesday, September 26, 2007 1:34 AM
To: [hidden email]
Subject: [SPSSX-L] Help with OMS

Dear LISTERS,

RE: OMS COMMAND

I am having trouble with my output HTML file which insists on displaying
the name of the active dataset together with my table.  It shows the
active dataset exactly as set out below.

'Active Dataset'
\\Ntfrd43\Shared$\Health Data\Jonathons data.sav

I have tried setting EXCEPTIF SUBTYPES to not show the active data set
but I am unable to turn this off.  My syntax is shown below.  Any ideas?


OMS
 /SELECT ALL
  /EXCEPTIF SUBTYPES = ['NOTES' 'Active Dataset']
/DESTINATION FORMAT=HTML OUTFILE = !output + '\SR12-B.2.1 - Financial
Year  - ' + !financial_reporting_period + ' - Descriptives ' +
!Census_date + '.htm'
VIEWER =NO.

* General Tables.
TEMPORARY.
  VARIABLE LABELS Fin_year '' Month_FY''.
TABLES
  /FORMAT BLANK MISSING('.')
  /OBSERVATION= Mean Median Percentile25 Percentile50 Percentile75
ValidN
  /GBASE=CASES
  /TABLE=SR_Region > Fin_year > Month_FY   BY Mean + Median +
Percentile25 +
  Percentile50 + Percentile75 + ValidN
  /STATISTICS
  maximum( Mean( F7.2 ) '')
  maximum( Median( F7.2 ) '')
  maximum( Percentile25( F7.2 ) '')
  maximum( Percentile50( F7.2 ) '')
  maximum( Percentile75( F7.2 ) '')
  maximum( ValidN( F7.0 ) '')
 /TITLE  'SR12-B.2.1 - Financial Year  - ' + !financial_reporting_period
+ ' - Descriptives BY Region as at ' + !Census_date + '.'.

OMSEND.


Jonathon Little
WA Department of Health