Hi guys, I'm running SAS 9.3 on a Windows 2008R2 server and I have a 3rd party scheduler that runs my scheduled SAS jobs.  I have a few SAS jobs that can periodically have no records in them so I conditionally create a report telling the user that there were no records found.  The issue comes when I need to end SAS after I create this "dummy" report.  I've tried the "abort return 0" and "%abort return 0" statements but it appears that SAS is still returning a non 0 return code.  Is there any way to stop SAS from processing further without causing an error?  ... View more

Hi guys, I find myself with a problem and I can't seem to find the solution by searching... All of our reporting is created via SAS 9.3 and outputted though the ExcelXP tagset.  I'd like to use the feature in Excel 2010 for Grouping (Data Ribbon --> "Group" button).  Is there any way to apply this via SAS when I'm creating the report? The business issue is this:  We have records of customers which have subsidiaries.  In the final report I'd like to show the customer grouped with any subsidiaries it may own.  I know I could add a parmeter to the report to allow the user to include/exclude these rows but I think it might be cleaner to always include them but in a collapsed group with the parent company.  Any help would be appreciated!  ... View more

Hi guys, I come to you with another question that's got me stumped.  I whipped up the example below based on the "sashelp.cars" dataset to keep things nice and simple.  Here's what I'm trying to do:  After each group of car "make" I want to print a line showing all unique occurances of car "type" and "cylinders".  Each group can have a different amount of combinations, which is where I get stuck.  In the example below, the variable "num" should hold the number of unique occurances within a group but I can't figure out how to use that value in the do loop below it.  Currently I have it hard coded to "2".  Any help would be appreciated!! Thanks! data test;           set sashelp.cars;           key = strip(type) || '_' || strip(cylinders);           keep make type cylinders key; run; %macro create_report;           ods tagsets.ExcelXP path="c:\temp" file="test.xls";           proc report data=test missing nowindows split='*';                     column make type cylinders          key;                     define make            / group;                     define key       / group;                     define type            / display;                     define cylinders / display;                     compute before make;                               num = 0;                     endcomp;                     compute after key;                               num = num + 1;                               call symput("key" || strip(num), key);                               call symput("num",strip(num));  /**<-- at the end of each group num should hold the number of unique combos **/                     endcomp;                     break after make / summarize;                     compute after make;                               %do i = 1 %to 2; /** <-----how do I use "num" instead of "2" ?? **/                                         type&i = scan(input(symget(%bquote('key&i')), $char50.),1,'_');                                         cylinders&i  = scan(input(symget(%bquote('key&i')), $char50.),2,'_');                                         line @10 'Type: ' type&i $char50. @30 ' Cylinders: ' cylinders&i $char50.;                               %end;                     endcomp;           run;           ods _all_ close; %mend create_report; %create_report; ... View more

Hi all, I'm using proc report with ods HTML to output a sample report.  At each break of the grouped variable (age)  I'd like to write out a line ('TestLine').  The program runs clean but the line never appears.  I inspected the resulting html in a text editor and verified that the text of the added line is not in the file.  Any ideas what I'm missing? data class;           set sashelp.class; run; ods listing close; ods html file="c:\temp\test.html"; proc report data=class nowindows;           column age name;           define age   / group;           define name   / display;           break after age/;           compute after age;               line 'TestLine';              endcomp; run; ods _all_ close; ... View more