Subscribe Bookmark RSS Feed

Real-time SAS update from an Excel sheet

nasser186

Community Member

Joined:

Jul 23, 2014

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.

Thanks

Nasser