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 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.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
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.
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.