What are the best books, links, papers or libraries to learn about converting my PC SAS adhoc programs into stored processes to run on a Network server through SAS Web Report studio?
Hi,
I'm a big fan of two books by Tricia Aanderud and Angela Hall. These helped me a LOT when I was first learning about stored processes.
http://www.amazon.com/Keys-Learning-SAS-Stored-Processes/dp/0615588727
http://www.amazon.com/Building-Business-Intelligence-Using-SAS/dp/1607649888 (Good overview of SAS BI )
Would also suggest reading user group papers and blogs.
Tricia's blog is http://www.bi-notes.com/ (disclosure: I sometimes blog there, but I'm not a paid endorser : )
Angela's is http://blogs.sas.com/content/bi/author/angelahall/
HTH,
-Q.
One option you have, depending on the nature of your programs, is to turn them into Stored Processes which can then be referred to from WRS.
Tom
You are correct. I'm looking for documentation on that conversion from code to stored process. For example: "Usage Note 48136" states that there are times when a stored process won't render results in Web Report Studio. I need to learn all that I can about stored processes and I'm looking for ideas on the best documentation that is out there. I cannot afford to take the SAS classes.
I would suggest that you set up a test case, using simple code, that produces the same kind of result as your program. Try to get that working in WRS, with the help of documentation, this forum, and SAS Tech Support.
Hopefully, that won't take a huge amount of effort, and it should quickly give you an indication of whether you can get what you want, or how you might need to adapt your program to get it.
I find using this kind of prototyping approach works better for this type of problem than trying to do it all from "book knowledge".
Best,
Tom
Hi,
I'm a big fan of two books by Tricia Aanderud and Angela Hall. These helped me a LOT when I was first learning about stored processes.
http://www.amazon.com/Keys-Learning-SAS-Stored-Processes/dp/0615588727
http://www.amazon.com/Building-Business-Intelligence-Using-SAS/dp/1607649888 (Good overview of SAS BI )
Would also suggest reading user group papers and blogs.
Tricia's blog is http://www.bi-notes.com/ (disclosure: I sometimes blog there, but I'm not a paid endorser : )
Angela's is http://blogs.sas.com/content/bi/author/angelahall/
HTH,
-Q.
I agree with the recommendations above, but also wanted to let you know about some course notes that also cover this topic.
Creating Web Applications Using SAS® Stored Processes Course Notes
Creating Stored Processes Using SAS® 2: Additional Topics Course Notes
Creating Stored Processes Using SAS® 1: Essentials Course Notes
Here is one other that covers Web Report Studio.
http://www.sas.com/store/books/prodBK_65339_en.html
Hope this is helpful.
Cindy
Excellent. Thank you.
Excellent. Thank you.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: