Hi, could someone help me please. In summary I need to do the following and I have used the sashelp.Class dataset to provide my code. 1. I need to have sub totals but on the final output I need to keep the sub totals and make the contributing numeric data zero. 2. I need to format and output to the Web (IE) via SASWep Stored Process and write it to an Excel spreadsheet. I get to point 1 ok but I when I try point 2 I get the following error NOTE: Writing HTML Body file: c:\temp\test.xls ERROR: A component of C:\DOCUME~1\sassrv\LOCALS~1\Temp\SAS Temporary Files\_TD6488\Prc17\1b2cd535-9fc1-4fef-acea-880f6e15e4fa\c:\temp \test.xls is not a directory. WARNING: No body file. HTML output will not be created. I cannot remove the c:\temp from the destination because I need to specify the destination path in a variable. My code is below but will be delivered via a SAS Web App not EG. :- * Begin EG generated code (do not edit this line); * * Stored process registered by * Enterprise Guide Stored Process Manager v4.1 * * ==================================================================== * Stored process name: Test * ==================================================================== *; *ProcessBody; %STPBEGIN; * End EG generated code (do not edit this line); * Forum Code ; data sasclass_out; set sashelp.class; where age = 14 or age = 15; if age = 14 then flag=1; if age = 15 then flag=2; run; proc report data=sasclass_out out=sasclass_out2 nowindows; columns name sex age height flag weight weight=w; define flag / order noprint; define Name / display "Name"; define Sex / display "Sex"; define Age/ display "Age"; define Height / display "Height"; define Weight / analysis "Weight"; define w / sum noprint; compute after flag; Name='Total: '; weight.sum=w; endcomp; break after flag / summarize; run; data sasclass_out3; set sasclass_out2; if age = 14 or age =15 then weight=0; run; ods html file="c:\temp\test.xls"; proc report data= sasclass_out3 nowindows; columns name sex age height weight ; define Name / display "Name"; define Sex / display "Sex"; define Age/ display "Age"; define Height / display "Height"; define Weight / analysis "Weight"; compute age; if age = 14 then call define(_ROW_ , "style","style=[background=light brown]"); if age = 15 then call define(_ROW_ , "style","style=[background=light yellow]"); endcomp; run; ods html close; * Begin EG generated code (do not edit this line); *';*";*/;run; %STPEND; * End EG generated code (do not edit this line);
... View more