topic Re: How to import csv files including the SUB character (ASCII=26)? in SAS Programming

How to import csv files including the SUB character (ASCII=26)?

user_ — Mon, 22 May 2017 07:56:25 GMT

I would like to import many big csv files in SAS and some of them include the SUB character (ASCII=26). When SAS reaches this character, it stops processing and reports a success.

I am able to remove this character using powershell and then I can correctly import the files in SAS. However, running the powershell code all the files is not efficient.

Is there a way to fix this problem in SAS, for example to tell SAS to not stop importing when it reaches this character?

Any help would be appreciated.

Re: How to import csv files including the SUB character (ASCII=26)?

RW9 — Mon, 22 May 2017 08:16:13 GMT

1) Why does your data have this in the first place?

2) What code are you using to read it in?

3) Perhaps a small example file showing the issue?

Likely you should just be able to add the option: ignoredoseof

To your filename statement. But you may just have have to be more creative, depending on the actual character.

Re: How to import csv files including the SUB character (ASCII=26)?

Kurt_Bremser — Mon, 22 May 2017 08:18:33 GMT

Try the

IGNOREDOSEOF

option, as mentioned in INFILE Statement: Windows in the Companion for Windows.