Hi Communities,   Will there be any impact if the password of the default OS accounts used on SAS VIYA 3.5 be reset or updated? example: sas, apache, sasrabbitmq, cas,? ... View more

Apologies if this is already been posted, I'm new to this. I'm trying to get 30 min interval data or to the end time for Agent activity for work. the code I have is :-   data test; set schedule2; format Mystart MyEnd tod8.; do Mystart = Start to Stop by 1800; MyEnd = MyStart + 1800; output; end; run;   This works for the most part, but it's not working if the interval end time is like 16:45:00. This is what I have :- 02-Jun-25 Sick 09:00:00 16:45:00 465 16:00:00 16:30:00 02-Jun-25 Sick 09:00:00 16:45:00 465 16:30:00 17:00:00 02-Jun-25 Meal 16:45:00 17:15:00 30 16:45:00 17:15:00 02-Jun-25 Meal 16:45:00 17:15:00 30 17:15:00 17:45:00 But what I want is :- 02-Jun-25 Sick 09:00:00 16:45:00 465 16:00:00 16:30:00 02-Jun-25 Sick 09:00:00 16:45:00 465 16:30:00 16:45:00 02-Jun-25 Meal 16:45:00 17:15:00 30 16:45:00 17:00:00 02-Jun-25 Meal 16:45:00 17:15:00 30 17:00:00 17:15:00 I know I am missing something but I cannot figure it out. Can someone please assist. ... View more

Hi all, I’m in the process of moving our analytics platform from SAS 9.4 to SAS Viya and we have several OLAP cubes built on our SAS 9.4 OLAP Server that we’d like to bring over. Could you let me know if there is a supported way to import or convert existing SAS 9.4 cube definitions directly into Viya? In particular: Is there a built-in utility or API in Viya that reads the SAS 9.4 cube metadata (.cub) and data? If not, what is the recommended best practice for re-creating those cubes in Viya—do we need to rebuild them manually, or is there a migration script/tool? Any pointers to documentation or sample code would be greatly appreciated. Thanks in advance for any guidance you can share! ... View more

"DevOps" typically means automated code deployment. ... View more

  I have used proc template and layout lattice to create two horizontal barchart panels side by side. I have two consecutive Layout Overlay Barchart lines to create the two barcharts.  layout overlay      barchart endlayout layout overlay      barchart endlayout   I also have the correct datarange union so that there is only one set of tick values on the left hand side. So far so good. My problems begin when i have different numbers of bars in different datasets (the two panels will always have the same number of bars per dataset). If i have fewer bars, the cells and barwidth expand to fill the space. If i have more bars, the barwidth shrinks to fit in the space. This i can often fix with ODS Graphics height. I also have a second problem. In one dataset, the tick values on the left are very short and in another dataset the tick values are very long. For the short tick values, the panel width expands to fill the space. And for the longer tick values the panel width shrinks to fit the space.   Can i set the panel widths (and height) in stone so that SAS will not change it?  If i need to switch to sgpanel or layout datapanel, that should not be a problem.   Thank you for your help. ... View more