SAS 9.4 based software is deployed using the SAS Deployment Wizard. The SAS Deployment Wizard has a record and playback feature allow it be executed without end user interaction. See https://support.sas.com/documentation/installcenter/en/ikdeploywizug/66034/PDF/default/user.pdf check page 12 for details. Ansible could be used to invoke the SAS Deployment Wizard on the system but it will need to be the SAS Deployment Wizard with a response file that installs the software. ... View more

Presently there is no component or feature provided by the SAS platform to handle this. There have been some discussions about this feature here at SAS for some time. Right now there is nothing from SAS for you to use for this task. ... View more

SASKiwis idea will work if you don't need to retain the first case in the data. Here is what I cam up with. This uses a hash object so will only scale to the size of the available memory on your system.   data have; length ID 8 FirstName LastName $8; input ID FirstName LastName; cards; 001 John Reed 001 JOHN REED 002 Mitchel James 003 Steph Ania 004 King Mon 004 KING MON 005 Valery Short 012 ALMA JACOBS 012 Alma Jacobs 017 Josh Ryan 017 Jash Ryan ; run; data want; if _n_ = 1 then do; declare hash h(); rc = h.defineKey('ID','FirstName_upcase','LastName_upcase'); rc = h.defineDone(); end; set have; FirstName_upcase = upcase(FirstName); LastName_upcase = upcase(LastName); rc = h.find(); if (rc ~= 0) then do; rc = h.add(); output; end; keep ID FirstName LastName; run; This will keep the first observation with unique spelling and retain the case. If the varaible was "JoHn" in the first observation the propcase method would make this "John". ... View more

Something is up with the image pull secret. If nothing changed with that deployment then there has been something changed with the order/entitlements. Would be best to reach out to SAS Technical Support for help with this one because an engineer will need to look into the sites orders and check the entitlements. ... View more

This is not anything related to SAS Administration nor Deployments. The only thing roughly making this something interesting to SAS users in this community is your question is about doing something with data on a SAS hosted platform.   There is nothing built into any SAS product to do this. If the source of the RTF is SAS ODS, simply update the program to use a PDF destination in addition to RTF. If the rtf file is produced outside of SAS then your only chance would be to find a package supported by Red Hat that can accomplish this.   My quick search reveals there is a possibility for LibreOffice to have an ability to take an RTF files and convert it to a PDF. See the --convert-to argument in the LibreOffice documentation here. ... View more

P.S. Hi from Australia!!!!11 ... View more

If your deployment was done manually. Follow the steps to Add a Mirror Registry to Your SAS Viya Platform Deployment. Once you do this your site.yaml will have update image references. If you have the deployment operator involved I would imagine all you need to do is update the deployment operator using following the Configure the Mirror Registry. Once that is done your next deployment will use the update registry. ... View more

My first thought that came to mind was the graphic that I've spotted on some stickers "There is no cloud, its just someone else's computer".   Jokes aside there isn't a whole load extra to consider over and above all the other typical considerations that have to be made for any SAS deployment. You still have all the big questions to answer. Sizing, architecture, data access, authentication & authorization, availability, backup and restore, disaster recovery, dev/test/prod environments... all these questions still need answers whether you deploy to the cloud or not.   Deploying to the cloud might see you adjust some of the design choices but big picture whether you are deploying to the cloud or not you typically end up with a similar type of deployment.   There is a good whitepaper about SAS and Cloud Computing.  Important Performance Considerations When Moving SAS to a Public Cloud ... View more

You will need a macro loop to iterate over tables in the library. Here is some sample code that might help. You'll need to update the WHERE clause and then add the code that you want into the loop.   proc sql; select catt(libname,".",memname), count(*) into :table1 -, :table_cnt from sashelp.vmember where libname="WORK" and memtype="DATA"; quit; %macro myloop; %do i = 1 %to &table_cnt; %put Working on &&table&i..; /* Your code here */ %end; %mend; %myloop; ... View more

Kept code spelunking for you. The file service has a special flag you pass it to tell the service that you want the contents of the users home. The "ListFilesModeUser" flag is what is used in the schedule manager plugin to start the navigation at the users home. Sensible so far.   The file service uses some other code to find the home directory of the user. There are different implementations for the various operating systems. On Windows the function to find the users home directory looks up the shell variable SASUSER and returns this path, if its unset the current working directory of the process is used. Not entirely sure why its done like this but  I guess the reasoning is that SASUSER is 99.99% of the time in the users "My Documents" folder on Windows by virtue of using the result of the Windows SHGetKnownFolderPath function for FOLDERID_Documents at startup because of the default value of SASUSER is set like this: -SASUSER "?FOLDERID_Documents\My SAS Files\9.4".  On Linux/UNIX the ~ path is expanded and used. You could change the default path by setting the Windows shell variable SASUSER to some other path. It not advisable, good chance that breaks stuff in your SAS session. Many places in SAS (and user written code) likely assume the shell variable SASUSER references the filesystem location of the SASUSER library. If this is causing huge amounts of pain then give me a call tomorrow, or when you are free and we can talk about this. I'm sure we can find an elegant solution to whatever is causing you problems. ... View more

There is a IOM method driving this file chooser is the ListFiles method offered from the FileService. See https://support.sas.com/rnd/javadoc/93/iomzipij/sas/dev/mva-v930/tkiomc/grm/filesij.html. The doc is brief but you get a rough idea what the developer has to work with. The difficulty for both the Workspace Server developers and also the Schedule Manager plugin developer is what is a valid path to start with? The plugin in the management console leaves the path argument empty to leave it to the service to return some valid location to start with. When the workspace server starts and this service is leveraged it has to return a valid path and files. I mentioned %MYSASFILES% was the default because it lined up in my lab. I don't actually know what the workspace server developers pick when path is an empty string but you can imagine the challenge. If you had to build a file chooser to select files on the SAS server how would you decide a valid filesystem location to start browsing? ... View more

You are the only user of CAS in the world to report this crash. The likelihood of someone in this forum having encountered this and addressed it is very slim. Please be patient with Technical Support, with persistence we'll be able to get the bottom of this. ... View more

Just noticed you are talking about the browse for source code button, not the deployment directories. This uses the file service offered by the SAS Workspace Server. The schedule manager plugin does not include an override for where to start this search from, its using the default path of the file service. On Linux it looks like this path defaults to $HOME, on Windows %MYSASFILES%. ... View more

There is a SAS metadata directory object associated with the application server context. This is where the default path comes from.   It doesn't appear to be something exposed through the user interface (SMC). I'm not sure its a good idea to change it.   EDIT: You can update it inside the Schedule Manager plugin inside SMC. You right click the plugin, click "Deployment Directories". You get a UI to view this metadata and update it. ... View more

My first reaction is enable workspace server logging and post process workspace server logs. Do you have specific metrics you are trying to extract about users activities? ... View more