About LisaSklar

LisaSklar · ‎06-13-2025

Thanks, this is along the lines of what I was, it just totally slipped my mind. Appreciate it!

LisaSklar · ‎06-12-2025

I am trying to extract a substring from a field that has up to 2000 characters. I need to capture whatever is between "Destination(s):" and "." The following works, but is there a more elegant way to do this? I feel like I'm missing something obvious. Case When FIND(t1.Comment_ID,"Destination(s):") > 1 then STRIP(SUBSTR(t1.Comment_ID,FIND(t1.Comment_ID,"Destination(s):")+16,FIND(SUBSTR(t1.Comment_ID,FIND(t1.Comment_ID,"Destination(s):")+16,200),".")-1)) Else "" End Thanks, Lisa

LisaSklar · ‎12-18-2020

Have you tried moving the category variable from Columns to Rows (under Data Roles)?

LisaSklar · ‎12-18-2020

Have you tried the VA tutorial videos on the SAS website? They tend to be very helpful. https://video.sas.com/category/videos/sas-visual-analytics_

LisaSklar · ‎12-16-2020

We applied the hotfix recommended by SAS support and that appears to have done the trick.

LisaSklar · ‎12-14-2020

SAS Support suggested that this might be fixed by installing the hot fix for Problem Note 61680: In the modern version of SAS® Visual Analytics Viewer, slider values might not refresh properly after filters are applied We're going to give that a shot and hopefully that will fix it.

LisaSklar · ‎12-10-2020

I have already submitted this to SAS support but need to go live with this dashboard tomorrow so I'm hoping someone here has encountered this and perhaps knows of a fix. I am using a Visual Analytics 7.5 and am having an issue with the dynamic minimum/maximum behavior of a date slider. When an additional page control filter (dropdown box) is selected, the date slider correctly resets the dynamic minimum and maximum. However, when that same dropdown box is placed in the report prompt area, the dynamic minimum and maximum do not change when the data is filtered. It actually works perfectly in report builder, but is broken in report viewer. I know I have the workaround of placing the dropdown in the page control for every single page, but that's more onerous for the user and I would prefer to go with the report filter if possible.

LisaSklar · ‎05-13-2020

Yes, unfortunately using the label role was the best way to do what I needed. I ended up abandoning that option completely due to the inability to format the text, and went with a worse option that at least is readable. It's unfortunate that something as simple as being able to change a font color and size got overlooked in this case.

LisaSklar · ‎05-05-2020

I added a Label role to my step plot and the labels are tiny. I need to increase the font size but can't find the control to do it. I feel like I'm missing the obvious. Please help! I'm using 7.5

LisaSklar · ‎08-27-2019

To insert a line break in the middle of a label, you just need to use your ODS Escapechar with the line break command, 'n'. Try this: {LABEL='Negeri\nState'} Cheers, Lisa

LisaSklar · ‎05-14-2019

If you export to Excel instead of using "send to" you get a save-as option.

LisaSklar · ‎04-30-2018

Thanks for the reply. I'm sorry to hear there's not a way to make that work, but I appreciate the response.

LisaSklar · ‎04-30-2018

Unfortunately, that did not work. Thanks for the suggestion, though.

LisaSklar · ‎04-30-2018

I am trying to add leading spaces to a calculated item that is going on a button bar, but VA won't display them. I am using 7.4. I have tried adding the spaces to the text itself inside the quotation marks, and also concatenating a sting of just spaces. (This is to workaround the inability to right justify text in button bars... which is to workaround the fact that you can't put a text box in the report prompt area...) Thanks.

LisaSklar · ‎04-02-2017

The web version isn't ideal, but I've been able to use the same verification code every time I access the site. I haven't needed to have the email re-sent.

Online Status	Offline
Date Last Visited	‎06-13-2025 08:34 AM

Re: More elegant way to extract a substring between two delimiters

More elegant way to extract a substring between two delimiters

Re: How to re-fromat your list tables

Re: simple dashboard using sas va for beginners

Re: Slider dynamic min/max not working with report control

Re: Slider dynamic min/max not working with report control

Slider dynamic min/max not working with report control

Re: Label role font size

Label role font size

Re: proc tabulate create new line in label and capitalize for each wor...

Re: More elegant way to extract a substring between two delimiters

Re: Order of Process flow

Add a label field in SAS VA

Allow data label inside the stacked bar.

Variable data text box

Re: simple dashboard using sas va for beginners

Re: Slider dynamic min/max not working with report control

Re: Here's another new method of transportation we will try out #GetTo...

Re: More elegant way to extract a substring between two delimiters

More elegant way to extract a substring between two delimiters

Re: How to re-fromat your list tables

Re: simple dashboard using sas va for beginners

Re: Slider dynamic min/max not working with report control

Re: Slider dynamic min/max not working with report control

Slider dynamic min/max not working with report control

Re: Label role font size

Label role font size

Re: proc tabulate create new line in label and capitalize for each wor...

Re: SAS Eg 7.1 "sent to" option

Re: Add leading spaces to a calculated item

Re: Add leading spaces to a calculated item

Add leading spaces to a calculated item

Re: SAS GF App Has Stopped

SAS Global Forum 2017