Hi Scott, I too am in the process of learning about stored processes after years of writing SAS code. So I'm going to respond to your question with more questions, and a few suggestions. My main question is why you chose to set off a batch job? Perhaps only because the job runs a long time? (And agree, you might be better off looking into other background processing options). I hadn't seen people using stored procedures to kick off batch jobs, so curious to what others think of this approach? On the one hand, it's a tempting approach to me. Because as a newbie to stored processes, I would once again feel confident that I could control things like autoexec, config.sas, etc., without worrying about how these are set by an administrator. I would also get a nice log file back, without needing to use proc printto or looking for server logs. But on the other hand, relying on kicking off a new SAS session feels a little bit like running home to what feels comfortable as a SAS programmer. Rather than pushing for new approaches as a SAS developer. And I can see down side to the approach, e.g. time to start up a new session, and more importantly by-passing of meta data security in the the new session (cuz it knows not of the meta data, right?). Will look forward to seeing what those with more experience have to say. For resources I've found handy, I would have found Both of Tricia Aanderud and Angela Hall's books helpful (Building BI Using SAS and 50 Keys to Learning SAS Stored Processes). If you have to choose one, I would get the Stored Process book since you don't have the full EBI setup. It's great. Works through nice examples. I see Tricia already recommended her Blog. I've also found Don Henderson's blog to be a great resource: http://hcsbi.blogspot.com. I just ordered Don's book, Building Web Application with SAS/Intrnet. While it's a few years old, a friend of mind recommended it, and much of the content/logic/process is the same whether you are using the new BI tools / stored procedures or writing your own code. And from seeing Don's blog, and SAS commuity postings, and responses to my questions here in the forums, I'm sure it won't disappoint. HTH, --Q.
... View more