About KeithM

Okemberg1 · ‎05-15-2025

Good morning Keith and thanks for the quick reply, I will do as you suggested, thanks again

KeithM · ‎03-26-2025

For the Custom Graph, if you don't overlay the bar charts then it does provide an option for different y axis.

KeithM · ‎07-30-2024

I have a solution for you. I will display the sample report and then explain how it works. 1. I have two lookup tables: District_Lookup, School_Lookup You would make these part of your Data process. If a district or school name changes then you update these tables. 2. My report data is called "District_School_Enrollment". It only contains id's. 3. All 3 tables are imported into CAS. You will need to create a Join between District_School_Enrollment to the other two lookup tables so you can get District Name and School Name. First Join to get the District Name 2nd join to get the School Name. The resulting table is called "Data_Join(1). That will be the table we create the report off of. 4. After you have this setup, you can now build your entire report off of Data_Join (1). If you want to add List prompts going against the lookup tables are most efficient. If you do that, you simply need to MAP the tables. District Lookup --> Data_Join(1). School_Lookup --> Data_Join(1). :

KeithM · ‎06-28-2024

I have a solution for you. In my example, I'm using the sashelp.cars table. The data item used is MAKE. 1. Create a calculated data item to represent your default value. In my example, the default value is "Honda Motor Sports". The Make Parameter would be the drop down list that you would clear. 2. Create a hidden page. On the hidden page, add another drop down list and assign the role to be the calculated item in #1. Create a parameter for that drop down. In my case, I called it Hidden Parameter. 3. Back on Page 1, I have some descriptive text that only references the parameter from page 2. 4. Results. a. You select a car make on page 1. b. You clear the filter.

Madelyn_SAS · ‎04-05-2024

From your screen shot, you must be using a version on SAS Viya. I looked at the old solution and it still works. You add the parameter to the list control and the parameter to the text object. If values are selected in the list control, then they will populate in the text object. But if there are no values selected, the text object will show no <no item selected>. The list control prompts would have to be required so that something is always selected.

india2016 · ‎02-29-2024

@KeithM Thank you so much for your efforts . This will help me to enhance the dashboards look

Deep04 · ‎02-28-2024

Thanks @KeithM for your great explanation. but there are bunch of question I have. 1. Can we change the appearance of _webout.html and _webout.xlsx to like download excel here so the user can understand click there to download excel. 2. Is &SYS_JES_JOB_URI only resolves in SASJobExecution ? Also I didn't get your last point about _webout.html , can you please narrow it down?

krishnaavm123 · ‎02-20-2024

Hi Keith , Thanks for your reply and I also wanted to check one more condition that is if alerts being tagged to tier2 then only calculate to 10. Can U PLS help on this logic when I applied another and condition to check if stream is tier2 it's thrown an error type mismatch and if one operand can only be used in grouped manner.

ChristyN · ‎02-15-2024

Thank you! I love you and this community!

a_SAS_sin · ‎02-12-2024

Hi @Keith I understood your solution but, in my real-world case, the report user can select/input 20 or 30 codes (simple IDs). Being these codes simple IDs with no meaning to the user, inserting them by hand on a text box is not feasible. As I said before and can be seen in the print screen I sent, it is just weird that we cannot use the link correctly generated in the text object. Is there a solution that does not involve manually inputting the values? Thanks

smm662002 · ‎02-09-2024

Hi, Thank you so much for the explanation. I will recreate it and hopefully the legend won't be truncated in the future. Should we hope for a future option allowing user to explicitly decline the truncation? Regards, smm662002

Sam_SAS · ‎02-16-2023

Thanks for following up with us! It should help others in the future 😊

ender111 · ‎01-19-2023

Thanks, Keith. This was perfect. I had some trouble with assigning the variable on the URL end, but it was just necessary to input the optional target fields, then everything worked great. Job Execution was new for me so that took some getting used to, but is a very nice complement to report generating. Thanks again!

dhavalyparikh · ‎11-14-2022

Instead of you hardcoded date as intnx('week','30MAY1980'd,0,'B') <= 'date'n <= intnx('week','30MAY1980'd,0,'E') Is there way I can use the current date ? with my case statement Start_Date is : (TableDate Value Field) In below statement select ind_latest = case when Freq="Weekly" and intnx ('Week',Today(),0'b') <= Start_Date<=intnx ('Week',Today(),0'E') then 1 else 0 run;

KeithM · ‎10-05-2022

Don't click on the three dots. Right mouse click in the body of the drop down. Where the X is in my screen capture.

Online Status	Offline
Date Last Visited	‎05-14-2025 12:43 PM

Re: Issue with passing filters from a graph to another section

Re: Bar chart 3 measures with different axis y scales

Re: Bar chart 3 measures with different axis y scales

Re: Bar chart 3 measures with different axis y scales

Re: Dropdown Filters: How to display names different from the underlyi...

Re: Parameter for filter descriptions - 'current value' not possible

Re: Generate the excel file from code

Re: Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Re: SAS visual Analytics

Re: Required input for SAS VA dashboard report link

Viya Jobs that Create Multiple Output Files

Re: SAS Visual Analytics Date slider

Re: Dropdown Filters: How to display names different from the underlyi...

Re: Required input for SAS VA dashboard report link

Re: Generate the excel file from code

Re: Required input for SAS VA dashboard report link

Re: SAS visual Analytics

Re: Issue with passing filters from a graph to another section

Re: Bar chart 3 measures with different axis y scales

Re: Dropdown Filters: How to display names different from the underlyi...

Re: Parameter for filter descriptions - 'current value' not possible

Re: Displaying checkbox selections

Re: Required input for SAS VA dashboard report link

Re: Generate the excel file from code

Re: SAS visual Analytics

Re: How to Prompt Users for Fiscal/Quarter/Monthly View

Re: Pass multiple values from VA List object to Stored process url par...

Re: Pie Chart Legend Issue

Re: Working with Calculated Items

Re: Activate a macro variable via button control?

Re: SAS - Visual Data Builder - where dynamic date condition

Re: How to select the most recent date in a drop down box in Visual An...