Desktop productivity for business analysts and programmers

Convert Delimited Column

Reply
N/A
Posts: 0

Convert Delimited Column

All,

I have 10 columns in an audit table and one of this files has 3 pieces of description data that is seperated by semicolons. I need to break out the entire table into 12 columns. Being a very novice SAS EG User I am stuck.

Any help, ideas would be appreciated.

Many thanks

Matt C.
Esteemed Advisor
Posts: 5,194

Re: Convert Delimited Column

You could use the filter and query task, and there define three new calculated columns, using the scan function (documentation for syntax).

/Linus
Data never sleeps
N/A
Posts: 0

Re: Convert Delimited Column

That did the trick. Many thanks.
Ask a Question
Discussion stats
  • 2 replies
  • 63 views
  • 0 likes
  • 2 in conversation