To get distinct varibale values, you may try the simple code: Proc sql;      select distinct var1,var2,var3,var4,var5,var6      from dset1      where condt1; quit; ... View more

I'd like to point out that apparently this problem is resolved completely in Sql server, as it can join on millions of rows of data, of the varchar type with lengths > 2,000 in a manner of seconds. As thus, I went through and created a stored proc to do this, transferred my data to sql server and completed the task there. Thanks everyone for the help and advice however! ... View more

Hi, Try the below code: data table;      set table;      by customer_id product_id; run; data table2;      set table;      by customer_id product_id;      if first.customer_id then final_product = product_id;      else do;           retain final_product;           final_product = catx(',',final_product,product_id);      end;      if last.customer_id; run; ... Chandra ... View more

Thank you Cynthia for your advise, You are right I am using ODS TAGSETS.RTF instead of ODS RTF, will contact the Tech Support team. Thanks, Chandra ... View more