BookmarkSubscribeRSS Feed
Zelazny7
Fluorite | Level 6
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.
2 REPLIES 2
data_null__
Jade | Level 19
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]
Zelazny7
Fluorite | Level 6
Very elegant solution, thank you!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1514 views
  • 0 likes
  • 2 in conversation