Hi:
A review of this example:
http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sesssamp.html
may help you figure out how to alter the programs. The programs WILL have to change. Depending on how you were creating the reports (FILE PRINT vs FILE PRINT ODS), you will probably have to change your FILE statement to FILE _WEBOUT. In addition, you might have to include your own HTML "wrapper" code.
Then, before your "main" body of the report (immediately after you insert the <BODY> tag into the file), you would then insert a <PRE> tag before the current set of PUT statements begin. Then, before you write the </BODY> tag, you would write the </PRE> tag.
Remember that you will be creating a stored process that can only be accessed via URL using the Stored Process Web Application because only some of the client applications in the BI platform can "receive" HTML results from the stored process server.
For example, if I create a SAS program called
SP_forum_SPWA.sas and save it in a stored process repository location named
STP_Orion and call the stored process registration name
SP_forum_SPWA , then I can build a URL to invoke the SP with the SPWA. But, first, here's the .SAS program:
[pre]
*ProcessBody;
data _null_;
set sashelp.class end=eof;
file _webout ;
if _n_ eq 1 then do;
put '<HTML>';
put '<BODY>';
put '<H1>Hello World</H1>';
put '<PRE>';
put @23 "Test Code";
put @10 "Output results from a DATA step using a FILE PRINT:";
put ' ';
put 'The main output: ';
end;
put @13 "Student Name = " @28 name @40 "Age = " age @50 "Height = " height 5.1;
if eof=1 then do;
put '<H1>The END</H1>';
put '</PRE>';
put '</BODY>';
put '</HTML>';
end;
run;
[/pre]
And then I register the SP using SAS Management Console -- the execution options were for this SP to run on the Stored Process Server and return Streaming results. (You
-could- register this SP with SAS Enterprise Guide, however, you have to be VERY, VERY careful to avoid ANY of the automatic macros %stpbegin/%stpend or any ODS statements getting added to this SP.
Next, I built an HTML page like this:
[pre]
<html>
<head>
<!-- SP_forum_SPWA.html -->
<title>Demonstration of Stored Process Web Application</title>
</head>
<body>
<p>First, start the SAS Services Application then start TomCat. <br>
Then click on the links below to test the use of stored processes with the
Stored Process Web Application</p>
<p><b>Note that in a production environment,
these servers will be automatically started.</b></p>
<ul>
<li>
<a target="new" href="http://localhost:9090/SASStoredProcess/do?
_program=/STP_Orion/SP_forum_SPWA">
Run the Class Report with DATA _NULL_ and _WEBOUT</a>
</li>
</ul>
</body>
</html>
[/pre]
I show a relative name as the location of the _PROGRAM= name/value pair. My SP was registered in the default Foundation Repository in the STP_Orion stored process repository. When this HTML page loads into the browser, and I click on the link, the <PRE> results look as they would look in the LISTING window. The <H1> tag output looks as you would expect header tag lines to look.
Remember that FILE _WEBOUT is not the same as FILE PRINT. So some print-oriented or "page" oriented FILE or PUT options, like PUT _PAGE_, N=PS or LINESLEFT or "line feed" controls like PUT / may not work as you expect. I have not ever experimented with a really complex DATA _NULL_ program using the SPWA in the BI platform. My warnings are based on some of things that were true when I converted DATA _NULL_ programs to produce streaming output in SAS/IntrNet (whose application server is very similar to the stored process server). Also, you may need to change the FORMCHAR option if your program is writing its own table lines using '----------' and '+' characters.
The only other thing I can think of is to look up the old formatting macros, these were macro programs introduced in SAS 6, in order to help people generate output from SAS procedures and processes so the output could have the HTML wrapper code generated automatically. There were %DS2HTM, %TAB2HTM and %OUT2HTM macro programs. I believe the one you might investigate is the %OUT2HTM macro program -- however, I believe that it had a "linesize limit" of 195 characters and I don't know whether it would work with the SPWA. The macro programs worked very much like PROC PRINTTO or ODS, you had a macro call before your program and then you had a closing macro call after your program. Any output created by the program between the 2 macro calls would be placed within <PRE> tags. But, as I said, I don't know whether these macros would still work with the SP server and the SPWA.
For more help with this task, you might wish to work with SAS Tech Support.
cynthia
