I have a question about data exchange between Excel and SAS. I have an excel sheet that has some parameters. By changing these parameters a macro is run and updates the sheet with new values. As I need SAS visualization, I have to import the table into SAS every time I change a parameter which is a pain! I was just wondering if there is any way to automate this, such that once my Excel sheet is updated with new values, the equivalent SAS table is also updated.
I really appreciate if you guys help me with this.