BookmarkSubscribeRSS Feed
scan
Obsidian | Level 7

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

4 REPLIES 4
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

scan
Obsidian | Level 7

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.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

ballardw
Super User

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 )

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1179 views
  • 0 likes
  • 3 in conversation