topic Append data to the end of each row in SAS Procedures

Append data to the end of each row

KevinC_ — Wed, 10 Jun 2009 17:06:40 GMT

Hello all,

I have a delimited input file with close to 100 fields. i would like to append data to the end of each row. But i don't want to define each of the 100 fields in the input section. in addition, since it's a delimited file, each row has different length. Is there a way to skip to the end of each row from an input file when reading it?

Thanks for any input!
kevin

Re: Append data to the end of each row

sbb — Wed, 10 Jun 2009 17:35:10 GMT

Using a DATA step, it is possible to read up the current data record using an INFILE and INPUT statement, and then address it with the SAS reserved variable _INFILE_ for whatever purpose you might require. A very simple SAS DATA step is listed below for your review/consideration.

Also, the INFILE statement has parameters you can code to identify the record length, current column pointer location -- review the SAS Language INFILE discussion for details.

Scott Barry
SBBWorks, Inc.

data _null_;
infile datalines dsd truncover dlm=',';
input @;
putlog _all_ / _infile_;
cards;
a,b,c,d
e,f,g,h
run;

Re: Append data to the end of each row

ChrisNZ — Mon, 15 Jun 2009 23:58:59 GMT

Or you could skip n fields by reading past them:
[pre]
input var1-varn $ @;
drop var:;