Trouble with PROC IMPORT (csv-file)

TurnTheBacon — Wed, 26 Sep 2012 08:34:41 GMT

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.

Re: Trouble with PROC IMPORT (csv-file)

shivas — Wed, 26 Sep 2012 09:05:37 GMT

Hi,

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

Thanks,

Shiva

topic Re: Trouble with PROC IMPORT (csv-file) in SAS Procedures

Trouble with PROC IMPORT (csv-file)

Re: Trouble with PROC IMPORT (csv-file)