Attached is a sample. Column A is what I get. I would like to convert that to Columns B, C, D, E, ... It's easy to do in excel (Date - Text to columns) so I'm sure I'm just being blind in SAS EG.
... View more
No. I'm just a novice here and I don't see how or where I can do this in enterprise guide. A previous post suggest the SCAN function but again, not sure how. Could use some examples.
... View more
I receive an excel file where one of the variables contains multiple coded entries with many different delimiters. Example: cell contains NV1,NV2 NV5 & NV7;NV4. How can I account for every delimiter and parse that one cell into many?
... View more