The SAS Output Delivery System and reporting techniques

9.2 to 9.4 width of report column

Reply
Contributor
Posts: 25

9.2 to 9.4 width of report column

[ Edited ]

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

Super User
Super User
Posts: 7,682

Re: 9.2 to 9.4 width of report column

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.

Contributor
Posts: 25

Re: 9.2 to 9.4 width of report column

[ Edited ]

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.

Super User
Super User
Posts: 7,682

Re: 9.2 to 9.4 width of report column

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

Super User
Posts: 11,105

Re: 9.2 to 9.4 width of report column

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 )

Ask a Question
Discussion stats
  • 4 replies
  • 222 views
  • 0 likes
  • 3 in conversation