inputing a file with different delimiters

Rups_b — Thu, 17 Dec 2020 17:05:09 GMT

How can I read these two files with several types of delimiters?

Re: inputing a file with different delimiters

ballardw — Thu, 17 Dec 2020 17:21:29 GMT

The DLM option on an infile statement will take multiple characters.

However every time any of those characters are encountered it will be treated as a delimiter. So if those characters have any other use in some place in the file you need to be very explicit about parsing rules.

data example;
   infile datalines dlm="~/\|&:-*=,_'";
   informat id $5. Name $10. value best10.;
   input id name value;
datalines;
101~lily\5000
102&jasmine|3000
103:rose/7000
101-lily*5000
102=jasmine,3000
103_rose'7000
;

If someone has both single and double quotes the ' and " as delimiters then you are going to need the DLM string to use the "enter two quotes to be used as one" that is very old school coding:

dlm="~/\|&:-*=,_'"""

Please, for just a few lines of text copy and paste into a text box opened on the forum with the </>.

Note: Anybody sending me a file with that kind of "delimiters" is likely to be met with severe disapproval.

Re: inputing a file with different delimiters

Rups_b — Thu, 17 Dec 2020 17:22:02 GMT

Thank you. I will surely remember that.

topic Re: inputing a file with different delimiters in New SAS User

inputing a file with different delimiters

Re: inputing a file with different delimiters

Re: inputing a file with different delimiters