Trouble with PROC IMPORT (csv-file)

[TurnTheBacon]

I have a CSV-file that I need to import into DI Studio. I've set up a transformation with this user written code:

proc import

  file='foldername/filname.csv'

  out=&_OUTPUT. replace;

  getnames=yes;

quit;

As you can see, getnames is set to "yes". I should also mention that the first row of the CSV-file contains column headers.

The job runs without any warnings or errors, but when I attempt to open the output table, it tells me "Error accessing metadata: Table has no columns".

How can I remedy this?

Thanks for your time.

[shivas]

Hi,

I guess you might have not registered the out=&output dataset in metadata...try registering the output dataset.

Thanks,

Shiva