topic Re: Wrapping of flyover text in ODS EXCEL in ODS and Base Reporting

Wrapping of flyover text in ODS EXCEL

VikrantSawatkar — Fri, 09 Jun 2017 15:39:59 GMT

Hi All,

I have a dataset in which one particular column has the values like below

and I want to generate an excel report in which these values from the said column should look like below.

Could you please help me here. Many thanks in advance.

Regards,

Vikrant Sawatkar

Re: Wrapping of flyover text in ODS EXCEL

Reeza — Fri, 09 Jun 2017 15:45:12 GMT

Flyover text is text that shows up when you hover over the cell, ie Excel Comments. Is that what you're trying to modify here or the value in the cells?

I'm not understanding your subject with how you've phrased the question.

If you're modifying values in the cell, see the answers here:

https://communities.sas.com/t5/SAS-Text-and-Content-Analytics/Creating-a-carriage-return/m-p/340125/highlight/true#M552

Re: Wrapping of text in ODS EXCEL

VikrantSawatkar — Fri, 09 Jun 2017 15:58:54 GMT

Hi,

Sorry for the confusion.

I want to modify the values in the cells. So that when the report is gets created, the values are displayed as per the screenshot above.

I am using SAS 9.2.

Re: Wrapping of text in ODS EXCEL

Reeza — Fri, 09 Jun 2017 16:13:48 GMT

Ok, did the solution in the link not work for you?

You put the '0d0a'x (see below) in the location where you want a carriage return. When you export to Excel it should resolve as the carriage return. You're likely exporting to an XLS file so how you export is different but I suspect everything else is the same. If this does not work, post your code, log and a screenshot of your results.

'0d0a'x

Re: Wrapping of flyover text in ODS EXCEL

Ksharp — Sat, 10 Jun 2017 03:40:51 GMT

Use ~n as your return characters.

Firstly, change your text into as :

This......follow ~n

(1)................. ~n

(2)...................~n

Then, output it into a excel file.

ods escapechar='~';

ods excel file='......';

proc report......

ods excel close;

Re: Wrapping of flyover text in ODS EXCEL

Reeza — Sat, 10 Jun 2017 03:41:53 GMT

@Ksharp SAS 9.2 definitely does not have ODS Excel.

Re: Wrapping of flyover text in ODS EXCEL

Ksharp — Sat, 10 Jun 2017 03:52:22 GMT

Opps, then try

ods tagsets.excelxp ............