Unfortunately it is not possible at this time as the report control section is reserved only for report controls. I recommend posting this feature request in the SASWare Ballot page. I'll also pass this along to Visual Analytics Product Management so that they are aware of this need. ... View more

Hey @KOKIUSMAT! While you cannot add any images or links to a report control section, you can add headers to each page. I recommend adding a header to each page that you'd like to have the header shown.   To add a link to an image: Drag an Image object onto the report and load an image to it Click the image object. In the right-hand pane, select "Actions." Expand the "URL Links"  section and click "+ New URL Link"   Add your URL and click OK   To add a link to text: Add a new text object  Type in some text Highlight the text, then click the "Add URL Link" button: Add your URL, then click OK OPTIONAL: Links in Visual Analytics are colored black and underlined. If you'd like to use a traditional blue URL link, change the text color to #0000ff, located about far-left-center in the color picker within Visual Analytics.   ... View more

Hey @KOKIUSMAT! You sure can. This is called data mapping in Visual Analytics. If you have multiple data sources with identical columns that you would like to have interact with each other, you can map them together. To do this: Add the two tables to a Visual Analytics report In the Data Pane, select the Data source menu and click "Map data..."   Click "Enable data mapping" for each data source and add columns to map using the + button. Visual Analytics will automatically map same-named columns for you. These columns can interact with each other in filters, actions, etc.   ... View more

Hey @vallsas! There is a way you can minimize the impact to reports by changing how you load and promote your data.    Typically when people update a report, they do the following order of operations: Drop the old table Load and promote the new table While the old table is dropped, the report is unavailable. This is fine if the report updates in the middle of the night, but can result in a lot of questions during working hours.   An alternative is to load the updated table to a temporary caslib, drop the old table, then promote the new table. Promoting is very fast, even for large tables. What you'll do instead is: Load the new table to CASUSER Drop the old table Promote the new table from CASUSER to your final caslib The downside is you'll temporarily have two copies of the table in memory at once. If you have a lot of memory or if the table is small then this shouldn't be a problem.   Your code will look like this: cas; caslib _ALL_ assign; proc casutil; load data=have casdata='have' outcaslib='casuser'; droptable casdata='have' incaslib='mycaslib'; promote casdata='have' incaslib='casuser' outcaslib='mycaslib'; save casdata='have' incaslib='mycaslib' outcaslib='mycaslib'; quit;   Let's test it out using a sample dataset with 100 million rows: cas; caslib _ALL_ assign; data have; do i = 1 to 100000000; output; end; run; data casuser.have; set have; run;   Checking the log, this took about 21 seconds to load to CAS: NOTE: There were 100000000 observations read from the data set WORK.HAVE. NOTE: The data set CASUSER.HAVE has 100000000 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 20.83 seconds cpu time 18.45 seconds   Let's take this table that's already in CASUSER and promote it to Public: proc casutil; promote casdata='have' incaslib='casuser' outcaslib='public'; run;   Finally, let's check the log: NOTE: Cloud Analytic Services promoted table HAVE in caslib CASUSER to table have in caslib public. NOTE: The Cloud Analytic Services server processed the request in 0.160539 seconds.   It didn't even take one second to move the data between caslibs! If reducing downtime is your goal, loading to CASUSER first and then promoting to your final caslib is the way to go. Just be sure you have the memory to do it.     ... View more

In Viya I would register the model to Model Manager, then save the scoring code as a .sas file in a folder within SAS Studio. From there, you can schedule it to run as a job in Environment Manager. Your code can then run on a regular batch schedule.   In SAS 9.4 we would use a dedicated scheduler, like Cron in Linux, to run SAS jobs. Since Viya has a built-in batch code runner, we don't need to use it anymore. A great paper on best practices for scheduling in Viya can be found below:   https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4248-2020.pdf   How to run a pipeline in batch can be found here: https://go.documentation.sas.com/doc/en/vfcdc/v_015/vfug/n194n9wnp2xokzn15f9gwn3ejtjo.htm   Your general code flow would look like this:   <copied batch score code goes here> caslib _ALL_ assign; proc casutil incaslib='myvacaslib'; droptable casdata='mytable'; quit; data myvacaslib.mytable(promote=yes); set modeloutputcaslib.mymodeldata; run; proc casutil incaslib='myvacaslib'; save casdata='mytable' replace; quit; ... View more

You can use the cmovave transformation operation in PROC EXPAND:   proc expand data=have out=want; by zone; id time; convert demand = avg / transform=(cmovave 3); run; If you want a pure DATA step approach, you can calculate a lag and lead, then divide. Attached is a program that will let you calculate leads efficiently.   %lead(data=have, out=have_lead, var=demand, by=zone); data want; set have_lead; by zone time; lag1_demand = lag(demand); /* Calculate the denominator and do not set lags for the first value of zone */ if(first.zone) then do; n = 1; lag1_demand = .; end; else n = 3 - nmiss(lag1_demand, lead1_demand); avg = sum(demand, lag1_demand, lead1_demand)/n; drop lag1_demand lead1_demand n; run;   ... View more

Unfortunately there is not at this time with the exception of doing the data prep beforehand. For example, before loading your data into CAS/LASR, you can loop through an array in a DATA Step to set any missing values of specific variables to 0:   data foo; set bar; array var[*] var1 var2 var3; do i = 1 to dim(var); if(var[i] = .) then var[i] = 0; end; drop i; run; I would recommend posting this request in the SASWare Ballot as an idea. Thank you for your feedback on this - I have noted it down. ... View more

Hey @filippo_kow! In VA this would be a new calculated item. You'll do this by going to the Data tab and selecting "New data item," then "Calculated Item" from the drop-down menu. You can then get your individual day/month/year values by using the functions shown in my previous post. You will create one data item for each part of the date (e.g. one for day, one for month, and one for year).     ... View more

Hey @filippo_kow! One way to get around this is by hard-coding your name of your report and who made it into a text box, but you can use dynamic values for the date. An easy way to do that is to extract each date value from your table, then set each aggregation to average. For example:   Year:  year('date'n)   Month:  month('date'n)   Day:  dayofmonth('date'n)       In your dynamic text box, you can add each value by selecting them as Measure roles:   Sample Report create by Joe Black. Last Updated: {year}-{month}-{day}   The date will dynamically change as your data changes.   ... View more

Hey @SaiKrishna3! It looks like you're trying to apply an error percentage, but you'd like to do it by group. The best way to do this is to calculate your error percentage as a standard, unaggregated measure:     ('Actual'n - 'Predict'n) / 'Actual'n     You can then create a box plot for each by-group with the Category or Lattice data roles. Box plots do not support aggregated measures. Aggregating data and applying it to a box plot will produce a single point, and aggregating a box plot to a specific by-group will create a set of points for each group but they will not necessarily be helpful for interpreting your percent error as a single box plot. In that case, you're better off using a bar chart grouped by a category to get the average error of each group.   If you want to focus only on a specific by-group, it is best to add a filter / control that lets you select the specific group of interest.   My personal recommendation is to use a histogram for interpreting error for normality assumptions and reviewing extremes. ... View more

Hey @dchaubey1! There are a few ways you can visualize categories with box plots. If you want to simply break out your data by a single category, then the category data role is what you want: If you want to visualize it by multiple categories, such as a matrix of box plots, you want to use the lattice rows or lattice columns data roles:       You can even add categories to your lattice roles:         ... View more