Desktop productivity for business analysts and programmers

Convert Delimited Column

Not applicable
Posts: 0

Convert Delimited Column


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.
Super User
Posts: 5,917

Re: Convert Delimited Column

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

Data never sleeps
Not applicable
Posts: 0

Re: Convert Delimited Column

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