Hi all,   I have multiple Excel files saved in a folder, each containing only one sheet with randomly named sheet tabs. I need to find the first row that contains the column header "Job No." and import all the data starting from that column header for each file. There are 11 columns and random rows in each files.    Below is my code for processing a single Excel file to identify the row containing "Job No." However, I'm encountering an error on the line do i = 1 to dim(cols); that says, "ERROR: A loop variable cannot be an array name or a character variable; It must be a scalar numeric."   Can someone help me correct the code and make it applicable for multiple files? Thanks!   %let folder = /mnt; %let filename = file.xlsx; proc import datafile="&folder./&filename." out=raw_data dbms=xlsx replace; getnames=no; run; data _null_; set raw_data; array cols _all_; if _n_ = 1 then do; found = 0; do i = 1 to dim(cols); if upcase(vname(cols[i])) = "JOB NO." then do; call symputx('header_row', _n_); found = 1; /* Set found flag */ leave; end; end; if found = 0 then do; put "ERROR: 'Job No.' not found in the first row."; call symputx('header_row', 0); end; end; run; data final_data; set raw_data(firstobs=&header_row); run; data final_data; set final_data; if _n_ = 1 then do; rename col1 = Job_No col2 = Requesting_Client col3 = Contact_Full_Name col4 = Start_time col5 = End_Time col6 = Language /* there are more columns */ ; end; run; proc print data=final_data; run;       ... View more