BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
kimo
Fluorite | Level 6

I am interested in SAS visual analytics. How does this work?

 

1-you have to build a large table with all variables. All dashboards use this table.

 

2-you have to build a table for each dashboard.

 

3-Each dashboard can read from different tables at once

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
MichelleHomes
Meteorite | Level 14

Not exactly...

 

The filter Country=USA for table1 will only subset the data in table1. Creating a Country=USA on table2 means you are using the Country column from table2 will subset the data in table2 only. You have to create filters per table, even though the column may exist in each table. 

 

Hope this helps.

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

View solution in original post

12 REPLIES 12
MichelleHomes
Meteorite | Level 14

Hi Kimo,

 

Welcome to the SAS Visual Analytics community. To answer your questions:

1-you have to build a large table with all variables. All dashboards use this table.  

    Yes

 

2-you have to build a table for each dashboard.

    No you don't have to. You can create multiple dashboards from the 1 table

 

3-Each dashboard can read from different tables at once

    Yes

 

To get you started using SAS Visual Analytics, you will see a box titled "SAS Visual Analytics Starter Kit" at https://communities.sas.com/t5/SAS-Visual-Analytics/bd-p/sas_va - I suggest going through these links.

 

Also @ChrisHemedinger posted earlier this week some very SAS Visual Analytics on-demand webinars you may find helpful at

https://communities.sas.com/t5/SAS-Visual-Analytics/Column-Percentage-in-bar/m-p/274082#M4452

 

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
kimo
Fluorite | Level 6


Thanks for your answer but I do not understand exactly what you mean.


You answer yes to the first question and the third but I think they are contradictory.


If SAS can work each dashboard with several tables at once why build a single large table that is very hard work and not very practical for drill down if the large table is the result of mergers with other tables.




Can it be for performance ?.




Thanks for your attention.
TriciaAanderud
Lapis Lazuli | Level 10

Just to clarify @MichelleHomes comments - you can do it however you like.  It is based on your individual report.

 

In some cases - it works better to have a report/dashboard that is based on a single table.  Perhaps you have multiple views of the data - for instance a treemap that shows the products by Batch Number.  Then another section that has a map showing where the batch numbers were distributed.

 

You can also have the data broken into smaller tables if it is more convenient for you or works better for you data.

 

 


Tricia Aanderud

Twitter: @taanderud - Follow me!

MichelleHomes
Meteorite | Level 14

Sorry if my answers appear contradictory and created any confusion.

 

You can create a large table or multiple tables and load them into memory. If you are replicating the data in the multiple tables, it is obviously taking up additional resources (and may affect performance) which is why you might consider using one large table. Also you may want to use one large table if you want to have interactions within and between your reports so the data can be filtered. The source and target tables must be the same for the filtering to work.

 

I suggest spending some time reading the documentation, watching videos/webinars/tutorials and perhaps attend SAS Visual Analytics training to gain a solid understanding with your data load/preparation and report creation.

 

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
kimo
Fluorite | Level 6

Thank you for your time.

 

 

Kind Regards,

MichelleHomes
Meteorite | Level 14

Thank you @kimo. Glad to help.

 

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
kimo
Fluorite | Level 6

I have a new question:   "if you want to have interactions within and between your reports so the data can be filtered. The source and target tables must be the same for the filtering to work."

 

 

 

Is it not possible to put a general filter that filters all tables at once?. 

 

In other words put a filter that interact with all tables but each table serves to calculate indicators.

 

MichelleHomes
Meteorite | Level 14

New questions should really be created as a new question so that the thread remains as the original question. Please keep this in mind in future.

 

Filters are data source specific for the data items involved. If you have multiple tables being used in a report the filters will be applied to only the tables where a filter definition has been applied. Essentially a filter is a where clause on the table. 

 

It isn't possible to have a filter that applies to all the tables "at once". If you require this, it is best to join the tables outside of SAS VA and load the combined table into memory.

 

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
kimo
Fluorite | Level 6

Thank you,

 

I think I understand. If I make the filter

 

Country = USA.


If I defined in table1 and table2 the filter. each table is then filtered by the filter USA

It is correct?


Thank you and sorry for the inconvenience.

MichelleHomes
Meteorite | Level 14

Not exactly...

 

The filter Country=USA for table1 will only subset the data in table1. Creating a Country=USA on table2 means you are using the Country column from table2 will subset the data in table2 only. You have to create filters per table, even though the column may exist in each table. 

 

Hope this helps.

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
kimo
Fluorite | Level 6
Thank you, Is it not possible to create a dropdown menu on the dashboard to apply the filter on each table?
MichelleHomes
Meteorite | Level 14

As previously stated a filter is a where clause for a specific table. I suggest you read the Working with Filters section in the SAS Visual Analytics User Guide and trying it out in your own environment http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n0t60h2we10v5pn192cle...

 

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 12 replies
  • 1686 views
  • 5 likes
  • 3 in conversation