topic Re: Input file has less columns than what is defined in input step of sas macro in SAS Data Management

Input file has less columns than what is defined in input step of sas macro

eagles_dare13 — Fri, 04 Jul 2014 17:54:18 GMT

If I am reading data from a comma separated text file and in my input step i declare 5 columns and if in the input file there are only 3 comma separated values, will I get exception?

Or will the resultset be created with 5 columns with 3 columns populated and the other columns as null?

Re: Input file has less columns than what is defined in input step of sas macro

Tom — Fri, 04 Jul 2014 19:16:52 GMT

It depends on the settings on your INFILE statement. If you use the TRUNCOVER option then the extra variables will be all missing. Similarly if there is extra information on the line it will be ignored.

Try this little example.

data x;

infile cards dsd truncover ;

input v1-v5;

cards;

1,2

1,2,3

1,2,3,4

1,2,3,4,5

1,2,3,4,5,6

run;

Re: Input file has less columns than what is defined in input step of sas macro

stat_sas — Fri, 04 Jul 2014 19:25:06 GMT

You will get 5 columns with 3 columns populated remaining as null.