topic Re: ODS Excel, PROC ODSTEXT and tagattr=wraptext in ODS and Base Reporting

ODS Excel, PROC ODSTEXT and tagattr=wraptext

PhilC — Tue, 07 May 2019 18:28:30 GMT

Why does the second and third lines wrap, despite using "tagattr=wraptext", while the first one does not wrap?

I expect all three lines not to wrap. Do you have any ideas about what I am doing incorrectly?

ods excel
  file=  "&Folder\wraptext.xlsx" 
  options (
    Absolute_column_width = '  140pt, 59pt'
    /*I need these column widths for this to work with 
    a table that I will add after this procedure.*/
    );

  Title;footnote;
  proc odstext;
    p "Discharges from (screen) and Investigation Records" 
       /style=[tagattr='wraptext:no' fontsize=14pt font_weight=bold];
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with appropriate HIPAA-compliant business agreements."
       /style=[tagattr='wraptext:no' ];
    p "This file may contain information associated with pre-trial investigations.  It is exempt from public record disclosure unless cleared by the appropriate, qualified record custodian."
       /style=[tagattr='wraptext:no' ];
  run;

  ods excel close;

Lets identify two different kinds of line wrapping.

First, there is the line wrapping ODS EXCEL implements (fixed with the option Flow)
Second, the line wrapping done, or not done, because of the specific Excel, XML schema level, formatting code "WrapText".

The latter line wrapping is happening, but I am truly only concerned about the former type of line wrapping.

--- SAS Software ---
SAS Enterprise Guide version: 7.15 HF7 (7.100.5.6177)
SAS System version: 9405.100.22960.39165

Re: ODS Excel, PROC ODSTEXT and tagattr=wraptext

PhilC — Tue, 07 May 2019 19:44:27 GMT

Too slow.

Ok I figured this out. I started varying the length of the string and I found that there was a threshold.

ods excel
  file=  "&Folder\wraptext.xlsx" 
  options (
    Absolute_column_width = '  140pt, 59pt'
    );

  Title;footnote;
  proc odstext;
    p "Discharges from (screen) and Investigation Records" 
       /style=[tagattr='WrapText:0' fontsize=14pt font_weight=bold];
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners wi";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with a";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with appro";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with appropria";
    p " ";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with ap";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with app";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with appr";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with appro";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with approp";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with appropr";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with appropri";
    p "This file contains HIPAA protected healthcare information.  It is intended for use within this agency and with authorized partners with appropria";

run;

  ods excel close;

The magic number 139. (???) So why? I wonder.

Re: ODS Excel, PROC ODSTEXT and tagattr=wraptext

PhilC — Tue, 07 May 2019 19:46:34 GMT

Got a badge for answering my own question. I'm somewhere between "Yoohoo" and "wait -- what's going on here?"