topic Re: Import text file into SAS in SAS Programming

Import text file into SAS

Emma8 — Thu, 11 Jun 2020 08:30:59 GMT

Hi. I have a text file (delimiter=“~”) with about million observations and 500 variables (variables names are invalid SAS names).
The text file contain open and closed quotes, decimal in string. How can I import? Thank you.

Re: Import text file into SAS

Kurt_Bremser — Thu, 11 Jun 2020 08:39:09 GMT

In the data step, use

dlm="~" dsd firstobs=2 truncover

in the INFILE statement.

If there is a pattern to the variable names, use a macro to reduce your code.

Re: Import text file into SAS

Emma8 — Thu, 11 Jun 2020 08:49:22 GMT

Thank you.
Does not help it though

Re: Import text file into SAS

ballardw — Thu, 11 Jun 2020 14:52:57 GMT

"Does not help" is awful vague.

Are there errors in the log?: Post the code and log in a code box opened with the <> to maintain formatting of error messages.

No output? Post any log in a code box.

Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the <> icon or attached as text to show exactly what you have and that we can test code against.

You should as an absolute minimum show the code, or the generated code, you attempted.

The options @Kurt_Bremser apply to reading a data set with a data step. If you are attempting to use Proc Import then show us.

Re: Import text file into SAS

smantha — Thu, 11 Jun 2020 15:41:50 GMT

did you try the import wizard by giving it a custom delimiter and see what code it generates. The code BallardW posted should work. Please provide your code and logs as suggested.

Re: Import text file into SAS

Emma8 — Thu, 11 Jun 2020 17:35:21 GMT

It was
Rule:
—-+— etc.
Invalid data for ...
I tried to fix by infile recfm=n

But I it does not fix.
I think data contain open or closed quotes and varying length width.

Thank you!

Re: Import text file into SAS

Emma8 — Tue, 16 Jun 2020 01:10:27 GMT

Re: Import text file into SAS

Tom — Thu, 11 Jun 2020 21:57:43 GMT

Is the delimiter a comma or a tilde? Your posted code is trying to use comma as the delimiter. If you want to tell PROC IMPORT to use tilde as the delimiter then add this statement to the proc import step.

dlm='~';