Date: Tue, 1 Jul 2008 16:58:36 -0400
Reply-To: Don Henderson <donaldjhenderson@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Don Henderson <donaldjhenderson@HOTMAIL.COM>
Subject: Re: Data entry with STP
In-Reply-To: <32f2e5fc-68f2-402e-bf49-cc2ae9f3c3df@a70g2000hsh.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"
Xavier,
Not sure I agree with your summary. Stored Processes can produce any type of
output - and you are correct that the type of content to be generated
depends on the client. That is the reason that SAS provides the STPBEGIN and
STPEND macros for use in your Stored Processes. Those macro's generate the
"appropriate" content based on the client (e.g., for Enterprise Guide, Work,
Excel, a browser, etc.). By using these macros the Stored Process developer
need not worry about what the client is for Stored Processes than can be
invoked from multiple client types.
In Jan's case we know he is generating HTML and that the client is the
browser. Further the other clients don't have a analog to the concept of
generating forms/links that can be clicked on to make a round trip to the
browser. His code is creating all of the HTML, including the HEAD section.
By using the STPBEGIN macro, ODS is generating the HEAD section which
appears to be over-riding what he has put in his HEAD section.
Hope this clarifies what I was trying to say.
-donh
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of xav
> Sent: Tuesday, July 01, 2008 9:18 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Data entry with STP
>
> You should read that documentation :
> http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/inet
> 2stp.html
> (or http://tinyurl.com/69do59)
>
> Stored Process are not providing HTML, it provides XML (Tagset
> SASREPORT11 for example)
>
> The reason is that the client controls the behaviour of the
> Stored Process :
>
> For a same STP inside Word it's RTF, inside Excel it can be
> CSV or formatted etc..
>
> Xavier
>
> > Jan,
> >
> > Actually I am surprised this is working at all. The stpbegin/end
> > macros typically cause a data step that writes to _webout
> to fail with
> > a "file contention" issue.
> >
> > Regardless, if you are generating all the HTML, including the HEAD
> > section in your data step, remove the stpbegin/end macro calls. The
> > extra HTML you are seeing is being produced by ODS because
> of those macros.
> >
> > HTH,
> > -donh
> >
> > > -----Original Message-----
> > > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU]
> On Behalf Of
> > > jshansen
> > > Sent: Tuesday, July 01, 2008 3:37 AM
> > > To: SA...@LISTSERV.UGA.EDU
> > > Subject: Re: Data entry with STP
> >
> > > On 30 Jun., 18:00, donaldjhender...@HOTMAIL.COM (Don
> Henderson) wrote:
> > > > Jan,
> >
> > > > I typically use the URL portlet to add STPs to the portal
> > > and have not
> > > > seen this issue.
> >
> > > > Can you clarify how you are called your STPs? That might be the
> > > > reason. I think some of the portlets may strip off the
> head section.
> >
> > > > Regards,
> > > > donh
> >
> > > > > -----Original Message-----
> > > > > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU]
> > > On Behalf Of
> > > > > jshansen
> > > > > Sent: Monday, June 30, 2008 5:06 AM
> > > > > To: SA...@LISTSERV.UGA.EDU
> > > > > Subject: Data entry with STP
> >
> > > > > I have for years been creating data-entry systems using
> > > SAS IntrNet,
> > > > > and HTML-tags like <TEXTAREA> <INPUT> a.o.
> > > > > No problems :-)
> >
> > > > > I also works with BI & STP's, BUT ....
> >
> > > > > I can not control the "start html-tags" like <body lang=DA
> > > > > bgcolor="#E8EEB9">
> >
> > > > > I makes my IE, not passing our national danish
> characters to SAS.
> >
> > > > > Is there a way in BI-portal to have total control over
> > > the HTML sent
> > > > > to _webout with a STP ?
> >
> > > > > Jan Selchau-Hansen- Skjul tekst i anførselstegn -
> >
> > > > - Vis tekst i anførselstegn -
> >
> > > Don,
> >
> > > The STP is called from another STP.
> > > The calling STP is generating HTML with Proc Report and a "define
> > > url". Like this:
> >
> > > if origin_system='SAS' then do;
> > > pgm='?_program=/BIP%20Tree/Fonds/STP/failed_late_sas&id=' !!
> > > trim(left(put(id,7.)));
> > > call define(_col_,'URL',pgm);
> > > end;
> >
> > > The URL looks like this:
> > >http://atp-13pdmdapp03:9080/SASStoredProcess/do?_program=/BIP%
> > > 20Tree/Fonds/STP/failed_late_sas&id=131389
> >
> > > The STP is defined in the Management Console with
> "Streaming Output".
> >
> > > My STP looks like this:
> > > *ProcessBody;
> > > %stpbegin;
> > > ods html close;
> > > data _null_;
> > > set failed;
> > > file _webout;
> > > put '<html><head>'
> > > / '</head>'
> > > / '<body lang=DA bgcolor="#E8EEB9">'
> > > / '<table border="0" width="100%"><tr><td align="left">'
> > > / '<FORM ACTION="/SASStoredProcess/do" method="post"
> name="f1">'
> > > / '<TABLE BORDER="0" CELLPADDING="0"><TR><td class="l
> Data">Ret
> > > evt. </td></tr>'
> > > / '<INPUT TYPE="HIDDEN" NAME="_PROGRAM" VALUE="/BIP
> > > Tree/Fonds/STP/ failed_late_reason_save">'
> > > / '<INPUT TYPE="HIDDEN" NAME="reasonid" VALUE="'
> "&reasonid" '">'
> > > / '<tr><td><INPUT TYPE="submit" VALUE="Gem !"></td></tr>'
> > > / '<td><TEXTAREA name="reason" rows="10" cols="50">' reason '</
> > > TEXTAREA></td></tr>'
> > > / ' </table></body></html>';
> > > %stpend;
> >
> > > But the HTML generated to _webout looks like this:
> > > <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> > > <html> <head> <meta name="Generator"
> > > content="SAS Software, seewww.sas.com"
> > > sasversion="9.1">
> > > <meta http-equiv="Content-type" content="text/html"> <title>SAS
> > > Output</title> <style type="text/css">
> > > <!--
> > > .ContentTitle
> > > {
> > > font-family: Arial, Helvetica, sans-serif;
> > > font-size: small;
> > > font-weight: normal;
> > > font-style: italic;
> > > color: #002288;
> > > .....
> > > +2000 lines of generated HTML-code.
> > > + My 10 lines at the buttom.
> >
> > > Jan Selchau-Hansen
>
| 
