OMS to export tables AND graphs

[Luca Meyer-3]

Hi,

Apologizes if this is a question that has already been answered - I could not find it in the archives, but I was wondering if there is anyway to use OMS (or some other procedure) to simultaneously export both custom tables AND graphs from the output into PDF/RTF. So far I see that OMS will select only one type of output at the time, but what about if I have a set of tables and graphs next to each other, how can I export that?

Thanks,
Luca

Luca Meyer
www.lucameyer.com
PASW Statistics v. 18.0.2 (2-apr-2010)
R version 2.9.2 (2009-08-24)
Mac OS X 10.6.3 (10D573) - kernel Darwin 10.3.0

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

OMS can select any number of different output types at the same time.  Use something like
OMS SELECT TABLES CHARTS ...

HTH,

Jon Peck
SPSS, an IBM Company
[hidden email]
312-651-3435

From:	Luca Meyer <[hidden email]>
To:	[hidden email]
Date:	06/11/2010 07:50 AM
Subject:	[SPSSX-L] OMS to export tables AND graphs
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

Hi,

Apologizes if this is a question that has already been answered - I could not find it in the archives, but I was wondering if there is anyway to use OMS (or some other procedure) to simultaneously export both custom tables AND graphs from the output into PDF/RTF. So far I see that OMS will select only one type of output at the time, but what about if I have a set of tables and graphs next to each other, how can I export that?

Thanks,
Luca

Luca Meyer
www.lucameyer.com
PASW Statistics v. 18.0.2 (2-apr-2010)
R version 2.9.2 (2009-08-24)
Mac OS X 10.6.3 (10D573) - kernel Darwin 10.3.0

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

[Luca Meyer-3]

Hi Jon,

Thanks for the reply. Are there limitations in the export of tables and graphs to PDF/DOC formats?

Indeed when I run the following - T is a file handle to temp directory on my computer - everything works fine:

OMS SELECT TABLES CHARTS

/IF SUBTYPES=['Custom Table' 'Ggraph']

/DESTINATION FORMAT=HTML

OUTFILE='T/temp.html'. 

GGRAPH

  /GRAPHDATASET NAME="graphdataset" VARIABLES=inccat COUNT()[name="COUNT"] MISSING=LISTWISE 

    REPORTMISSING=NO

  /GRAPHSPEC SOURCE=INLINE.

BEGIN GPL

  SOURCE: s=userSource(id("graphdataset"))

  DATA: inccat=col(source(s), name("inccat"), unit.category())

  DATA: COUNT=col(source(s), name("COUNT"))

  GUIDE: axis(dim(1), label("Income category in thousands"))

  GUIDE: axis(dim(2), label("Frequenza"))

  SCALE: cat(dim(1), include("1.00", "2.00", "3.00", "4.00"))

  SCALE: linear(dim(2), include(0))

  ELEMENT: interval(position(inccat*COUNT), shape.interior(shape.square))

END GPL.

CTABLES

  /VLABELS VARIABLES=inccat DISPLAY=LABEL

  /TABLE inccat [COUNT F40.0]

  /CATEGORIES VARIABLES=inccat ORDER=A KEY=VALUE EMPTY=INCLUDE.

OMSEND.

But when I run what follows I get a correct PASW output but the pdf file has only two titles without table and chart:

OMS SELECT TABLES CHARTS

/IF SUBTYPES=['Custom Table' 'Ggraph']

/DESTINATION FORMAT=PDF

OUTFILE='T/temp.pdf'. 

GGRAPH

  /GRAPHDATASET NAME="graphdataset" VARIABLES=inccat COUNT()[name="COUNT"] MISSING=LISTWISE 

    REPORTMISSING=NO

  /GRAPHSPEC SOURCE=INLINE.

BEGIN GPL

  SOURCE: s=userSource(id("graphdataset"))

  DATA: inccat=col(source(s), name("inccat"), unit.category())

  DATA: COUNT=col(source(s), name("COUNT"))

  GUIDE: axis(dim(1), label("Income category in thousands"))

  GUIDE: axis(dim(2), label("Frequenza"))

  SCALE: cat(dim(1), include("1.00", "2.00", "3.00", "4.00"))

  SCALE: linear(dim(2), include(0))

  ELEMENT: interval(position(inccat*COUNT), shape.interior(shape.square))

END GPL.

CTABLES

  /VLABELS VARIABLES=inccat DISPLAY=LABEL

  /TABLE inccat [COUNT F40.0]

  /CATEGORIES VARIABLES=inccat ORDER=A KEY=VALUE EMPTY=INCLUDE.

OMSEND.

Finally, if I run the following I get a DOC file with the table but no chart:

OMS SELECT TABLES CHARTS

/IF SUBTYPES=['Custom Table' 'Ggraph']

/DESTINATION FORMAT=DOC

OUTFILE='T/temp.doc'. 

GGRAPH

  /GRAPHDATASET NAME="graphdataset" VARIABLES=inccat COUNT()[name="COUNT"] MISSING=LISTWISE 

    REPORTMISSING=NO

  /GRAPHSPEC SOURCE=INLINE.

BEGIN GPL

  SOURCE: s=userSource(id("graphdataset"))

  DATA: inccat=col(source(s), name("inccat"), unit.category())

  DATA: COUNT=col(source(s), name("COUNT"))

  GUIDE: axis(dim(1), label("Income category in thousands"))

  GUIDE: axis(dim(2), label("Frequenza"))

  SCALE: cat(dim(1), include("1.00", "2.00", "3.00", "4.00"))

  SCALE: linear(dim(2), include(0))

  ELEMENT: interval(position(inccat*COUNT), shape.interior(shape.square))

END GPL.

CTABLES

  /VLABELS VARIABLES=inccat DISPLAY=LABEL

  /TABLE inccat [COUNT F40.0]

  /CATEGORIES VARIABLES=inccat ORDER=A KEY=VALUE EMPTY=INCLUDE.

OMSEND.

Am I doing something wrong?

Cheers,

Luca

Il giorno 11/giu/2010, alle ore 16.08, Jon K Peck ha scritto:

OMS can select any number of different output types at the same time.  Use something like
OMS SELECT TABLES CHARTS ...

HTH,

Jon Peck
SPSS, an IBM Company
[hidden email]
312-651-3435

From:	Luca Meyer <[hidden email]>
To:	[hidden email]
Date:	06/11/2010 07:50 AM
Subject:	[SPSSX-L] OMS to export tables AND graphs
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

Hi,

Apologizes if this is a question that has already been answered - I could not find it in the archives, but I was wondering if there is anyway to use OMS (or some other procedure) to simultaneously export both custom tables AND graphs from the output into PDF/RTF. So far I see that OMS will select only one type of output at the time, but what about if I have a set of tables and graphs next to each other, how can I export that?

Thanks,
Luca

Luca Meyer
<a href="x-msg://137/www.lucameyer.com">www.lucameyer.com
PASW Statistics v. 18.0.2 (2-apr-2010)
R version 2.9.2 (2009-08-24)
Mac OS X 10.6.3 (10D573) - kernel Darwin 10.3.0

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

Luca Meyer
www.lucameyer.com
PASW Statistics v. 18.0.2 (2-apr-2010)

R version 2.9.2 (2009-08-24)
Mac OS X 10.6.3 (10D573) - kernel Darwin 10.3.0