As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

The runMacro Stored Process

From sasCommunity
Revision as of 17:11, 18 February 2010 by Donh (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The complete source code for the runMacro Stored Process as discussed on the blog entries

on Jurassic SAS© in the BI/EBI World

options sasautos=("/Projects/&Project/Macros"
/*ODS PATH statement pointing to the template store*/
%let _odsDest = %upcase(&_odsdest);
data _null_;
 if "&_odsdest" = 'EXCEL' then
   rc = stpsrv_header('Content-type','application/');
   call symput('_odsDest','HTML');
 else if "&_odsdest" = 'TAGSETS.EXCELXP' then
   rc = stpsrv_header('Content-type','application/');
   rc = stpsrv_header('Content-disposition','attachment; filename="_.xml"');
 else if "&_odsdest" = 'TAGSETS.TABLEEDITOR' then
    call symput('_odsOptions',
                "options(" ||
                strip(symget('_odsOptions') ||
                " pageheight='&pageheight'" ||
                " pagewidth='&pagewidth'" ||
                " sort='&sort'" ||
                " frozen_rowheaders='&frozen_rowheaders'" ||
                " frozen_headers='&frozen_headers')"));
%put NOTE: Execute macro &macroToRun..;