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

[EinarRoed]

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?

[LinusH · Accepted solution]

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.

[EinarRoed]

Thank you very much for the advice.