Date: Thu, 16 Jun 2005 14:48:03 -0400
Reply-To: John Kramer <kramer@JIMMY.HARVARD.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: John Kramer <kramer@JIMMY.HARVARD.EDU>
Subject: Re: SAS/Intrnet implementation questions - Very Urgent
I agree generally with Jack's comments. I would say do not bother
%tab2htm() just use ODS to display the html and send it to _webout.
For the security question, you can set up SAS/Intrnet so individual users
can authenticate against the server (at least on UNIX - not sure on Windows)
using a pool service which is what we have done. Set up for this is a bit
more complicated than a simple socket service. I don't believe there is a
way to retrict certain reports to specific users.
A simple way to implement this yourself might be just to authenticate
users using a SAS program which gets called first by SAS/Intrnet and
authenticates users against a database. This intermediate SAS program which
is always called to perform the authentication could then passes the job off
to the actual report program (through a macro call, %include statement, etc)
assuming authentication was successful.
You would have to make sure that the report authentication SAS program
was the only SAS program in your authorized program library though (as
specified in the proglibs statement of your proc appsrv procedure call used
to start up the application server) though, otherwise a user could just
change the _program variable and call any other SAS program in this
directory bypassing this authentication program entirely.
This is just a rough sketch of something you could try and would need to
be fleshed out a bit more.
On Thu, 16 Jun 2005 03:48:43 -0700, niks <nnkulkarni@GMAIL.COM> wrote:
>We have written several Base SAS programs for regular report generation
>(the commonly used procs were Proc Print, Proc Tabulate and Proc
>Report, Proc summarize). I want to develop a web interface, which is
>user friendly for my colleague to generate the report by themselves
>without any knowledge of SAS. We have decided to use SAS/Intrnet
>application - the application dispatcher is setup and working.
>Please help me by answering few queries mentioned below :
>1.)Specific reports should be restricted to specific users -how to do
>this using SAS Intrnet?(is Java Script is to be used then how and where
>to use also if ready made code is available it will be of great help)
>2.) How to convert the existing SAS Programs into SAS macro programs?
>3.) As per my understanding the selections made on the HTML form is
>converted into SAS macro variable and passed to the SAS programs. Then
>the SAS program uses these variables in the program and generates an
>Now, the question here is How to pass the output generated from the SAS
>program to the webpage? - is it done using SAS ODS (which is embedded
>into the sas program?) if yes then is this the only way? Or we have to
>embed HTML code into the exsting SAS program to display the output?
>Also, If I want to change my existing SAS program to a SAS macro
>program and use the system macros like %tab2htm(), %ds2htm() etc..
>to display the output in the web browser how different it will be by
>using ODS HTML?
>Is it the case that always %tab2htm() is used to display the output if
>the program consists of an Proc tabulate? or ODS HTML can also be used
>for outputting the report?
>4.) The output generated through the SAS program which is displayed
>onto the web browser should be in the same format as it was earlier -
>can a Cascaded Style Sheet be used in SAS /Intrnet? if Yes then How to
>do it? I know how to do this by using SAS ODS HTML but if %tab2htm()
>macro is used to generate ouput then how to and where to embed the
>style sheet in the SAS program.
>5.) How to export this generated report through SAS/Inrtnet to Excel by
>clicking a button on the HTML form - "Export report to Excel".
>I am really sorry for putting in so long questions. I really appreciate
>your time and efforts to read the questions above.
>Any help is highle appreciated.
>Thanks in Advance !!