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

Hi ,

 

I have started working with sas va. I want to prepare the Category Variable for the Button bar  and then show my result in the Table. I mean like that. 

 

 

I have My data  :

dateweekmonthVar 1Var2
16.02.20212021W0720210218
15.02.20212021W0720210224
13.02.20212021W0620210266
12.02.20212021W0620210246
11.02.20212021W0620210248
10.02.20212021W0620210213
09.02.20212021W0620210248
08.02.20212021W0620210214
07.02.20212021W0520210250
 

 I need show  in Button bar:

 
dateweekmonth

 

 

If I click on the the "date" (month or week)  in the Button bar…

And then I want to see/show in the Table(crosstab or List table)

 

for date:

dateVar 1Var2
16.02.202118
15.02.202124
13.02.202166
12.02.202146
11.02.202148
10.02.202113
09.02.202148
08.02.202114
07.02.202150

 

If I click on the the "week" .... 

 

weekVar 1Var2
2021W0718
2021W0724
2021W0666
2021W0646
2021W0648
2021W0613
2021W0648
2021W0614
2021W0550


But I can’t do that… perhaps something introduced in the latest round of patches?


Any suggestions for a workaround?

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
utrocketeng
Quartz | Level 8

i would use a stacked container.  then add three list tables.  rename the list table {date, week, month} per your requirement.  under the options for stacked container, you can change the button type to buttons:

utrocketengineer_1-1613574122762.png

 

 

when done, you should have something that when the various buttons above are clicked, the table shown will change to what you defined.  

utrocketengineer_0-1613574097029.png

 

without your data i am not able to show a fully developed solution, but this should get you where you are going.

View solution in original post

1 REPLY 1
utrocketeng
Quartz | Level 8

i would use a stacked container.  then add three list tables.  rename the list table {date, week, month} per your requirement.  under the options for stacked container, you can change the button type to buttons:

utrocketengineer_1-1613574122762.png

 

 

when done, you should have something that when the various buttons above are clicked, the table shown will change to what you defined.  

utrocketengineer_0-1613574097029.png

 

without your data i am not able to show a fully developed solution, but this should get you where you are going.

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 1 reply
  • 644 views
  • 1 like
  • 2 in conversation