As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

Tips:Text Indentation and Forced Linefeed (Carriage Return) with the ExcelXP Tagset

From sasCommunity
Jump to: navigation, search

It is possible to indent text and to force a carriage return when using the ExcelXP Tagset.

To force the linefeed, concatenate the text string into your data value. This will work, as long as the PROTECTSPECIALCHARS=OFF style option is enabled. To indent text, concatenate 'A0A0A0A0'x into your data value:

data try;
    patchar = catt('mean', '
', 'std');
    patchar = catt('A0A0A0A0'x, '|indented|');

For the full details

....see also

Submitted By Otterm1