topic Re: Problem to import txt data into SAS in SAS Programming

Problem to import txt data into SAS

Ronein — Tue, 26 Jun 2018 06:33:11 GMT

Hello friends

I have a problem.

I am using tera data query in order to create a table that contains 3318 rows.

I am exporting the table to a txt file.

Then I am using in SAS: File--Import data and I get only 3281 rows.

As you can see number of rows is not matched to original table.

I checked what happened and found that some rows values are located in specific field.

What do you suggest in order to solve this problem please?

Re: Problem to import txt data into SAS

andreas_lds — Tue, 26 Jun 2018 07:22:20 GMT

You have to post code and log, so that we see what actually happened.

Re: Problem to import txt data into SAS

RW9 — Tue, 26 Jun 2018 08:00:59 GMT

How are you exporting the data, and to what format. If you export a CSV file, and your data contains commas, then you will obviously have issues. In these cases you can either enclose the data with commas in double quotes so the reader knows to read the whole block without delimeters, or you can switch to a delimeter that is not in your data, for example a pipe. How you do this in teradata, well there should be an option at export to specify the delimiter.

If of course its not the above then post some actual information about your problem, otherwise we are just guessing.