topic Re: Is it possible to create / split a label in two lines in SAS Enterprise Guide

Is it possible to create / split a label in two lines

alepage — Fri, 26 May 2023 15:14:56 GMT

Hello,

I am using the attrib, label, length, format and informat statement to create a data model

Is there a way to get the label in two lines

ex: Written Premium - Previous Year

for Written Premium

Previous Year

Here's the basic code

The split did not work

libname temp %sysfunc(quote(%sysfunc(pathname(work))));

data temp.model ;
   attrib GENRE 	label="Genre" length=8 format=8. informat=8.
    	  TYPE3 	label="Type3" length=8 format=8. informat=8.
          WP 		label="Written Premium" length=8 format=8. informat=8.
		  SEMOSPC 	label="Written Premium ||'0D'x|| Previous Year" length=8 format=8. informat=8.
;
run

Re: Is it possible to create / split a label in two lines

Reeza — Fri, 26 May 2023 15:22:51 GMT

Depends, where do you want to see the split? Within a SAS data set - not really. Within an output/printed output like RTF/PDF/Excel doc, then yes, you can split things. Can you provide more details about what you're trying to accomplish?

Re: Is it possible to create / split a label in two lines

alepage — Fri, 26 May 2023 15:27:29 GMT

I was looking for a solution with sas dataset

Re: Is it possible to create / split a label in two lines

Tom — Fri, 26 May 2023 16:09:23 GMT

@alepage wrote:
I was looking for a solution with sas dataset

Since there is no concept of "lines" in the label of a variable you can just use whatever character you want to indicate the location of the logic split into "lines". You might use | or / or * for example.

You might want to pick one that works with other procedures. Such as the SPLIT= option of PROC PRINT.

Re: Is it possible to create / split a label in two lines

Reeza — Fri, 26 May 2023 16:15:15 GMT

Out of curiousity, why? What would be the purpose for the label in the data set to have a split? You want to see it in viewer?

Re: Is it possible to create / split a label in two lines

alepage — Mon, 29 May 2023 18:02:34 GMT

It is because, sometime the dataset label is to long. Ex: Written Premium - Previous Year.

I would prefer to get:

Witten Premium

Previous Year

Re: Is it possible to create / split a label in two lines

Cynthia_sas — Mon, 29 May 2023 18:14:55 GMT

Hi: But where would you be able to see that it was too long? In a report? In the data viewer? In the results of a statistical procedure? In the output of a graph procedure? You don't "see" inside the SAS dataset when it is stored, and not being actively used.
Inside the SAS dataset, when the labels are stored in the descriptor portion of the data, there is no concept of "lines" or line feeds or carriage returns. The label is stored as a piece of "descriptor" information about the column. You only "see" that label when the label is used to produce output or when the label is used in a table viewer.
Cynthia