BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar

Not applicable


Jul 23, 2014

Real-time SAS update from an Excel sheet

Hi all

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.