What are the best books, papers or libraries to learn SAS Web Report studio?

[jwillis]

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?

[TomKari]

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

[jwillis]

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.

[TomKari]

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

[Quentin · Accepted solution]

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.

[cynpur]

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

[jwillis]

Excellent.  Thank you.

[jwillis]

Excellent.  Thank you.