Hi
I have the SAS add-in in excel. I have multiple SAS data sets in one excel sheet. Is there some way that I can refresh all at the same time without clicking on each data set and then clicking refresh.
Thanks
You can use VBA for this:
https://communities.sas.com/thread/9310?start=0&tstart=0
Hey Nhozza,
you may want to go to the SAS-Ribbon and click the 'Manage Content' button.
It should be a piece of cake from there on.
Just check the data you want to refresh and press refresh...
🙂
Cheers
Michael
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Latest Updates