https://communities.sas.com/t5/ODS-and-Base-Reporting/Comma-Separated-List/m-p/4800#M1936 Looks like "Scan(__value_list__, __entry__, __delimiter__)" is what i require. Sun, 23 Sep 2007 23:03:54 GMT deleted_user 2007-09-23T23:03:54Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Comma-Separated-List/m-p/4799#M1935 Is there any way to get an entry out of a Comma Separated list?<BR /> <BR /> I have a Table which stores data as follows:<BR /> <BR /> PRODUCT_ID| DIMENSIONS<BR /> --------------------| --------------------------<BR /> 10000000000 | L 200 X W 200 X D 200 mm<BR /> 10000000001 | L 300 X W 150 X D 250 mm<BR /> etc etc..<BR /> <BR /> I need to calculate the volume (L x W x D), so i need to grab each entry out of the "DIMENSIONS" field (Entry 2, Entry 5, Entry <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span> Based on the Delimiter of " ".<BR /> <BR /> Is there a function available to extract this?<BR /> <BR /> Any help would be appreciated. Sun, 23 Sep 2007 22:38:34 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Comma-Separated-List/m-p/4799#M1935 deleted_user 2007-09-23T22:38:34Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Comma-Separated-List/m-p/4800#M1936 Looks like "Scan(__value_list__, __entry__, __delimiter__)" is what i require. Sun, 23 Sep 2007 23:03:54 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Comma-Separated-List/m-p/4800#M1936 deleted_user 2007-09-23T23:03:54Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Comma-Separated-List/m-p/4801#M1937 here's some usage on the SCAN function .... <BR /> <A href="http://www2.sas.com/proceedings/sugi30/233-30.pdf" target="_blank">http://www2.sas.com/proceedings/sugi30/233-30.pdf</A> Tue, 02 Oct 2007 19:51:01 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Comma-Separated-List/m-p/4801#M1937 deleted_user 2007-10-02T19:51:01Z