Ronnie Overby
Ronnie Overby

Reputation: 46470

Delimiting Character

We are loading a Fixed width text file into a SAS dataset.

The character we are using to delimit multi valued field values is being interpreted as 2 characters by SAS. This breaks things, because the fields are of a fixed width.

We can use characters that appear on the keyboard, but obviously this isn't as safe, because our data could actually contain those characters.

The character we would like to use is '§'.

I'm guessing this may be an encoding issue, but don't know what to do about it.

Upvotes: 1

Views: 231

Answers (1)

Scott
Scott

Reputation: 107

Could you use the keycode for the character like DLM='09'x and change 09 to the right keycode?

Upvotes: 2

Related Questions