topic Re: how to take some variables from raw data using infile in SAS Programming

how to take some variables from raw data using infile

thanikondharish — Wed, 25 Jul 2018 04:23:19 GMT

given a data file with 100 observations of data, you only need to read in the first 70 columns

Re: how to take some variables from raw data using infile

PeterClemmensen — Wed, 25 Jul 2018 04:33:02 GMT

data have;
   do x=1 to 100;
      output;
   end;
run;

data want;
   set have(obs=70);
run;

Re: how to take some variables from raw data using infile

thanikondharish — Wed, 25 Jul 2018 04:35:42 GMT

I want variables not observations

Re: how to take some variables from raw data using infile

PeterClemmensen — Wed, 25 Jul 2018 04:46:40 GMT

Ah ok. Do something like this

data have;
   array SomeArray{100} x1-x100;
run;

proc sql noprint;
   select name into :varnames separated by ' '
   from dictionary.columns
   where libname="WORK" and memname="HAVE" and varnum<=70
   order by varnum;
quit;

%put &varnames.;

data want;
   set have;
   keep &varnames.;
run;

Re: how to take some variables from raw data using infile

thanikondharish — Wed, 25 Jul 2018 04:50:42 GMT

It's good but how do we do using infile statement read only 70variables out
of 100 (is any options used like line,linesize,length

Re: how to take some variables from raw data using infile

PeterClemmensen — Wed, 25 Jul 2018 04:53:53 GMT

What kind of data source do you want to read from with this infile statement? a .txt, .xlsx file?

An infile statement is used to read data from an external file.

Re: how to take some variables from raw data using infile

thanikondharish — Wed, 25 Jul 2018 04:56:42 GMT

.xlsx file

Re: how to take some variables from raw data using infile

andreas_lds — Wed, 25 Jul 2018 04:59:57 GMT

@thanikondharish wrote:
.xlsx file

Reading a named range is possible if you setup fits - there are some many papers and posts explaining this, i don't like to repeat it. If you don't have a range, you have to import everything and drop the unwanted variables.

Re: how to take some variables from raw data using infile

PeterClemmensen — Wed, 25 Jul 2018 05:00:26 GMT

You cannot INFILE an XLSX file in DATA step. You need to use an engine that can read the data structure of an Excel spreadsheet.

You can however import a .csv file with the INFILE Statement.