topic Re: cellwidth and asis options in PROC REPORT in SAS Programming

cellwidth and asis options in PROC REPORT

deepanshu88us0 — Wed, 08 Mar 2023 06:51:38 GMT

I have output which has some leading and trailing spaces. I preserved it using asis= option. It's working but I also want to reduce the width of column (basically wrapping text). When I am using cellwidth=5in asis=ON] it is not considering cellwidth= option. I understand asis= is trying to show it as-is. I am not creating HTML file, only want to show output in RESULTS window.

data outdata;
  infile datalines;
  input;
  output = _infile_;
  datalines;
                                         This is a long line of data with leading and trailing space                                          
;
run;

proc report data=outdata ;
column output;
define output / display style(column)=[cellwidth=5in fontsize=10pt asis=ON];
run;

Re: cellwidth and asis options in PROC REPORT

mtnbikerjoshua — Tue, 07 Mar 2023 20:28:49 GMT

Hi @deepanshu88us0,

Just to be clear the asis=ON option preserves leading space but not trailing space. I tried your code with this example data, and the cellwidth= seems to be working as expected. Can you provide example data that reproduces the problem?

data outdata;
  infile datalines;
  input;
  output = _infile_;
  datalines;
                                         This is a long line of data with leading and trailing space                                          
;
run;

Re: cellwidth and asis options in PROC REPORT

deepanshu88us0 — Tue, 07 Mar 2023 20:47:25 GMT

It's not working..Not throwing error but not making changes.. Try with cellwidth=1in

proc report data=outdata ;
column output;
define output / display style(column)=[cellwidth=1in fontsize=10pt asis=ON];
run;

Note : I am using SAS Studio

Re: cellwidth and asis options in PROC REPORT

Cynthia_sas — Wed, 08 Mar 2023 02:45:13 GMT

Just FYI, unless you change the options, the RESULT window in SAS Studio is showing you HTML output. So in fact, you ARE using HTML.I believe the default is HTML5.
Cynthia

Re: cellwidth and asis options in PROC REPORT

deepanshu88us0 — Wed, 08 Mar 2023 05:30:12 GMT

Thanks. any solution to the original problem?

Re: cellwidth and asis options in PROC REPORT

deepanshu88us0 — Wed, 08 Mar 2023 07:00:42 GMT

Seems to be a bug - https://support.sas.com/kb/15/617.html

Re: cellwidth and asis options in PROC REPORT

Ksharp — Wed, 08 Mar 2023 11:50:36 GMT

/*
Try option:
1)indent=0.5in
or
2)pretext=' '
*/
data outdata;
infile datalines;
input;
output = _infile_;
datalines;
This is a long line of data with leading and trailing space
;
run;
proc report data=outdata nowd;
column output;
define output / display style(column)=[cellwidth=1in fontsize=10pt indent=0.5in];
run;

Re: cellwidth and asis options in PROC REPORT

deepanshu88us0 — Wed, 08 Mar 2023 13:37:09 GMT

Thanks. Identation is not consistent in my dataset.. Some obs may have larger identation than others, some may not even have any.

Re: cellwidth and asis options in PROC REPORT

Cynthia_sas — Wed, 08 Mar 2023 13:58:33 GMT

Hi: No solution because the original problem is not clear to me. You want to have both leading and trailing spaces respected, but you also want to control the cellwidth to 5" and the font size to 10pt. I can't really visualize what you want because there's only 1 line of "data" in your initial program. And it doesn't really look like data to me, it looks like text strings. How do you envision being able to see the leading and trailing spaces in a line that wraps to a cellwidth of 5"? I would need to see more lines of output and some example of what you expect to get or what you want.
Cynthia

Re: cellwidth and asis options in PROC REPORT

mtnbikerjoshua — Wed, 08 Mar 2023 15:41:15 GMT

Based on that bug report, it seems like your best bet would be to upgrade SAS if that is possible. If you can't, then one possible workaround is to make the first character of the string something that SAS doesn't recognize as a space. For instance, you could put a zero width space at the beginning of the string:

data outdata;
  infile datalines;
  input;
  output = _infile_;
  datalines;
^{unicode 0200B}                                       This is a long line of data with leading and trailing space                                          
;
run;

ods escapechar='^';

proc report data=outdata ;
  column output;
  define output / display style(column)=[cellwidth=5in fontsize=10pt];
run;

Re: cellwidth and asis options in PROC REPORT

KevinViel — Wed, 27 Sep 2023 19:37:34 GMT

I like the style indent approach, especially since 1) it does not pad the value, which matters when another programmer must Validate the data sets, 2) if wrapping occurs the value does not start at the left most, but rather back at the margin, and 3) one can use logic in a COMPUTE block to apply it:

https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-PDF-RTF-and-the-REPORT-procedure-break-on-space-not-word/m-p/328300#M17819

Specifically, I use

compute row_1 ;
   if row_order_1 > 0
   then call define ( _col_
                    , "style"
                    , "style = { leftmargin = 1% }"
                    ) ;

endcomp ;

HTH,

Kevin