BookmarkSubscribeRSS Feed
anand_panchal
Calcite | Level 5

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.

1 REPLY 1
Madelyn_SAS
SAS Super FREQ

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. 

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1505 views
  • 0 likes
  • 2 in conversation