Hello, I am trying to convert R code to SAS using Proc SQL, The function concat and collectlist could not be located. I need help in finding an alternative function or code for this R code in SAS. example: variable: XXXX-XXXXX XXX, XXX-XXXX-XXXX, XXXXX, NULL, (blanks) ETC VARIABLE 2: example: ( i think length is 12, i cant check since its million records) XX0000X25X82 XX9001402331 XXX3XX3I01X8 Given R code: /*concat_ws(',', COLLECT_LIST(distinct coalesce(variable,'')) ) as var1, */ //*concat_ws(',', COLLECT_LIST(distinct substr(coalesce(variable2,'99'),1,2)) ) as var2,*/ Need SAS code: Thanks for checking
... View more