is it possible to create a button control without a data source?

cokeyng — Fri, 14 Oct 2022 22:47:45 GMT

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

Re: is it possible to create a button control without a data source?

acordes — Sat, 15 Oct 2022 12:55:03 GMT

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.

topic Re: is it possible to create a button control without a data source? in SAS Visual Analytics

is it possible to create a button control without a data source?

Re: is it possible to create a button control without a data source?