loop import csv file

daradanye — Sun, 11 Sep 2022 21:31:53 GMT

Hello,

I have a number of excel files named as file_a, file_b until file_h. I'd like to use a macro do loop to import the files.

Following the code in this link

I write the following code. I also tried to add % before proc import command and it does not work either. That would be great if someone can help here.

Thanks.


%let list = a b c d e f g h;
%local i next_name;
%let i=1;
%do %while (%scan(&list, &i) ne );
   %let next_name = %scan(&list, &i);
 proc import out=jobpost&next_name
	datafile="H:\bdata\file_&next_name..csv"
	dbms='' replace;
	run;
   %let i = %eval(&i + 1);
%end;

Re: loop import csv file

Kurt_Bremser — Sun, 11 Sep 2022 21:53:28 GMT

A %DO must be part of a macro, you cannot use it in "open code".

If the csv files (which are NOT Excel files) have the same structure, you can read them in one DATA step.

topic Re: loop import csv file in SAS Programming

loop import csv file

Re: loop import csv file