Hi, I'm using SAS 9.4 and when I run PROC SQL statements (without the NOPRINT option), the results will display in a new window in SAS that is named "Results Viewer". The column heading is in a slightly darker blue box with a border and bold, blue text. The values for the column are in a white box with a border and non-bold, black text. I refer to the white box as the "column values box". If I have two sentences (or more) that I want to concatenate together with a newline character, then use it in a PROC SQL statement so it will display in the Results Viewer (with the assigned column name, then the column value with multiple lines), is that possible? I have tried a number of things. The "dummyTable" in an actual dummy table in the database, so nothing is actually being pulled from the table (in case that wasn't clear). 1. Code: %cr = %input('0D0A', $hex2.);
%let test = 'This is line #1.' || &cr. || 'This is line #2.';
proc sql;
select
&test. as test1
from
dummyTable
;
quit; Results: test1 -------------------------------------------- This is line #1. This is line #2. 2. Code: %let test = %sysfunc(catx('0D0A'x, "This is line #1.", "This is line #2."));
proc sql;
select
&test. as test1
from
dummyTable
;
quit; Results (strange): This is line #2. <--- Not sure why this is the column header instead of "test1". -------------------------------------------- This is line #1. 3. Code: %let test = %sysfunc(cats("This is line #1.", %sysfunc(byte(13)), "This is line #2."));
proc sql;
select
&test. as test1
from
dummyTable
;
quit; Results: test1 -------------------------------------------- This is line #1. "This is line #2. <--- Not sure why the double quote is appearing before the second 'This'. My expected results are (the two sentences would be in the same "column value box" instead of having a separate "column value box" for each sentence): test1 -------------------------------------------- This is line#1. This is line #2. For the project I'm working on, I cannot use a data set to store multiple lines to multiple rows because I'm limited to one row of output but the row of values can be multiple lines long. I've been storing the sentences in macro variables and trying to concatenate them, but I used the sentences in the examples above to simplify my question. Thanks!
... View more