SAS version of Oracles LISTAGG function

[OscarBoots1]

Hi,

I wonder if anyone has an answer to Oracles LISTAGG function for SAS?

I'm using base SAS programming 7.1 & need some examples if anyone can help.

I've seen some examples using the 'BY' process.

Does anyone have any clear examples?

Thanks

[ChrisNZ · Accepted solution]

SAS doesn't have summary functions for strings, sadly.

So you'll have to code it. For example:

data CLASS (index=(SEX));
  set SASHELP.CLASS;
run;
data T;
  length NAMES $200;
  retain NAMES;
  set CLASS;
  by SEX;
  if first.SEX then NAMES='';
  NAMES=catx(',',NAMES, NAME) ;
  if last.SEX then putlog NAMES=;
run;

NAMES=Alice,Barbara,Carol,Jane,Janet,Joyce,Judy,Louise,Mary

NAMES=Alfred,Henry,James,Jeffrey,John,Philip,Robert,Ronald,Thomas,William