Lines Wrapping in ODS Excel

[AshWynn87]

Hello there.

I'm attempting to export an excel file with 3 sheets. There is a dataset that applies to each sheet as you can see below. The problem is that I'm getting word wrapping in the data. It doesn't happen in all cells, but it does in most. I've tried flow='data' in the options but SAS doesn't recognize it. How can I get this random word wrapping to stop?

[ballardw]

Did you try removing the absolute_column_width or using NONE instead of setting to 9.

When you try to put more text than might fit I suspect that word wrap gets turned on.

[AshWynn87]

I did try that to no avail.

[ChrisNZ]

Does your data contain carriage returns? Where does it come from? Do you need to clean it?

[AshWynn87]

I've already cleaned the data. There's no distinct reason it should be wrapping.

[ballardw]

---

@AshWynn87 wrote:

I've already cleaned the data. There's no distinct reason it should be wrapping.

---

Can you provide some example data that duplicates this behavior in the form of a data step? This is very likely somewhat data dependent and without data we are kind of flying blind.

Replace any sensitive values with characters strings of the same length or random numbers of a similar range of digits.

Test the example data to show that the behavior is similar.

Likely we only need 5 or 10  rows of data as examples.

If you need help creating data step of your data Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

[AshWynn87 · Accepted solution]

I ended up fixing it with an alternative method. Thanks everyone!

[ChrisNZ]

@AshWynn87  Can you explain so others benefit from your findings?

[AshWynn87]

I used the same ods excel code in the initial post. I changed the code for assigning the variable by putting strip() around both vars included instead of around the whole thing.

Here's the code for assigning a variable, in this case varname RE_1:

Here's the corresponding output for said variable:

[ChrisNZ]

It looks like your data wasn't so clean after all and you should have applied the function compbl().