Hello, here is my first post in the community hoping to get some help. I have a large SAS dataset with a character field that i'd like to clean up by using a set of 2 delimiters. for instance, my data has a string variable with observations like: jkdfldfd-abc--123 dkjfds789-cdegfd--abc1 asddkj--dmco-hwrfd .... .... I am trying to find a way to create a new variable that cuts off at the double '--' dash delimiter and not at the single '-' dash. I read somewhere that Scan function does not support multiple delimiters and some have suggested alternatives using infile statement. The infile approach is not efficient in my case since the data is already in SAS format and as I said it's a large dataset with many fields. Is there another alternative that you can suggest? Many thanks in advance for your help!
... View more
