10-20-2023
Winter
Fluorite | Level 6
Member since
10-13-2014
- 12 Posts
- 1 Likes Given
- 0 Solutions
- 2 Likes Received
-
Latest posts by Winter
Subject Views Posted 12312 05-13-2022 07:41 AM 12401 05-10-2022 04:41 AM 12529 05-06-2022 04:35 AM 1521 05-04-2022 05:10 AM 1538 05-03-2022 06:39 AM 1098 09-30-2021 12:07 PM 4931 05-25-2020 08:46 AM 5080 05-07-2020 11:08 AM 6129 06-20-2018 02:18 AM 6163 06-19-2018 03:38 AM -
Activity Feed for Winter
- Posted Re: Introduction to Integration of SAS Visual Analytics with SAS Jobs via Data-Driven Content-Part 1 on SAS Communities Library. 05-13-2022 07:41 AM
- Posted Re: Introduction to Integration of SAS Visual Analytics with SAS Jobs via Data-Driven Content-Part 1 on SAS Communities Library. 05-10-2022 04:41 AM
- Posted Re: Introduction to Integration of SAS Visual Analytics with SAS Jobs via Data-Driven Content-Part 1 on SAS Communities Library. 05-06-2022 04:35 AM
- Posted Re: adding font to SAS VA on SAS Visual Analytics. 05-04-2022 05:10 AM
- Posted Re: adding font to SAS VA on SAS Visual Analytics. 05-03-2022 06:39 AM
- Posted Conditional aggregation of a single measurement in Visual Analytics(3.5) on SAS Visual Analytics. 09-30-2021 12:07 PM
- Posted Re: How do i use SQL data query in SAS Intelligent Decisioning to do lookup? (How to configure SAS M on Decisioning. 05-25-2020 08:46 AM
- Posted How do i use SQL data query in SAS Intelligent Decisioning to do lookup? (How to configure SAS MAS?) on Decisioning. 05-07-2020 11:08 AM
- Got a Like for Re: SAS Freezing on me. 06-21-2018 05:13 PM
- Posted Re: SAS Freezing on me on SAS Programming. 06-20-2018 02:18 AM
- Posted Re: SAS Freezing on me on SAS Programming. 06-19-2018 03:38 AM
- Liked Re: DI Studio and external file for kas. 11-26-2015 06:11 AM
- Got a Like for Re: SAS Freezing on me. 02-03-2015 08:56 AM
- Posted Re: SAS Freezing on me on SAS Programming. 02-03-2015 05:32 AM
-
Posts I Liked
Subject Likes Author Latest Post 2 -
My Liked Posts
Subject Likes Posted 1 06-20-2018 02:18 AM 1 02-03-2015 05:32 AM
05-13-2022
07:41 AM
@Renato_sas That's nice! (I'm hoping for sooner rather than later but also understand that there are a lot of things to develop) 😄
In the mean time, I'd like to share this solution from the SAS support team regarding inline style/script that fixed our problem. Now, I'd also like to share this article on the topic of security regarding inline style and scripts: https://web.dev/csp/#inline-code-is-considered-harmful
In the SAS Environment Manager:
a. Go to Configuration -> View (Definitions) -> Search (sas.commons.web.security)
b. Click on New Configuration -> Services
c. Add Files service and Job Execution service
d. In the field content-security-policy, add:
default-src *; script-src 'self' 'unsafe-inline' 'unsafe-eval'; style-src 'self' 'unsafe-inline'; img-src * blob: data:; child-src * blob: data: mailto:;
e. Click on save
... View more
05-10-2022
04:41 AM
@Renato_sas Thanks for the input! We will have a look around and see what we can manage to figure out! Once again thanks for an excellent article solving a problem (sending parameters and data from VA to Jobs) that maybe should not have existed in the first place 🙂
At the moment we are firmly locked into Viya 3.5 but do you happen to know if a "native solution" in VA for this kind of functionality is on the road map for Viya 4?
Best regards,
Winter
... View more
05-06-2022
04:35 AM
Just an FYI to @Renato_sas and anyone having problem implementing this article. Thanks to this article I've been using the approach a lot for all kinds of VA report enhancement. I prefer to do it the way you do in the demo, "hosting" the html in the Viya Job however since patching/Hot Fixing our Viya 3.5 environment in April 2022 all these integrations are broken due to changes in the Content Security Policy. All you get when trying to apply the "html file in the Viya Job" method is the console errors: Refused to apply inline style because it violates the following Content Security Policy directive: "default-src 'self'"....
Refused to apply inline script because it violates the following Content Security Policy directive: "default-src 'self'".... Hoisting the HTML file on the server fixes the issue but might result in some issue where the job has to be triggered twice (at least in our case), the first time credentials are validated and the second time the job is actually executed. In other words, the first approach in the image below works, the second does not atm.
@Renato_sas While this "DDC to Viya Jobs" method still works when hosting the HTML on the server I would like to be able to keep the HTML file as a Job form once more... I'm guessing that blocking in line style and scripts are a security thing but would it be possible, and if so how, to open up the Content Security Policy for inline script once more?
... View more
05-04-2022
05:10 AM
Hi @Madelyn_SAS ! We are in need of applying custom fonts in two cases:
In exports to PDF via SAS Studio code
and in Visual Analytics reports
OP and the original response is a bit vague when it comes to instructions (would be nice with an official SAS documentation or guide on this but I can't find any).
The font in question (LabGrotesque) is "available" on the linux server hosting the Viya 3.5 environment in woff and otf format as per this fc-list command:
In regards to SAS studio I'm able to register the font per the instruction provided in previous forum threads and this documentation.
Here's the result from Proc Registry:
When it comes to applying the font (in proc reports as an example) I'm struggling (I totally fail to apply it 😂) but I have some digging to do regarding ttf and cff and what procs support what type of font but...
What is more prioritised is making the fonts work in Visual Anlytics and here is where I'm struggling the most.
As shown, the fonts are available on the server where Viya is installed and hosted but I do not know if that is the same as saying that it it is "available in the web server"? Just to be overly clear, here's a image from VA where I would expect the font to show up:
I highly suspect that there is some step missing (such as the proc fontreg for studio/coding) in order to make the woff version of the font available in the different Viya web applications such as VA and Theme Designer or should it just work if the font is available on the server? Any hints on what to test or do next would be appreciated 🙂
//Winter
... View more
05-03-2022
06:39 AM
I'm having the same problem (except that our Viya is running on Linux) any solution to share?
... View more
09-30-2021
12:07 PM
Hi! I'm working on a Visual Analytics report that utilize the Suppress function when calculating different measurements (If there is less than 5 observations then suppress). The end user of the report now wants to add an additional level on this logic since suppression is only required for a specific category of observations, simply put,
IF Type=B and number of observations < 5 then Suppress ELSE "calculate measurement". I've been prying at this for weeks but haven't manage to get it to work thus I wonder, is this logic possible?
Below is a simplified example
Let's establish some sample data:
Type
Observation
A
1
A
2
A
3
B
1
B
2
Imagine that I want to create a conditional Sum calculation of Observation that is always allowed to be shown when Type="A" but can't be shown when Type="B" In this case the desired result would be:
Type
Conditional Sum
A
6
B
*
Suppression is an aggregated measurement so lets simplify the problem: Is it possible in Visual Analytics to create a measurement that is the Sum of Observation when Type="A" and average of Observation when Type="B"? I've tried to express this in Visual Analytics as such:
However, when I use this calculated measurement in a table I get the following result:
In fact, whenever I try to use IF/ELSE logic in combination with a aggregated calculations it always results in the ELSE condition.
Conclusion I understand that the IF logic expressed above evaluates each row in the data while the Sum and Avg is performed "by each group" and thus it's kind of doing two very different things. I'm guessing what I'm looking for is something in the line of "IF current _ByGroup_ (Type) = "A" RETURN ..... ELSE ....." however I haven't found any operators that does that.
While the problem sounds simple, at this point I'm prepared to call it impossible due to how _ByGroups_ works but I'm hoping that I might be wrong 😄
Best regards and thanks in advance for any suggestions!
//Winter
... View more
05-25-2020
08:46 AM
The biggest problem was the connection string and the not so obvious fact that you cant use "in memory" datasets. For others that might be locking for a solution: I switched over to using the PUBLIC library for it to be a bit more universal for all users. In my case the physical location of public is /opt/sas/viya/config/data/cas/default/public/ (this can be found if you look at the library in the data manager) And my connection string is: driver=SQL;conopts=(driver=base;catalog=public; schema=(name=public;primarypath=/opt/sas/viya/config/data/cas/default/public/)) If you want to use other (PHYSICAL) libraries you can use the following code in SAS Studio to get the relevant connection strings in the log: option MSGLEVEL=i; proc fedsql; select sadasdasd from test.not_an_excisting_table /*this code generates error on purpose, we just want to see the log*/ ;quit; One of the notes in the logg should contain the relevant connection string for all physical libraries that are assigned in SAS Studio. It should look something like this: NOTE: driver=FEDSQL;conopts=((...
... View more
05-07-2020
11:08 AM
I'm trying to build a Decision Flow in SAS Intelligent Decisioning on SAS Viya 3.5 but i stumble on a key feature that I can't get to work.
To simplify things lets take a basic example: Input to the decision flow is a customer ID, in the flow I need to look up customer information from a table in our internal database. Using that customer information I will do a bunch of cool stuff but first I need to solve how to do the look up.
According to some examples the Data Query (SQL Code) node is the tool to use for this and i've written this simple SQL lookup that should collect the customers status_code and age from the customerInformation table for the specific ID that is inputted to the node:
Select
Status_code as {:Status_code :string:10},
Age as {:Age:decimal},
ID as {:ID:decimal}
from casuser.CustomerInformation where ID = {?:ID:decimal}
However, when I try to run the flow (or validate just the SQL code) I get the following error:
Some information that i've found on the web suggest that some settings need to be configured for the SAS Micro Analytics Service in order to run a Decision Flow containing SQL code, see Configuring Support for SQL Query Files which in turn points me att DS2 configurations that hints at a connection string for FedSQL connections to different databases and now i'm totally lost 🤣 All I want to do is to run a simple sql towards a SAS table in my viya database.
The first question is, is the SQL code the correct approach to enrich the input data in a decision flow with information from a table in the database?
If so, am I doing something wrong or do our environment need additional configuration? If so, what configurations are needed?
... View more
06-20-2018
02:18 AM
1 Like
That sounds like you might have some actual issues with your SAS deployment if you cant close a pop-up window, such as the "filter and sort" ,using "Cancel" or the "X" in the top right of the window. I assume that you are also unable to use the "filter and sort" as intended (fill it out and hit "Ok" to perform a filter) if that is the case.
Basically it's one thing for the pop-up window to end up of screen then moving it into view should fix your problem, either fill it out as intended and perform the filter (or other action) or close it if it was a mistake. If the window itself is frozen or unresponsive that's something else entirely.
As to why SAS haven't fixed the issue, I would speculate that the actual problem might have more to do with Windows as an operating than SAS but I have no insight in that.
For "drag and drop" functionalities i would recommend you looking into SAS Studio (that is, if your SAS is an deployed server and not just EG as a stand alone workstation) and the "Visual programmer" feature which support drag and drop of tables and a lot of tasks.
//Winter
... View more
06-19-2018
03:38 AM
Hi @suchismita
I'm currently running into this problem a lot since i use a multi screen setup on my laptop and every time I use something like the "filter and sort" or anything else in EG (or other SAS applications) which brings up a prompt it ends up on my laptop monitor (off to the side) rather than my main monitor. It can also happen after I unplug my external monitor where the program/Windows still place EG or prompts from EG "off screen".
Basically EG "Freeze" when in fact a prompt is open off screen an you cant interact with EG before you close the prompt.
Since my last post I have come to rely on the "windows key" in combination with the arrow keys such as "'Windows Key' + 'Arrow left'" or "'Windows Key' + 'Arrow right'". This moves around the selected window, snapping it to the edges of the screen/screens (works with any application, try it out with word or explorer to get a feel for it) and since the prompt is the selected windows this is the windows that we move. The aim is to spam left or right while holding the "windows key" and move the off screen windows into the same monitor/screen that EG itself is presented in.
I hope it solves the issue!
//Winter
... View more
02-03-2015
05:32 AM
1 Like
I had the same issue running EG 6.1 and although this thread might be dead I like to share my solution for anyone coming to this thread seeking answers… However I can’t take credit. I found the solution in this thread from the SAS forum where Chris Hemedinger writes: “To get to an "off screen" window that might be blocking the app, use this keyboard sequence: Alt+SPACE , then press M (for move), then use arrow keys to move window into view. If you use those keys, you should see the window outline snap right into your current display. Practice the key sequence on a window that you can see; that helps you to use it when stuck on a window that's out of bounds. Chris” Basically my problem was that I’m using a monitor and although EG maximize to the size of my monitor the filter and sort pop-up window ended up outside my FoV/monitor. As Chris describes using his solution will make the filter window snap on to your active EG window (use the solution while in the main EG window).
... View more