The SAS Output Delivery System and reporting techniques

multiple Proc Report on same worksheet - Footnote spacing

Accepted Solution Solved
Reply
Contributor
Posts: 31
Accepted Solution

multiple Proc Report on same worksheet - Footnote spacing

Hi,

For the cases where I do not have a Footnote, is there a way I can remove that space from the report.

Here is an example of what i am trying to achieve in the Stored process using excel Addin..

In the output , although I do not have a footnote, it leaves the row 8 and row 9 as blank.

Also can  is there a way i can remove that black line after each proc report  or change its color.

Please find the log file attached.  Thanks in advance. 

%MACRO CLASS_PRINT(SEX);

  PROC REPORT DATA=SASHELP.CLASS (WHERE=(SEX="&SEX.") OBS=3);

  TITLE "TEST FOOTNOTE SPACING";

  RUN;

%MEND;

%CLASS_PRINT(M);

%CLASS_PRINT(F);

screen1.JPG

Attachment

Accepted Solutions
Solution
‎08-04-2014 12:02 PM
SAS Super FREQ
Posts: 8,868

Re: multiple Proc Report on same worksheet - Footnote spacing

Hi:

  Since you say you are using a Stored Process and the SAS Add-in for Microsoft office, the behavior of the stored process will be determined by the result type you have specified - -either inside the Add-in using SAS --> Options --> Results (did you pick SAS Report, HTML or CSV as the result type) or will be determined by the destination you specify inside the stored process code (for example, your code has an override for &_ODSDEST=MSOFFICE2K before your %STPBEGIN; statement in the stored process) -- both the destination and the style being used will have an impact on the way the output looks in the SAS Add-in for Microsoft Office.
    

  The big black line is a horizontal rule, generally, that is put into the output because you use a style for your output that specifies a horizontal rule as the "delimiter" between logical pages of output. For example, if you compare these 2 different programs (NOT as a stored process), you will see that the Miminal style has a horizontal rule and the Normal style does not have a horizontal rule. So you could  get rid of the line by changing the style used for your stored process.

cynthia


compare_two_outputs_in_Excel.pngcompare_two_outputs_with_horizontal_rule.png

View solution in original post


All Replies
Solution
‎08-04-2014 12:02 PM
SAS Super FREQ
Posts: 8,868

Re: multiple Proc Report on same worksheet - Footnote spacing

Hi:

  Since you say you are using a Stored Process and the SAS Add-in for Microsoft office, the behavior of the stored process will be determined by the result type you have specified - -either inside the Add-in using SAS --> Options --> Results (did you pick SAS Report, HTML or CSV as the result type) or will be determined by the destination you specify inside the stored process code (for example, your code has an override for &_ODSDEST=MSOFFICE2K before your %STPBEGIN; statement in the stored process) -- both the destination and the style being used will have an impact on the way the output looks in the SAS Add-in for Microsoft Office.
    

  The big black line is a horizontal rule, generally, that is put into the output because you use a style for your output that specifies a horizontal rule as the "delimiter" between logical pages of output. For example, if you compare these 2 different programs (NOT as a stored process), you will see that the Miminal style has a horizontal rule and the Normal style does not have a horizontal rule. So you could  get rid of the line by changing the style used for your stored process.

cynthia


compare_two_outputs_in_Excel.pngcompare_two_outputs_with_horizontal_rule.png
Contributor
Posts: 31

Re: multiple Proc Report on same worksheet - Footnote spacing

Posted in reply to Cynthia_sas

Thank you so much Cynthia.  I appreciate your quick response. Thanks again and have a great day ahead.

I changed the values to the following and now my report looks much better ...

screen1.JPG

Contributor
Posts: 31

Re: multiple Proc Report on same worksheet - Footnote spacing

Posted in reply to Cynthia_sas

Cynthia,

By any chance do you have an example of overriding the _ODSSTYLE   within the stored process so i can use this style only for specific report.

Thanks in advance

SAS Super FREQ
Posts: 8,868

Re: multiple Proc Report on same worksheet - Footnote spacing

Hi:

You will need to explicitly code an override statement into your stored process code. If SAS Enterprise Guide created your stored process, then you will need to modify the code generated by Enterprise Guide. In general overrides work this way:

%let _odsdest=msoffice2k;

%let _odsstyle = minimal;

%let _odsstylesheet=;

%stpbegin;

*** your code;

%stpend;

  However, when Enterprise Guide creates a stored process, it puts the needed macro variables around the code. To modify the code you will need to turn off the choices in the EG Stored Process Wizard that automatically add code.

cynthia

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 557 views
  • 6 likes
  • 2 in conversation