As a part of my internship project, I am using SAS Enterprise Guide to create some reports. These reports mainly contain frequency tables and charts. They have been generated by using simple Base SAS programming, with some help from Query Builder and List Report Wizard.
Also, these reports are to be shown according to user-desired choices, such as particular Financial Years or particular Month-wise reports. I have successfully used SAS Prompts for this purpose.
Now I have been told that this whole thing needs to be viewable in SAS Web Report Studio (WRS). A user should access WRS, then open this report, then input his values for the prompts, and finally obtain the desired output accordingly. They should not be able to edit the original code, they should just be able to view the reports.
What ways are there to implement this? So far I've been looking at Stored Processes but I'm not entirely sure if it's the right direction to head in. Any suggestions would be greatly appreciated.
I am using SAS EG 9.4 and SAS Web Report Studio 4.4.
You can use SAS Enterprise Guide to publish SAS Report format to your Report Repository.
http://support.sas.com/kb/40/608.html
However, only reports that are created from output of a stored process can be refreshed in Web Report Studio. Otherwise, the output is static in Web Report Studio.
You can try letting Enterprise Guide convert your program to a stored process, and then follow the instructions in the SAS Note to publish. In the Enterprise Guide Help, see the topic Working with Stored Processes > Creating stored processes.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.