DATA Step, Macro, Functions and more

Reading specific field from .csv file

Reply
Occasional Contributor
Posts: 17

Reading specific field from .csv file

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.
Respected Advisor
Posts: 3,777

Re: Reading specific field from .csv file

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]
Occasional Contributor
Posts: 17

Re: Reading specific field from .csv file

Very elegant solution, thank you!
Ask a Question
Discussion stats
  • 2 replies
  • 132 views
  • 0 likes
  • 2 in conversation