BookmarkSubscribeRSS Feed
renjithr
Quartz | Level 8

Hi,

 

I am looking for options to update an excel dashboard( contins comparion of regions for each month, graphs etc) with SAS data. I heard people saying this can be done using  VBA but I do not have any VBA experience. Is  there any good resources that I can utilize? 

 

Please advise.

4 REPLIES 4
Reeza
Super User

It depends on your dashboard structure and your data. 

 

If your data is well structured, ie the number of rows and columns are fixed then you can do something like the following. 

 

1. Set up a template in Excel - graphs linked to data source in separate Excel sheet

2. In template, set up named ranges in Excel

3. Use libname method to export data to named ranges in Excel

 

If you don't have a well structured data sets you will have to use VBA. 

 

I presented a paper on this, but I'm not sure it stands alone very well. It does have sample code however.

http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Edmonton-User-Group/FareezaKhu...

renjithr
Quartz | Level 8

Thank you Reeza. I plan to use the technique you mentioned in your paper for a dashbord where the columns and rows are static.

 

Any reccomendatins ( links, books ) for creating dynamic dashboards using VBA?

Reeza
Super User

No...I'd ask that question in an Excel forum to get a response. 

 

I do use it in other reports, but its incredibly custom so it depends. Excel also supports slicers and the Power Pivot tool, which allow for dynamic reporting so that VBA may not be required at all.

 

Again it depends on what you're trying to do 🙂

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1385 views
  • 0 likes
  • 2 in conversation