Prev: PDF Reports from Stored Processes
Next: LOCF (Last Obs Carried Forward) Help, Please
From: Fernández Rodríguez, on 11 Nov 2009 11:20
Have you taken a look at Results formats inside options --> Results --> Results General
instead of Stored Process result formats?

Daniel


-----Mensaje original-----
De: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] En nombre de Joe Matise
Enviado el: mi�rcoles, 11 de noviembre de 2009 17:12
Para: SAS-L(a)LISTSERV.UGA.EDU
Asunto: Re: PDF Reports from Stored Processes

I'd double-check the location of your options statement, then. I've several
times had the problem that I put it after the ODS PDF statement, or
otherwise in a position where it didn't take effect correctly, even though I
know well it needs to go first.

Otherwise, it's probably something specific to SPs and I'll be of no help
there whatsoever, but others will hopefully be :)

-Joe

On Wed, Nov 11, 2009 at 10:08 AM, O'Connell, Martin <MOConnell(a)geico.com>wrote:

> Joe- That I've done. The Stored Process version of the code actually
> runs in its own workspace server environment that is initiated when the SP
> is fired. So a new environment is created that has no linkage to the EP
> environment that spawns it (so environmental cleanup not necessary). It
> seems like the workspace server environmental settings are overshadowing any
> environmental options I try to override.
>
>
>
> Thanks
>
>
> ------------------------------
>
> *From:* Joe Matise [mailto:snoopy369(a)gmail.com]
> *Sent:* Wednesday, November 11, 2009 11:01 AM
> *To:* O'Connell, Martin
> *Cc:* SAS-L(a)listserv.uga.edu
> *Subject:* Re: PDF Reports from Stored Processes
>
>
>
> Don't know a thing about EG or SPs as implemented in SAS, but perhaps you
> need to set the options inside your SP.
>
> Assuming the code goes something like:
>
> <code>
> ... insert option here ...
> ods pdf file=<file>;
> <code>
> ods pdf close;
>
> Then you may simply need to put:
> option orientation=landscape;
> where I specified above [prior to the ODS PDF statement]. Then return it
> to orientation=portrait afterwards [it's always polite to return options to
> their original value after code runs, to avoid problems with other programs
> that assume the default option setting!].
>
> -Joe
>
> 2009/11/11 O'Connell, Martin <MOConnell(a)geico.com>
>
> Yes I got past that I had to change when report appeared as html and not
> pdf. But the options that I set when I developed under code node are not
> getting picked up when running as SP.
>
> Thanks
>
>
> -----Original Message-----
> From: Fern�ndez Rodr�guez, Dani [mailto:DFernandez(a)CST.CAT]
> Sent: Wednesday, November 11, 2009 10:29 AM
> To: O'Connell, Martin ; SAS-L(a)LISTSERV.UGA.EDU
> Subject: RE: PDF Reports from Stored Processes
>
> Hi Martin,
> I am not very sure what you refer... anyway,
> Have you set your Stored Process output to PDF in EG?
> Tools--> options--> results (Stored process)--> PDF
>
> Daniel
> Barcelona
>
>
> -----Mensaje original-----
> De: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] En nombre de
> O'Connell, Martin
> Enviado el: mi�rcoles, 11 de noviembre de 2009 15:49
> Para: SAS-L(a)LISTSERV.UGA.EDU
> Asunto: PDF Reports from Stored Processes
>
> Hello all,
>
>
>
> I have a report writer that builds pdf reports that has worked fine in
> EG code node. Nothing terribly fancy, just put statements building the
> report. But when I wrap a simple Stored Process around it the SP output
> seems to ignore my options, particularly Landscape as report is coming
> out Portrait. Is there something I need to be aware of to set these
> options in SP?
>
>
>
> As always, thanks for any help.
>
>
>
> Martin
>
> ====================
> This email/fax message is for the sole use of the intended
> recipient(s) and may contain confidential and privileged information.
> Any unauthorized review, use, disclosure or distribution of this
> email/fax is prohibited. If you are not the intended recipient, please
> destroy all paper and electronic copies of the original message.
> ====================
> This email/fax message is for the sole use of the intended
> recipient(s) and may contain confidential and privileged information.
> Any unauthorized review, use, disclosure or distribution of this
> email/fax is prohibited. If you are not the intended recipient, please
> destroy all paper and electronic copies of the original message.
>
>
>
> ====================
> This email/fax message is for the sole use of the intended
> recipient(s) and may contain confidential and privileged information.
> Any unauthorized review, use, disclosure or distribution of this
> email/fax is prohibited. If you are not the intended recipient, please
> destroy all paper and electronic copies of the original message.
>
>
From: Savian on 11 Nov 2009 20:57
On Nov 11, 9:20 am, Fernández Rodríguez, Dani wrote:
> Have you taken a look at Results formats inside options  --> Results --> Results General
> instead of Stored Process  result formats?
>
> Daniel
>
> -----Mensaje original-----
> De: SAS(r) Discussion [mailto:SA...(a)LISTSERV.UGA.EDU] En nombre de Joe Matise
> Enviado el: miércoles, 11 de noviembre de 2009 17:12
> Para: SA...(a)LISTSERV.UGA.EDU
> Asunto: Re: PDF Reports from Stored Processes
>
> I'd double-check the location of your options statement, then.  I've several
> times had the problem that I put it after the ODS PDF statement, or
> otherwise in a position where it didn't take effect correctly, even though I
> know well it needs to go first.
>
> Otherwise, it's probably something specific to SPs and I'll be of no help
> there whatsoever, but others will hopefully be :)
>
> -Joe
>
> On Wed, Nov 11, 2009 at 10:08 AM, O'Connell, Martin <MOConn...(a)geico.com>wrote:
>
>
>
> >  Joe- That I've done.  The Stored Process version of the code actually
> > runs in its own workspace server environment that is initiated when the SP
> > is fired.  So a new environment is created that has no linkage to the EP
> > environment that spawns it (so environmental cleanup not necessary).  It
> > seems like the workspace server environmental settings are overshadowing any
> > environmental options I try to override.
>
> > Thanks
>
> >  ------------------------------
>
> > *From:* Joe Matise [mailto:snoopy...(a)gmail.com]
> > *Sent:* Wednesday, November 11, 2009 11:01 AM
> > *To:* O'Connell, Martin
> > *Cc:* SA...(a)listserv.uga.edu
> > *Subject:* Re: PDF Reports from Stored Processes
>
> > Don't know a thing about EG or SPs as implemented in SAS, but perhaps you
> > need to set the options inside your SP.
>
> > Assuming the code goes something like:
>
> > <code>
> > ... insert option here ...
> > ods pdf file=<file>;
> > <code>
> > ods pdf close;
>
> > Then you may simply need to put:
> > option orientation=landscape;
> > where I specified above [prior to the ODS PDF statement].  Then return it
> > to orientation=portrait afterwards [it's always polite to return options to
> > their original value after code runs, to avoid problems with other programs
> > that assume the default option setting!].
>
> > -Joe
>
> > 2009/11/11 O'Connell, Martin <MOConn...(a)geico.com>
>
> > Yes I got past that I had to change when report appeared as html and not
> > pdf.  But the options that I set when I developed under code node are not
> > getting picked up when running as SP.
>
> > Thanks
>
> > -----Original Message-----
> > From: Fernández Rodríguez, Dani [mailto:DFernan...(a)CST.CAT]
> > Sent: Wednesday, November 11, 2009 10:29 AM
> > To: O'Connell, Martin ; SA...(a)LISTSERV.UGA.EDU
> > Subject: RE: PDF Reports from Stored Processes
>
> > Hi Martin,
> > I am not very sure what you refer... anyway,
> > Have you set your Stored Process output to PDF in EG?
> > Tools--> options--> results (Stored process)--> PDF
>
> > Daniel
> > Barcelona
>
> > -----Mensaje original-----
> > De: SAS(r) Discussion [mailto:SA...(a)LISTSERV.UGA.EDU] En nombre de
> > O'Connell, Martin
> > Enviado el: miércoles, 11 de noviembre de 2009 15:49
> > Para: SA...(a)LISTSERV.UGA.EDU
> > Asunto: PDF Reports from Stored Processes
>
> > Hello all,
>
> > I have a report writer that builds pdf reports that has worked fine in
> > EG code node.  Nothing terribly fancy, just put statements building the
> > report.  But when I wrap a simple Stored Process around it the SP output
> > seems to ignore my options, particularly Landscape as report is coming
> > out Portrait.  Is there something I need to be aware of to set these
> > options in SP?
>
> > As always, thanks for any help.
>
> > Martin
>
> > ====================
> > This email/fax message is for the sole use of the intended
> > recipient(s) and may contain confidential and privileged information.
> > Any unauthorized review, use, disclosure or distribution of this
> > email/fax is prohibited. If you are not the intended recipient, please
> > destroy all paper and electronic copies of the original message.
> > ====================
> > This email/fax message is for the sole use of the intended
> > recipient(s) and may contain confidential and privileged information.
> > Any unauthorized review, use, disclosure or distribution of this
> > email/fax is prohibited. If you are not the intended recipient, please
> > destroy all paper and electronic copies of the original message.
>
> > ====================
> > This email/fax message is for the sole use of the intended
> > recipient(s) and may contain confidential and privileged information.
> > Any unauthorized review, use, disclosure or distribution of this
> > email/fax is prohibited. If you are not the intended recipient, please
> > destroy all paper and electronic copies of the original message.- Hide quoted text -
>
> - Show quoted text -

