The SAS Output Delivery System and reporting techniques

Comma Separated List

Reply
N/A
Posts: 0

Comma Separated List

Is there any way to get an entry out of a Comma Separated list?

I have a Table which stores data as follows:

PRODUCT_ID| DIMENSIONS
--------------------| --------------------------
10000000000 | L 200 X W 200 X D 200 mm
10000000001 | L 300 X W 150 X D 250 mm
etc etc..

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 8) Based on the Delimiter of " ".

Is there a function available to extract this?

Any help would be appreciated.
N/A
Posts: 0

Re: Comma Separated List

Looks like "Scan(__value_list__, __entry__, __delimiter__)" is what i require.
N/A
Posts: 0

Re: Comma Separated List

here's some usage on the SCAN function ....
http://www2.sas.com/proceedings/sugi30/233-30.pdf
Ask a Question
Discussion stats
  • 2 replies
  • 132 views
  • 0 likes
  • 1 in conversation