Hi Experts! I am trying to write a code that imports weekly excel files into one large table (this table should encapsulate all the weekly excel tables to create one large monthly table), the issue is that the days that they are reported are contantly changing so it can't be a hard code that can be repeated monthly. My solution to this was for the user to just input the dates that are given. Here is what i have so far: %Let Date1 = 2023-8-2; %Let Date2 = 2023-8-9; %Let Date3 = 2023-8-16; %Let Date4 = 2023-8-23; %Let Date5 = 2023-8-30; %Let FilePath2 = \\path\to\my\Data\SFC Funding Notification &Date1..xlsx; LIBNAME ClMed2 xlsx "&FilePath2."; proc contents data=ClMed2._all_ out=SheetNames(keep=memname) noprint; run; proc sort data=SheetNames; by memname; run; data _null_; set SheetNames end=last; if last then call symputx('LastSheet', memname); run; data ClMed2_LastSheet; set ClMed2."&LastSheet"n(firstobs=3); run; (The reason why the import is odd is because the name of the excel tabs is also constantly changing, but it always the last sheet so this was my attempt at only importing the last sheet on the excels ) What would be the best way to loop this so that the data table populates with the tables called "SFC Funding Notification 2023-8-2", "SFC Funding Notification 2023-8-9", "SFC Funding Notification 2023-8-16", ... etc.
... View more