I will forward this thread to Don Henderson to see if he will comment
since SPs are his specialty.

We will be presenting delivering Excel and PDF via SPs at SGF. That
doesn't help you now so I will ask Don if he wants to weigh in.

Alan
http://www.savian.net

From: "Martin O'Connell" on 18 Nov 2009 15:14
All, Just in case anyone goes searching for this later here is what I had
to do thanks to the folks in Cary:

1) Open the Stored Process and define a hidden prompt named

_PRINTOPTIONS

2) Check the "hide from user" checkbox.
3)Set the default value to "orientation=landscape" (without quotes).

Seems a bit kludgy...but it works so all is well now.

Martin

On Wed, 11 Nov 2009 09:49:00 -0500, O'Connell, Martin <MOConnell(a)GEICO.COM>
wrote:

>Hello all,
>
>
>
>I have a report writer that builds pdf reports that has worked fine in
>EG code node. Nothing terribly fancy, just put statements building the
>report. But when I wrap a simple Stored Process around it the SP output
>seems to ignore my options, particularly Landscape as report is coming
>out Portrait. Is there something I need to be aware of to set these
>options in SP?
>
>
>
>As always, thanks for any help.
>
>
>
>Martin
>
>====================
>This email/fax message is for the sole use of the intended
>recipient(s) and may contain confidential and privileged information.
>Any unauthorized review, use, disclosure or distribution of this
>email/fax is prohibited. If you are not the intended recipient, please
>destroy all paper and electronic copies of the original message.
First  |  Prev  | 
Pages: 1 2
Prev: PDF Reports from Stored Processes
Next: LOCF (Last Obs Carried Forward) Help, Please