topic Re: 9.2 to 9.4 width of report column in ODS and Base Reporting

9.2 to 9.4 width of report column

scan — Wed, 07 Dec 2016 09:22:25 GMT

Dear community,

I recently switched from sas 9.2 to 9.4 and appreciate the new system.

I'm trying to run some old programs that were meant to be repetible, anyway probably in the proc report (ods rtf it could be useful) something changed and even if using "cellwidth=0.14 cm" option in the define statement the document result in a far wider column.

Do you know if it is possible to reproduce the old output?

Many thanks,
Gianlu

Re: 9.2 to 9.4 width of report column

RW9 — Wed, 07 Dec 2016 09:23:12 GMT

Well, we have old programs and it shouldn't make any difference going from 9.x to 9.4, we use RTF all the time and its the same (at least from memory 9.3-9.4). Especially if you put cellwidth in your proc report as that overrides any stylesheet you might use. Are you sure there is not something else going on? Maybe your template is not being found and it defaults to rtf or another one? Check the log, also check you have put:

style={cellwidth=1.4cm};

in your proc report on the correct variables. Cellwidth 0.14cm seems very small for a column width, you would barely be able to get one character in that.

Re: 9.2 to 9.4 width of report column

scan — Wed, 07 Dec 2016 09:35:23 GMT

Dear RW9 thank you very much for your answer.

Unfortunately the cellwidth is correct. That column was kind of a separator in a table, it only contains some ";" in some cases.

We found that this was the best solution to adopt in this case and this kinda became a standard.

The template is good, the program run fine, it always worked and still working on 9.2.

The problem is only that the proc report on 9.4 don't accept this width.

Re: 9.2 to 9.4 width of report column

RW9 — Wed, 07 Dec 2016 09:41:19 GMT

If indeed what you say is correct, then your only option is to speak to SAS Helpdesk.

Re: 9.2 to 9.4 width of report column

ballardw — Wed, 07 Dec 2016 16:01:10 GMT

How much is "far wider"?

What is the declared length of the variable displayed? Possibly you have some value that is attempting to place more characters than will fit into the specified width and a behavior for resolving that conflict has changed.

You may also want to look into the STYLE in effect. Even if the name hasn't change sometimes the actual style definition changes in places that may cause odd things (lesson learned between 9.1 and 9.2 )