Help using Base SAS procedures

Trouble with PROC IMPORT (csv-file)

Reply
Frequent Contributor
Posts: 89

Trouble with PROC IMPORT (csv-file)

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.

Super Contributor
Posts: 349

Re: Trouble with PROC IMPORT (csv-file)

Hi,

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

Thanks,

Shiva

Ask a Question
Discussion stats
  • 1 reply
  • 277 views
  • 3 likes
  • 2 in conversation