Hello,
So I am running a simple piece of code to import an excel file and sort it and then output it to a sas file. I am hoping that every day as I upload the new daily excel file I can run the code everyday and it will output a sas file for each day with that day's specific data. However, I have run the code the last few days, and every time I run it only imports data from the first day's excel file, even though I have changed the file name to import today's data. Here is the code:
proc import datafile="data.xlsx" out=forecast&sysdate. dbms=excel replace; range="$E6:F"; getnames=yes; /*MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; USEDATE=NO; */ run;
data in_capacity&sysdate.; set forecast&sysdate.; Capacity=Filled_Appointments/Total_Appointments_Avalable; run;
proc sort data=in_capacity&sysdate.; by Capacity; run;
So I make sure that the file name everyday matches what is in the proc import code so that it imports new daily data, but it continues to only import data from the first day's file.
Any ideas?
Thank you!
... View more