🚀 go-pugleaf

Hi,

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
output.

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

Nikhil