Hi everyone, I a using the trial version of SAS Studio I got this code with a help from ChatGPT, however I still getting these errors, I do appreciate any support here. Thank you OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; /* Set the path to your folder */ %let folder_path = 'C:/Import/'; /* Get a list of all Excel files in the folder */ filename excel_files pipe 'dir "C:/Import/*.xlsx" /b'; /* Import data from each Excel file in the folder */ data all_data; length filename sheetname $200.; infile excel_files truncover; input filename $; /* Set the sheet names you want to import from each file */ sheetname1 = 'Sheet1'; sheetname2 = 'Sheet2'; sheetname3 = 'Sheet3'; /* Import data from each sheet in the Excel file */ do i=1 to 3; sheetname= 'sheetname'||put(i,1.); if sheetname1 ne '' then do; if i=1 then call execute('proc import datafile="'||"&folder_path."||'\'||filename||'" out=work.'||compress(filename)||'_s'||compress(i)||' dbms=xlsx replace; sheet="'||sheetname1||'"; run;'); else call execute('proc import datafile="'||"&folder_path."||'\'||filename||'" out=work.'||compress(filename)||'_s'||compress(i)||' dbms=xlsx replace; sheet="'||strip(sheetname)||'"; run;'); end; end; LOG: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 /* Set the path to your folder */ 70 %let folder_path = 'C:/Import/'; 71 72 /* Get a list of all Excel files in the folder */ 73 filename excel_files pipe 'dir "C:/Import/*.xlsx" /b'; ERROR: Invalid logical name. ERROR: Error in the FILENAME statement. 74 75 /* Import data from each Excel file in the folder */ 76 data all_data; 77 length filename sheetname $200.; 78 infile excel_files truncover; 79 input filename $; 80 81 /* Set the sheet names you want to import from each file */ 82 sheetname1 = 'Sheet1'; 83 sheetname2 = 'Sheet2'; 84 sheetname3 = 'Sheet3'; 85 86 /* Import data from each sheet in the Excel file */ 87 do i=1 to 3; 88 sheetname= 'sheetname'||put(i,1.); 89 if sheetname1 ne '' then do; 90 if i=1 then call execute('proc import datafile="'||"&folder_path."||'\'||filename||'" 91 out=work.'||compress(filename)||'_s'||compress(i)||' dbms=xlsx replace; 92 sheet="'||sheetname1||'"; run;'); 93 else call execute('proc import datafile="'||"&folder_path."||'\'||filename||'" 94 out=work.'||compress(filename)||'_s'||compress(i)||' dbms=xlsx replace; 95 sheet="'||strip(sheetname)||'"; run;'); 96 end; 97 end; 98 99 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/EXCEL_FILES. WARNING: The data set WORK.ALL_DATA may be incomplete. When this step was stopped there were 0 observations and 6 variables. WARNING: Data set WORK.ALL_DATA was not replaced because this step was stopped. 109
... View more