topic Using input statement , when the there is no column name in SAS Programming

Using input statement , when the there is no column name

himself — Thu, 06 Aug 2020 07:17:30 GMT

Hi all, somebody help, I happen to have a dataset, where by i want to read the second column and the third column, The dataset is in csv format, so the first column does n't have a name, how can i capture this under the input statement?

*reading in the data;
data passenger;
  infile "path " dsd firstobs=2;
  input  time airpassengers;
run;

This is the code am using.

this is how the dataset looks like in csv format

The output is like this

So the output has not captured the second column, kindly help
Thanks!!!

Re: Using input statement , when the there is no column name

andreas_lds — Thu, 06 Aug 2020 07:33:56 GMT

In the input-statement just add a variable for the unnamed column and add a drop-statement to prevent the variable from being written to the dataset.

input ignore_me time airpassengers;
drop ignore_me;

Re: Using input statement , when the there is no column name

himself — Thu, 06 Aug 2020 07:44:12 GMT

Hi thanks Alot, it has worked out