BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Enterprise Guide

Double, No Triple Check those %STPBEGIN and %STPEND macros from Enterprise Guide

Submitted by on 2011-09-23 – 6:00 AM 4 Comments

Be very aware of when the %STPBEGIN and %STPEND macros are & are not needed in your SAS Stored Process. When opening a stored processes directly from Enterprise Guide to make modifications, the ‘Include Code for’ option to reinsert these two macros is automatically turned back on. So even if you have turned it off previously, always make sure that if you do not need them the option is off.

Never miss a BI Notes post!

Click here for free subscription. Once you subscribe you'll be asked to confirm your subscription through your email account. You email address is kept private and you can unsubscribe anytime.

 

The following two tabs change content below.
Angela Hall manages an implementation team at SAS Institute Inc. to provide customers with analytic focused solutions which uncover hidden patterns in their data to assist in eliminating waste and fraud. A SAS user since 1995, Angela holds SAS BASE and BI Content Developer Certifications. Angela blogs about SAS Business Intelligence software tips and has coauthored two books “Building Business Intelligence Using SAS®” and "The 50 Keys to Learning SAS Stored Processes".
Spread the love

Tags: ,

4 Comments »

  • Phil:
    Love your blog – it’s so creative and funny. Added it to the blogroll.

    Thanks for visiting!
    Tricia

  • Thanks Angela! I do wish that EG was more descriptive about what these macros did, because if this setting is incorrect the whole stored process will not work.

  • Anthony says:

    Great info, thanks!

  • Anonymous says:

    I wanted to thank you yet again for this amazing web-site you have designed here. It’s full of ideas for those who are definitely interested in this subject, especially this very post. You’re really all absolutely sweet and thoughtful of others plus reading your blog posts is a superb delight if you ask me. And what a generous gift! Ben and I are going to have fun making use of your points in what we should instead do next week. Our list is a mile long and tips might be put to good use.

1 Pingbacks »