BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jwillis
Quartz | Level 8

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Quentin
Super User

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.

BASUG is hosting free webinars Next up: Mike Sale presenting Data Warehousing with SAS April 10 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

View solution in original post

7 REPLIES 7
TomKari
Onyx | Level 15

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
Quartz | Level 8

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
Onyx | Level 15

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
Super User

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.

BASUG is hosting free webinars Next up: Mike Sale presenting Data Warehousing with SAS April 10 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 2789 views
  • 8 likes
  • 4 in conversation