Hi, I am frustrated after many tries and failing to concatinate multiple text variables into a long text string. Lets assume that the text segments are PRIMEKEY in the data set PERSON_FILE (var1 var2 primekey var4 var5). lets assume PRIMEKEY values are '123abc'  '456fdc'  '985liu'...... The desired result is a single string: '123abc','456fdc','985liu','...... : I've tried 2 approaces which failed me: approach 1:   DATA   RECKEYS (KEEP=SAMPLKEY);                                                                        SET    PERSON_FILE END=EOD;                                           IF PRIMEKEY NOT EQ ' ' THEN DO;                                        IF _N_ EQ 1 THEN SAMPLKEY="'"||PRIMEKEY||"'";         ELSE SAMPLKEY=SAMPLKEY||",'"||PRIMEKEY||"'";                              END;                                                IF _N_ GT &SAMPLE_SIZE OR EOD THEN DO;                                    OUTPUT; STOP;                END;                                                             RUN;                                                             The second approach that I cant make work is: PROC SORT  DATA=PERSON_FILE NODUPKEY; BY PRIMEKEY; RUN;   PROC SQL;                               SELECT DISTINCT "'"||SAMPLKEY||"'"      INTO :RECKEY SEPARATED BY ','        FROM KEYS;                      QUIT; RUN;                                                               TITLE 'RECKEY STRING';               PROC PRINT DATA=RECKEYS; RUN &DEBUG; ... View more