CSV Import problem

ThomasH — Fri, 31 Oct 2008 12:41:41 GMT

Dear forum members,

I've got another problem here I cannot handle.

I am trying to read a CSV file into a dataset with all input data being alphanumeric. It works pefectly like this:

Data &_output.;
infile "&STGPfad/&_infile" delimiter=';' firstobs=2;
informat default=$1024.;
input (fld1-fld&nr) ($);
Run;

When it comes to a CSV row like

3;4;5;6;7;;8;9

the missing value is not taken as "." but the "8" is taken from the next field and so on, which is...well..wrong.

So I tried "MISSOVER" in the INFILE statement, but still it doesn't work.

Any other ideas would help me a lot.

Thanks and regarsd,
Thomas

Re: CSV Import problem

sbb — Fri, 31 Oct 2008 12:43:49 GMT

Add the DSD parameter to the INFILE statement.

Scott Barry
SBBWorks, Inc.

Re: CSV Import problem

ThomasH — Mon, 03 Nov 2008 14:11:50 GMT

That helped, thanks! I was trying with DSD and MISSOVER in parallel, which screwed it up even more 😉

Thomas

topic Re: CSV Import problem in SAS Programming

CSV Import problem

Re: CSV Import problem

Re: CSV Import problem