Good Day, I'm trying to automate importing an excel file from a folder based on the most recent time period. For example, proc import out= cars datafile= "C:/mydata/SampleData_202304.xlsx" dbms= xlsx replace; sheet="Sheet1"; run; It will import the file for April 2023 but for May 2023 I would have to manually change the file name. How can I automate that?
... View more
