Did you know that....
It is possible to exceed Proc Report line size limitation of 256
characters, as well as the variable width limit of 64.
This is new to me, and may be old news to everyone else, but I discovered
that if I execute Proc Report through ODS and use the ExcelXP tagset, I can
beat the limitations.
Note: The log will still show the standard errors:
ERROR: LINESIZE must be between 64 and 256.
ERROR: The width of <variable> is not between 1 and 64. Adjust the
column width or linesize.
NOTE: This affects LISTING output.
NOTE: The SAS System stopped processing this step because of errors.
However, the finished spreadsheet contains all the rows of data, and none
of the columns get truncated. The error messages seem to pertain only to
the output window and not the finished results of the report.
This may spark some healthy banter.....