topic Re: labels in New SAS User

labels

Tecla1 — Mon, 25 Nov 2024 09:59:01 GMT

Good morning,

I need to insert a label with a line breack, is possible? I have to replicate an export in Excel with column headers that contain newlines like this:

"Matr.
S.I."

Please can you help me? I tried but in any case in te export results without a line breack....

many thanks to all.

Re: labels

sbxkoenk — Mon, 25 Nov 2024 10:19:50 GMT

Need to insert line break in Excel using PROC EXPORT

https://communities.sas.com/t5/SAS-Programming/Need-to-insert-line-break-in-Excel-using-PROC-EXPORT/td-p/909531

Re: labels

Patrick — Mon, 25 Nov 2024 10:24:15 GMT

Below one option.

data work.have;
  col1='ABC';
  col2=123;
run;

ods excel file="c:\temp\yourfile.xlsx";

%let lbl=Matr.%sysfunc(inputc(0A,hex.))S.I.;
proc print data=have label;
  label col1="&lbl";
run;

ods excel close;

Re: labels

Tecla1 — Mon, 25 Nov 2024 10:37:13 GMT

Thanks everyone, I received great help!! I'll try the solutions right away !!! have a nice dat: Tecla

Re: labels

Tecla1 — Tue, 26 Nov 2024 10:06:49 GMT

Good morning everyone, I have verified your solution for which I thank you, but I have a problem: if the width of the excel cell is sufficiently wide the text dos not wrap. I need an action equal the excel comand "ALT + ENTER" to insert a line break, is it possible? It's very important for me... otherwise I'll have to reorganize a rather large DB.... Tnks!!

Re: labels

PaigeMiller — Tue, 26 Nov 2024 13:54:55 GMT

How are you creating an Excel file? Please show us the code.

If you are using PROC REPORT or PROC PRINT, there is the SPLIT= option which causes line breaks exactly where you want them to be. To have the text wrapped, there is also the FLOW= option in ODS EXCEL and the option in ODS EXCEL tagattr='wraptext:yes'

So to modify @Patrick 's code to use the SPLIT= option

ods excel file="c:\temp\yourfile.xlsx";

proc print data=have label split='~';
  label col1="Matr.~S.I";
run;

ods excel close;

Re: labels

Tecla1 — Tue, 26 Nov 2024 14:16:41 GMT

Many Tnks I regeived a big help !!! I think I have tu study very mach now !! SaS Community is the best!

Re: labels

Tecla1 — Tue, 26 Nov 2024 14:17:45 GMT

Excuse for mistake ... I need to sleep...