Hi RW9,
Thank you for help!
I've adjusted some of the code that give me the correct output:
data x;
infile cards dlm="," ;
input product_ID : $20. NAME : $60. ;
cards;
ID1,NAME1
ID1,NAME2
ID1,NAME3
ID2,NAME4
ID3,NAME5
ID3,NAME6
ID4,NAME7
ID5,NAME8
ID6,NAME9
ID7,NAME10
;
run;
data have;
length temp $ 1024;
set x;
by product_id;
if first.product_id then temp='';
retain temp;
temp = catx("^{newline}", temp, catx(" ", "^{unicode 25cf}",NAME) );
if last.product_id then output;
run;
ods escapechar="^";
proc report data=have nowd OUT=have2 split="/";
column product_id temp;
define product_id / display;
define temp / display;
run;
But now I'm struggling to export the ODS output to Excel, since the bullet points are now exported into different rows and not into one row, is there any way around this?
Thank you!
... View more
