At this time there is not a way to pass parameters to a Viya Job without going through Java Script with Data Driven Content. Viya does include a number of statistics and machine learning objects which you can interact with controls/filters, but you are unable to see raw predictions in real time if you add those filters. As a result, the only way to see changes to raw predictions from models is to build them into a Viya Job that pulls the values of filters from Data Driven Content.   The first report is available on GitHub. A JSON package to import it is here. I'll tag @acordes to see if it's possible to provide an example report for his example of using Data Driven Content to run a job.   What you are describing is a great idea for VA. I'll run it by our R&D team. ... View more

Hey @GeorgevdW! You might want to look into a Targeted Bar Chart. You can add a target for each value that you need. To do this, you'll have to build the target into the dataset. You also won't be able to use a Group, but as an alternative, you can use  lattice columns.   Product Year Size Target A 2017 10 12 A 2018 20 15 A 2019 30 34 B 2017 40 45 B 2018 50 48 B 2019 60 55 C 2017 70 80 C 2018 80 75 C 2019 90 89       If you have multiple values that you're aggregating, simply repeat the target value for each row in the data and then set its aggregation to Average. Since Visual Analytics aggregates automatically, this will ensure that the target value is not summed and remains the value you expect. ... View more

I believe the trial environments are behind a firewall and might not be able to talk to the outside world. There is a chat icon in the trial environment where you can get support to help out. This is the best and fastest place to go. Alternatively you can email support@sas.com and they can help you. ... View more

You sure can! There are a number of ways to do this, but it sounds like you'd most likely be interested in using a Viya Job with a Data Driven Content object. Check out @Renato_sas's article about using jobs with Data Driven Content. It's a great way to pass data, filters, and parameters down to jobs which can then interact with the data directly.   https://communities.sas.com/t5/SAS-Communities-Library/Introduction-to-Integration-of-SAS-Visual-Analytics-with-SAS/ta-p/670823   If you're curious about how to get that data to update in real-time, check out this SGF 2021 paper: https://communities.sas.com/t5/SAS-Global-Forum-Proceedings/Modernizing-Scenario-Analysis-With-SAS-Viya-and-SAS-Visual/ta-p/726348   @acordes showed a great DDC example that passed parameters into a Viya Job with VA controls and then ran some IML code to create new data for scoring.   ... View more

Hey there again @sc5! Unfortunately there is not a way to access these coefficients programmatically the way that you are describing. You are correct that the coefficients do display when you maximize the object and the values will dynamically change with controls, but currently they are only visible within the Analysis section of the maximized scatterplot. Since the scatterplot supports a matrix of scatterplots, you will receive a line and set of coefficients for each combination of values. ... View more

Hey @sc5! When you derive predictions from a modeling object, you are effectively generating the score code for that model. As an analogy, it would be like saving the coefficients and putting them in a DATA Step for prediction. As a result, the predicted values that you get are based on the model that you built at the time you selected "Derive Predicted." Your model will dynamically change, but the derived predicted values are static until you derive new predictions.   I would recommend putting a product request for this feature. Effectively it sounds like what you want to do is have the ability to derive predictions from the most recent model that has been added and have it auto-update the derived predictions - that is, whenever the model changes, so do those predictions. Note that for some models that are non-deterministic, predictions will change when data is reloaded. ... View more

Hey @krishnaavm123! This is a feature that is coming soon in Viya. You will be able to create parameters that represent the start and end range, then use them in calculations. You will no longer be restricted to assigning a single parameter to a slider, and the slider's range will be dynamically created based on the data item assigned to it. But that's just a small sliver of what you'll soon be able to do with parameters 😉 Stay tuned to What's New in Visual Analytics! ... View more

If you'd like to still show HTML, remove the "ods html close" line. ... View more

I do not see any issues within your code. Can you try running the code and job parameter settings that I have posted and see if it works? You do not need to use a form for it and it will run as-is. That can help diagnose if there's something going on with your code or something going on with your browser. ... View more

It looks like your macro variable for &condition is not resolving and is returning a blank date, resulting in no rows being selected. You may need to check your input form to make sure a date is being passed through correctly. That may be why the downloaded Excel file is not valid. Try hard-coding a valid date that returns data to test that the download works as expected. ... View more

Hey @Deep04! STPs and Viya Jobs are very similar, but you'll need to make some changes to download data as an Excel file. I assume you're looking to have this available in Visual Analytics for convenience or as a part of another report.    To write a file to an Excel file that will download to the user's desktop, there are a few things you need to do to your code. The best way to explain this is through an example. Here is code below that will send the results of PROC PRINT to an Excel file that downloads in your browser.   /* Write an Excel file to the job using the filesrvc access method. The job will handle the rest. */ filename excelout filesrvc parenturi="&SYS_JES_JOB_URI" /* URI of the job that we're currently running */ name='_webout.xlsx' /* You must write to _webout.extension. The filename is controlled in contentdisp. */ contenttype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' /* Content type */ contentdisp='attachment; filename="my_excel_file.xlsx"'; /* This is an attachment called my_excel_file.xlsx */ ; ods html close; ods tagsets.ExcelXP file=excelout style=htmlblue; proc print data=sashelp.cars; run; Use the following parameters for your job:   It's very similar to what you did with STPs, but a little more streamlined. Mostly everything you need to do is done within a filename statement with the filesrvc access method. Many of the macro variables and things you used to set are no longer needed, but many of the familiar names you used are still there (like _webout).   Now if you want to get really advanced, you can use Data Driven Content and pass things from Visual Analytics into the job. That's a pretty complex topic but if you want to learn how to do this, check out the Advanced Scenario Topics section of my paper Modernizing Scenario Analysis with SAS Viya and SAS Viusal Analytics. ... View more

@Actuality that is correct. Version 8.5.2 does not have list control text searching as it was added in a later version (2020.1.1). SAS switched to a monthly release cadence starting in 2020 and has named its versions based on that monthly cadence. You can, however, use a text input and use it to search for the text in a list control as a workaround. You can replicate most of the functionality using parameters. Check out my video on parameters to see how to do this at 3:07: https://m.youtube.com/watch?v=iMtoJXDZVRk&pp=ygUcUGFyYW1ldGVycyB2aXN1YWwgQW5hbHl0aWNzIA%3D%3D   ... View more

It looks like you found it 🙂 You are using Visual Analytics 8.5.2 on Viya 3.5. The version is found by opening the menu in the top right-hand corner of the screen, then selecting "About." You should see a pop-up window as shown below.   Text searching in list controls was added in 2020.1.1 .   ... View more