topic Re: Want to Read ONLY column names from a huge text file in SAS Programming

Want to Read ONLY column names from a huge text file

KinjalPatel — Sun, 11 Aug 2019 14:24:56 GMT

I have bunch of huge text files in zipped format (.txt.gz). Is it possible to read only column names in SAS from those files.

Please guide me if you have any solution.

Thanks,

Kinjal

Re: Want to Read ONLY column names from a huge text file

Tom — Sun, 11 Aug 2019 14:28:54 GMT

@KinjalPatel wrote:

I have bunch of huge text files in zipped format (.txt.gz). Is it possible to read only column names in SAS from those files.

Please guide me if you have any solution.

Thanks,

Kinjal

So if you have file name bigfile.txt.gz the you can use the OBS=1 option on the INFILE statement to just read the first observation.

data headers ;
  infile 'bigfile.txt.gz' zip gzip obs=1 dsd dlm=',' ;
  length name $32 ;
  column+1;
  input name @@;
run;

Re: Want to Read ONLY column names from a huge text file

KinjalPatel — Sun, 11 Aug 2019 14:39:49 GMT

Thanks a lot for quick reply!