topic Reading specific field from .csv file in SAS Programming

Reading specific field from .csv file

Zelazny7 — Thu, 13 Jan 2011 15:56:39 GMT

Is there a way to read in one specific field from a .csv file? I have a file that is compressed with gzip so I have to use a standard datastep to access it. I can't use proc import. There are several hundred fields and I only need fields 137 - 142.

Re: Reading specific field from .csv file

data_null__ — Thu, 13 Jan 2011 16:18:48 GMT

Yes, you can use a data step similar to this one.

[pre]
data skip4fields;
infile cards dsd;
input (4*d)(:$1.) f5 f6;
drop d;
cards;
1,2,3,4,5,6,7
1,2,3,4,5,6,7
;;;;
run;
proc print;
run;
[/pre]

Re: Reading specific field from .csv file

Zelazny7 — Thu, 13 Jan 2011 16:53:38 GMT

Very elegant solution, thank you!