SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Problem reading CSV-file in DI Studio (different problem)

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

Problem reading CSV-file in DI Studio (different problem)

I need to read a CSV-file into a DI Studio job. I've registered it as an External File object, and controlled that all the columns and values look fine when I select "Open as a table" in DI Studio. The File Reader transformation causes problems, however. If I *only* map the character columns, File Reader works perfectly, but once I include any of the numeric columns it fails.

Here's the column settings from the File Reader (mapped directly from the External File object):

Once I've run the File Reader and try to open the output table, the column "1980" produces the following errors:

The values for "1980" in the CSV-file are ordinary numbers, and I've sorted them to check that there's no whitespace/blank values. Example:

Can anyone please help me understand the cause of the errors?


Accepted Solutions
Solution
‎10-03-2013 07:48 AM
Super User
Posts: 5,254

Re: Problem reading CSV-file in DI Studio (different problem)

First, add informat and format to your numerical column.

And, since your column doesn't comply with SAS naming conventions, you need either map to another name, or have SAS using the n literal, it's a tick option in DIS.

Data never sleeps

View solution in original post


All Replies
Solution
‎10-03-2013 07:48 AM
Super User
Posts: 5,254

Re: Problem reading CSV-file in DI Studio (different problem)

First, add informat and format to your numerical column.

And, since your column doesn't comply with SAS naming conventions, you need either map to another name, or have SAS using the n literal, it's a tick option in DIS.

Data never sleeps
Frequent Contributor
Posts: 89

Re: Problem reading CSV-file in DI Studio (different problem)

Thank you very much for the advice. Smiley Happy

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 648 views
  • 0 likes
  • 2 in conversation