BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
cokeyng
Obsidian | Level 7

Hi all,

 

I am wondering if it is possible to create a button control on a report without a data source. here is an example I have

Cost Type   Location   Cost Value   

A                 City 1        500,000.00

A                 City 2        450,333.00

B                 City 1        750,000.00

C                 City 2        800,000.00

D                 City 1        950,000.00

 

I want to create a button control with a "Include Cost Type A ? Yes/No" choice. where "Yes" includes Cost Types A, B, C,D and "No" is for B, C and D only.

 

The only way I can think of is to create a dummy data set with two values, Yes and No. Associate a Parameter with that with on the control. Then make a filter to check the value of the parameter to set the filter to include A,B,C,D or B,C,D only

 

Thanks

 

Cokey 

1 ACCEPTED SOLUTION

Accepted Solutions
acordes
Rhodochrosite | Level 12

Correct, create a promoted table with few fake rows. 

 

data dummy_va(promote=yes);
do number=1 to 25;
num_char=put(number, 3.);
output;
end;
run;

Then load this table to the report. 

Next select the table and create a customized group.

Use this customized group, here sel lattice, in an object, here button bar. 

Assign a parameter to it, here sel lattice parameter. 

 

Then use the parameter i.e. in an if-then statement to return the desired category variable used for the lattice role. 

 

pic2.pngpic1.pngpic3.png

 

 

View solution in original post

1 REPLY 1
acordes
Rhodochrosite | Level 12

Correct, create a promoted table with few fake rows. 

 

data dummy_va(promote=yes);
do number=1 to 25;
num_char=put(number, 3.);
output;
end;
run;

Then load this table to the report. 

Next select the table and create a customized group.

Use this customized group, here sel lattice, in an object, here button bar. 

Assign a parameter to it, here sel lattice parameter. 

 

Then use the parameter i.e. in an if-then statement to return the desired category variable used for the lattice role. 

 

pic2.pngpic1.pngpic3.png

 

 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 317 views
  • 0 likes
  • 2 in conversation