Hi all, SAS 9.4 I 'm trying to create a loop so that all the xlsx-files are imported. I notice that the code below is wrong but I don't know how to correct it the right way. I have 4 excelfiles to import. The result of this code is that the first excelfile is imported 4 times (and it overwrites itself each time). The result should be that 4 each excel file is imported once. Each excelfile has a different variable in its filename (ERK = 009, 090,091,777). Only the 009 is imported. Could anyone help me with this please? /*macro to import a single excel*/ %macro import(input); OPTIONS VALIDVARNAME=ANY; PROC IMPORT OUT=work.B1B2_E&erk. (keep = N_BUD_AN ID_AGR TIT_N Source N2018) DATAFILE= "&path\&input..xlsx" DBMS=excelcs REPLACE; RANGE="B1B2$"; /*to import the sheet completely*/ SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; %mend; /*loop to import all the files*/ %macro Loadall; %do i=1 %to &numobs; %import(&&filein&i); %end; %mend; %loadall;
... View more