The SAS Output Delivery System and reporting techniques

SAS ODS output from ID portal does not show proc report summary line text.

Reply
Contributor
Posts: 33

SAS ODS output from ID portal does not show proc report summary line text.

I have a pretty intermediate issue with SAS results at the moment. I am trying to generate some reports where the PROC REPORT summary lines (break and rbreak) have label commands to change the text in the summary line row. I have successfully changed the text within SAS EG, but when I got to our information delivery portal, run the stored process, and have it open in Excel (via ODS tagsets command) the altered summary line text does not show up in the Excel output...it is blank instead. Below is my code for the PROC REPORT statement and I am wondering if anybody has encountered this issue.


"Batch Track Report";


"Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))";



format;


value blankValue other=' ';


;



report data=WORK.GROSS_COLLECTION_RESULTS nowd split='_';


column Region Type List_Month cv1 JCC_Collections Legal_Collections Total_Collections;


define Region / order 'Region' missing center style=[fontsize=12pt cellwidth=150 fontweight=bold];


compute Region;


if upcase(_break_)="TYPE" then do;


call define("Region", 'style', 'style=[pretext="Subtotal  "]');


end;


if _break_='Region' then do;


call define("Region", 'style', 'style=[pretext="Region Total "]');


end;


if _break_ = '_RBREAK_' then do;


call define ('Region','style','style=[pretext="Grand Total "]');


end;


endcomp;


define Type / order 'Type' missing center style=[fontsize=12pt cellwidth=120 fontweight=bold];


define List_Month / display format=YYMMDD10. missing noprint order=internal center style=[fontsize=12pt cellwidth=120];


define cv1 / computed 'List_Month' missing center style=[fontsize=12pt cellwidth=120];


compute cv1 / char length=30;


if _break_ eq ' ' then do;


if List_Month ne . then hold1=List_Month;


YYMMDD10.);


end;


if _break_ ne ' ' then cv1=' ';


endcomp;


define JCC_Collections / analysis SUM 'JCC_Collections' format=DOLLAR20.2 missing center style=[fontsize=12pt cellwidth=150];


define Legal_Collections / analysis SUM 'Legal_Collections' format=DOLLAR20.2 missing center style=[fontsize=12pt cellwidth=150];


define Total_Collections / analysis SUM 'Total_Collections' format=DOLLAR20.2 missing center style=[fontsize=12pt cellwidth=150];


break after Type / summarize suppress skip style(summary)=[fontsize=12pt fontweight=bold background=lightgrey];


break after Region / ol summarize suppress skip style(summary)=[fontsize=12pt fontweight=bold background=lightgrey];


rbreak after / summarize style(summary)=[fontsize=12pt fontweight=bold background=lightgrey];


compute after Region;


line ' ';


endcomp;


compute after Type;


line ' ';


endcomp;


run;


;



catalog catalog=work.formats;


delete blankvalue / entrytype=format;


;TITLE; FOOTNOTE;



Contributor
Posts: 33

Re: SAS ODS output from ID portal does not show proc report summary line text.

Sorry, the copy and paste cut off the front of my code.

Grand Advisor
Posts: 10,210

Re: SAS ODS output from ID portal does not show proc report summary line text.

It's obnoxious, and hopefully soon to change, with the paste function here. Until then (next week) you will get better results pasting the code from the SAS editor into a NOTEPAD or similar pure text editor and then copy/paste from there to the forum.

You should show your entire ODS statement sending the data to Excel. Some options may be of interest for this bit.

SAS Super FREQ
Posts: 8,718

Re: SAS ODS output from ID portal does not show proc report summary line text.

Hi:

  This is a question for SAS Tech Support. When you run a stored process, depending on whether or how you are overriding the values for &_ODSDEST reserved macro variable, you may or may not be generating code that respects the ODS style PRETEXT that you are coding. This will depend on the version of SAS and the version of the Platform and other things about your stored process setup (not just &_ODSDEST, but &_ODSSTYLE).

cynthia

Ask a Question
Discussion stats
  • 3 replies
  • 375 views
  • 0 likes
  • 3 in conversation