This program works with one table. I'm trying the macro one and still on it. I'll let you know if I find my way. Thanks @Tom  ... View more

I'll work on it, and see what I can do with your proposition. Thanks  ... View more

Thanks. How do I do that? I have multiples files with multiples tables with the same structure. ... View more

I would like to have a normal table at the end. I prepar the code to delete the sub total and total, and also code to file the void on variables name and date. I just ned to find a way to import all my tables at once because it is a lot (daily table on more than 7 years) data want; set Work.have; if Day="" then Day='12/01/2022'; if Day="Sous Total" then delete; else Day='12/01/2022'; NDay=input(Day,MMDDYY10.); format NDay MMDDYY10.; Nhour=input(translate(hour,':','H'),time15.); format NHour tod5.; retain File; if not missing(Name) then File=Name; else Name=File; drop File Day hour; run; ... View more

Thanks Tom. I still get the table with the text below and above  Log result: 1 %macro import(T01); 2 FILENAME REFFILE "filepath\&T01..xls"; 3 proc import datafile=reffile out=raw replace dbms=XLS; 4 sheet="XTH"; 5 getnames=no; 6 run; 7 data _null_; 8 set raw; 9 if 'NAME'=upcase(strip(A)) then call symputx('startrow',_n_); 10 if A ne ' ' and left(A)=:'**' then call symputx('endrow',cats('endrow=',_n_)); 11 run; 12 proc import datafile=reffile dbms=xls out=%sysfunc(compress(&T01. , "- ")) replace; 13 sheet="XTH"; 14 namerow=&startrow; 15 &endrow; 16 getnames=yes; 17 run; 18 19 %mend import; 20 21 %import (file1name); NOTE: The import data set has 34 observations and 12 variables. NOTE: WORK.RAW data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.09 seconds cpu time 0.01 seconds NOTE: There were 34 observations read from the data set WORK.RAW. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Variable Name Change. Ré -> R_ NOTE: Variable Name Change. Ti Ré -> Ti_R_ NOTE: Variable Name Change. Ti max -> Ti_max NOTE: The import data set has 33 observations and 12 variables. NOTE: WORK.table1name data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.20 seconds cpu time 0.00 seconds 22 %import (file2name); NOTE: The import data set has 31 observations and 9 variables. NOTE: WORK.RAW data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: There were 31 observations read from the data set WORK.RAW. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Variable Name Change. Ré -> _R_ NOTE: Variable Name Change. Ti Ré -> Ti_R_ NOTE: Variable Name Change. Ti max -> Ti_max NOTE: The import data set has 30 observations and 9 variables. NOTE: WORK.table2name data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.21 seconds cpu time 0.03 seconds 23 %import (file3name) NOTE: The import data set has 47 observations and 14 variables. NOTE: WORK.RAW data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: There were 47 observations read from the data set WORK.RAW. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds WARNING: Apparent symbolic reference ENDROW not resolved. NOTE: Line generated by the invoked macro "IMPORT". 2 ' ' and left(A)=:'**' then call symputx('endrow',cats('endrow=',_n_)); run; proc import 2 ! datafile=reffile dbms=xls out=%sysfunc(compress(&T01. , "- ")) replace; sheet="XTH"; 2 ! namerow=&startrow; &endrow; getnames=yes; run; - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 24 /*etc.*/ 25 run;   ... View more

Here an example of the different tables (It is not the names neither the real data because I’m not allowed to)   ... View more

Hi, thank you so much for the tips.   How could accept multiples propositions that work as a solution? When I accept one, I can't no longer accept other solution  as a solution too. ... View more

Hi yes, First converted to a SAS time Value with this  NHeure=input(translate(Heure,':','H'),time15.); format NHeure tod5.; ... View more

Hello Ballardw I didn't get to try your solution yet. But, I'll try and let you know if it works too. Thanks a lot for your support ... View more

Hello @Tom your solution works too but I don't see the tag to accept it as a solution. It's like when I accept the other one from Reeza I can't see other tags "accep as a solution".   If someone can show me beacuse I'd like to accept it as a solution too. ... View more

Hello Reeza, thanks a lot, I will try them too definetely. ... View more

Sorry for responding in late. It runs on W32_10PRO. I also figured it out the path problem. I made a mistake in my file path.  It's all good now. Thanks for your support. ... View more