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.....