topic Re: how to assign length to all character variables at a time in SAS Programming

how to assign length to all character variables at a time

thanikondharish — Fri, 07 Sep 2018 14:21:46 GMT

data have ;
infile cards dlm=',' ;
input (a1-a4) ($10.) ;
cards ;
a ,b, c, d
;
is the above program correct to assign length to all character variables at a time
if it is wrong then how can i do?

Re: how to assign length to all character variables at a time

Tom — Fri, 07 Sep 2018 14:38:05 GMT

The way to assign a length to a variable is to use a LENGTH statement. You can also use the LENGTH= attribute in an ATTRIB statement.

length A1-A4 $10 ;

If you want to let the compiler GUESS what length you want to use for your variables based on how you first use them then you could use your method of using an informat in the INPUT statement. But for delimited data make sure to use the colon modifier to prevent the INPUT statement from using formatted input mode and messing up the parsing of the line around the delimiters.

data have ;
  infile cards dsd dlm=','  truncover;
  input (a1-a4) (:$10.) ;
cards ;
a,b,c,d
;

Re: how to assign length to all character variables at a time

thanikondharish — Fri, 07 Sep 2018 15:18:31 GMT

thanq