topic Re: SAS, to combine value of Column with Enter Key in SAS Programming

SAS, to combine value of Column with Enter Key

mmkr — Thu, 13 Jun 2024 14:49:22 GMT

I am trying to combine two columns and add a enter or next line the values , can you help me ?

data test;
x="himom";
y="hidad";
;
run;

data want;
set test ;
length D $50 ;
d = catx('0D0A'x,x,y);
run;

proc print data=want;run;

Result i want :

newcolumn

-----------

himom

hidad

Re: SAS, to combine value of Column with Enter Key

ballardw — Thu, 13 Jun 2024 14:55:17 GMT

Where do you expect this to appear? It might be possible for some ODS destinations but it may be that the approach is different for different file types.

And basically isn't going to appear in a data set view.

Re: SAS, to combine value of Column with Enter Key

mkeintz — Thu, 13 Jun 2024 15:01:10 GMT

I don't think there is a way for PROC PRINT to honor linefeed/carriage returns within the value of a single Cell.

I wonder if there are any PROC REPORT honchos seeing this question can provide a solution.

Re: SAS, to combine value of Column with Enter Key

mmkr — Thu, 13 Jun 2024 15:09:34 GMT

in Proc report i would like to sipaly

Re: SAS, to combine value of Column with Enter Key

Tom — Thu, 13 Jun 2024 15:34:19 GMT

ENTER is a KEY, not a CHARACTER. I suppose the character you might want is a LINEFEED, '0A'x, or CARRIAGE RETURN, '0D'x.

But you are probably better off inserting something that PROC REPORT will recognize as a line break.

See this thread for example. https://communities.sas.com/t5/SAS-Procedures/Multiple-lines-in-a-PROC-REPORT-cell/td-p/312811