SAS Platform Admin Blog

Question: Is it possible to highlight syntax in Notepad ++ for SAS Program and run it directly from Notepad++. Somehow I have found info about SAS color coding in notepad++, however is there a way to run SAS code from it? Answer: Yes there is way to run SAS code from Notepad++. 1. Make Notepad++ as your default app to open .SAS file which is your SAS program file. To do that right click on any of .SAS file and choose "Open With...". Then choose Notepad++ and check the "Always use this app" checkbox. Do the same for SAS log file .log file and .lst file which is not mandatory. 2. To run SAS program from Notepad++, press F5 or in the menu bar click Run -> Run..., it will open a Run dailog box. In the input feild, use the following command: "C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -sysin "$(FULL_CURRENT_PATH)" -log "$(CURRENT_DIRECTORY)\$(NAME_PART).log" -print "$(CURRENT_DIRECTORY)\$(NAME_PART).lst" ...

Question: We have installed SAS 9.4 M4 Visual Analytics (VA) on a single Windows 2008 server. We need to change the password for the sasevdb user. How to change password? Should this be done using the SAS Deployment Manager (SDM)? How can we reset the Postgres password ? Answer: All the SAS account password should be changed with the SAS Deployment Manager. Password can be changed using Deployment manager for every single component that is part of the deployment. Once you use SAS Deployment Manager to reset the password, you need to restart the environment. This is the general rule in SAS. Eventually, there could be some additional configuration file missing from this change. Therefore you may need to use grep utility. File handled by each maintanance differes and there are more files handled by the SAS Deployment Manger Change password tool. So for your need just with the SDM should be enough for putting the system to be working again. However I would suggest you to use gr...

Question: We need to collect user activity some information and turn them as a report in SAS. We are expecting report such as when a user connect to sas dataset, name of the table user accessed and changes made to the user on that table? Answer: SAS by default provides several ways to audit the access to its components. This question in about SAS Dataset components (ie) access to the data. This requirement is more popular as SAS are widely used in banking, clinical where the data access needs to be audited. To achieve the report that you are looking for you can check SAS Logging Facility. There are several options which you can enable in the Workspace server or any other SAS servers. This options will allow you to customise the way you want. Genrally, a good option is that if you have middle tier in your deployments, is to enable the EMI framework and then set up the Audit Performance and Measurement (APM) tools (optionally, also ARM for performance monitoring, and VAfeed, to...

Question: Our client machine has ran out of space on his workstation due to SAS creating a whopping 500GB log file. The log file is located under AppData and the file name is Aria-debug-5800.log. The file got created during the time the client had licensing issues. We fixed the licensing issue by simple reapply of the license file. I assume these issues are correlated. I wanted to know if the log file safe to delete and how can avoid this event to happen again? I assume it doesn't contain very critical information since the log file is created only couple of days back, but I would prefer to have a confirmation first. Answer: It looks like it is not related to SAS software. Googling the log name aria-debug log suggests this may be an issue with Microsoft OneDrive. Just check if the log in the generic %AppData% directory, or the SAS specific %AppData%\SAS. SAS related file will be stored under %AppData%\SAS.

Question: We are facing issues with our SAS Web infra Structure data server. So We always have to monitor by checking the service status. We have read in some documents about pgpool-IWe tool which monitors the Web data server. We have already a sas 9.4 M3 installed distributed platform in which We have SAS Metadata and SAS Mid-Tier installed in same machine. Looking for some ideas to manage and monitor Web Data Server. Answer: SAS provides SAS Environment Manager which can be used to monitor the Web Data Server. There is option to create an event which monitor that particular component and eventually alert/email you if there is a problem.

Question: We are planning to configure SSL for using https for the web application SAS Contextual Analysis. We have alread installed Web Server and a Web Application Server for Contextual Analysis and it up and running. We are planning to configure https with SHA2 encription. How should we do that? Answer: Below is the high level steps involving certificate installation in SAS to enable https: 1) Stop the Web Server and Web Application Server 2) Modify the server.xml for the Web Application Server and configure for the .keystore - File and the Certificate 3) Modify the httpd - file for the Web Server and then change the httpd-ssl - File 4) Restart both Servers 5) Work with network team to configure the Firewall Ports if needed 6) After configuration is done application should be reached via https within the browser If you look at SAS documentation, it is recommended to use the SAS Deployment Wizard to configure the SAS Web Application Server to install certificate for TL...

Question: Is there a way to run SAS in parallel on a SLURM-based Linux cluster computer using the "job arrays"? In the below link I have find way to run jobs in parallel but it is not for SAS. https://rcc.uchicago.edu/docs/running-jobs/array/index.html Specifically, I need to pass a SLURM environment variable SLURM_ARRAY_TASK_ID from my batch shell script to SAS. Answer: To run parallel on SLURM either add: export SLURM_ARRAY_TASK_ID to your shell script before starting SAS, or use the -sysparm option to hand SLURM_ARRAY_TASK_ID over on the SAS commandline.