Traditional web-based reporting with SAS BI tools

ODS FILE Option for WRS

Reply
Contributor
Posts: 21

ODS FILE Option for WRS

Hi All,

 

My stored process code is running fine when I give file option for ODS Statemnt .But as per requirement I have to run this report from WRS & want to see output in WRS only. 

 

I am not sure what filename or path option should I give.

I tried _webout its say insufficent authorixation access.If I remove ods statmement I can view report in WRS .

Is there any option I am missing to give.

 

 

ODS html file="/kms/warehouse/sffecm/malhotrd/Cost Avoidance.html" style=journal ;

options nocenter;
proc report data=final_monthly_rpt style(header)= [just=left font_weight=bold] Style(report)={frame=void};
column case_category_cd_desc ('Current Month' Current_Month) ('QUARTER YTD' QTD) ('FY YTD' YTD);
define case_category_cd_desc/group 'Total Dollars Recouped for each category defined' style(column) =[indent =25 cellwidth=4 in] ;
define Current_Month/analysis sum format=DOLLAR10.2 ' ' style=[cellwidth=1.2 in just=left] ;
define QTD/analysis sum format=DOLLAR10.2 ' ' style=[cellwidth=1.2 in just=left] ;
define YTD/analysis sum format=DOLLAR10.2 ' ' style=[cellwidth=1.2 in just=left] ;
RBREAK AFTER /SUMMARIZE UL OL;
compute after;
case_category_cd_desc='Total Identified Recoupment Dollars upon Case Closing';
call define(_ROW_,'style','style={font_weight=bold background=ALICEBLUE just = left }');
endcomp;
options missing=0;
run;
title1;
title2;

 

Automatic variable I can see in code log related to ODS are

 

_ODSDEST=tagsets.sasreport13
_ODSOPTIONS=options(rolap="on") ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v94/sasgraph.exe#version=9,4")
_ODSSTYLE=HtmlBlue
_ODSSTYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
_PROGRAM=/SFFECM/Project Data/Stored Process/Cost Avoidance Report
_REPLAY="&_URL?_sessionid=311F34C5-67BD-C049-8C85-1759D968E9FD&_program=replay&_entry=&_TMPCAT.."
_RESULT=PACKAGE_TO_ARCHIVE

SAS Super FREQ
Posts: 480

Re: ODS FILE Option for WRS

SAS Web Report Studio supports only those stored processes that conform to a very specific set of rules. For example, the stored process must produce package output so the _WEBOUT fileref is not supported. This SAS note has a summary of the major rules:

 

http://support.sas.com/kb/47/839.html

 

The alternative is to use the SAS Stored Process Web Application instead.

Ask a Question
Discussion stats
  • 1 reply
  • 272 views
  • 0 likes
  • 2 in conversation