topic SAS Data Set LABEL and linebreak in SAS Enterprise Guide

SAS Data Set LABEL and linebreak

metallon — Thu, 29 Jan 2015 15:48:29 GMT

Hi,

is there a way to do a linebreak for a long custom LABEL name for a sas data set variable?

Thanks

Re: SAS Data Set LABEL and linebreak

ballardw — Thu, 29 Jan 2015 15:52:37 GMT

Where to expect to see the linebreak take effect? SAS output such as proc contents, the explorer window or elsewhere?

Re: SAS Data Set LABEL and linebreak

Tom — Fri, 30 Jan 2015 04:04:37 GMT

That is what the SPLIT= option on PROC PRINT is designed for.

SPLIT='split-character'

specifies the split character, which controls line breaks in column headings. It also uses labels as column headings. PROC PRINT breaks a column heading when it reaches the split character and continues the header on the next line. The split character is not part of the column heading although each occurrence of the split character counts toward the 256-character maximum for a label.

Alias:	S=
Interaction:	You do not need to use both LABEL and SPLIT= because SPLIT= implies the use of labels.
Interaction:	The OBS= option honors the split character. (See the discussion of OBS=.)
Featured in:	Customizing Text in Column Headings

Note: PROC PRINT does not split labels of BY variables in the heading preceding each BY group even if you specify SPLIT=. Instead, PROC PRINT replaces the split character with a blank.

Re: SAS Data Set LABEL and linebreak

metallon — Fri, 30 Jan 2015 09:30:04 GMT

Awesome! Thats what I needed!

Re: SAS Data Set LABEL and linebreak

Peter_L — Thu, 19 Feb 2015 12:26:36 GMT

Another possibility, which is useful only if you are sending ODS output to HTML, is to add a soft hyphen character. This causes the browser dynamically to break the word at the hyphen if the available space is narrow, in the same way as it does with a space.

Example:

%let HY=^{unicode 00AD};
SQL fragment: Quality label="Qual&HY.ity",

Notice the dot to end the macro variable reference.