SAS Platform Admin Blog

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.

Question: I would like to install SAS 9.3 on my laptop 64 bits on Windows 10 OS, but the application does not support the platform. Is there any work around? Answer: SAS started supported Windows 10 as of the third maintenance release of 9.4 (9.4M3). So if you are using older version of SAS then it can't run in Windows 10. Only way is to run from Windows 7 version using VMWare. For information on supported products on Windows 10, you can check the  below link.  http://support.sas.com/supportos/list?requestAction=summary&outputView=platform&sasrelease=&platformGroup=Windows&platformName=Windows+10

Question: We are getting below error while executing the SAS Mid tier services script while starting. Starting SAS Web App Server: SASServer11_1 (this can take a while) /sas/config/mid/Lev1/sas.servers.mid: line 192: [: users: integer expression expected waiting 30 ... /sas/config/mid/Lev1/sas.servers.mid: line 192: [: users: integer expression expected waiting 30 ... /sas/config/mid/Lev1/sas.servers.mid: line 192: [: users: integer expression expected waiting 30 ... /sas/config/mid/Lev1/sas.servers.mid: line 192: [: users: integer expression expected waiting 30 ... /sas/config/mid/Lev1/sas.servers.mid: line 192: [: users: integer expression expected waiting 60 ... /sas/config/mid/Lev1/sas.servers.mid: line 192: [: users: integer expression expected We open the script using VIM editor and checked in the line 192 ,there is only a if then statement which an we believe it is a valid one.    ROLLCHK=`ls -l $SASWEBAPPSRV_DIR/$SASWEBAPPINSTANCE/logs/server.log` #...

Question: Our site have a Windows server installation of SAS 9.4 TS1M5. We access it from remote desktop mode (i.e. we remote into it and open SAS Enterprise Guide or DM to run stuffs, or schedule batch jobs via sas.exe).  No mid-tier, just a single server.   I found out about SAS Studio Basic at MWSUG, and needed to check if we could set it up to allow connections in SAS Studio rather than having to remote in. Subsequent to introducing M5 update with Studio 3.7, we set it up to incorporate SAS Studio Basic; it appears to begin, and I can connect to localhost:38080 with no issue. However, I don't seem to be able to connect from my local machine.  I've got the Server team looking at things, but they think the ports are fine; there's an opening for 38080 both inbound and outbound, and sasstudiohost.exe is allowed for all ports on the domain (I'm testing from the domain).  But I still get "server not found" when I try to connect to the server from my loca...

Question: Below is the code I am using to connect to SAS Open Metadata Interface: MdFactory factory = new MdFactoryImpl(false); MdOMRConnection mdOMRConnection = factory.getConnection(); mdOMRConnection.makeOMRConnection(connectionInformation.getHost(), connectionInformation.getPort(), connectionInformation.getUsername(), connectionInformation.getPassword()); I am getting following Exception: Caused by: com.sas.metadata.remote.MdException: None of the requested encryption algorithms are supported by both peers: AES   at com.sas.metadata.remote.MdOMRConnectionImpl.makeConnection(MdOMRConnectionImpl.java:1385)   at com.sas.metadata.remote.MdOMRConnectionImpl.makeOMRConnection(MdOMRConnectionImpl.java:1225)   at com.sas.metadata.remote.MdOMRConnectionImpl.makeOMRConnection(MdOMRConnectionImpl.java:294) Caused by: org.omg.CORBA.BAD_PARAM: None of the requested encryption algorithms are supported by both peers: AES  vmcid: 0x0  minor code: 0  complet...

Question: I have following questions about logging, one for SAS EG and one for SPDS 1. Is there any possibility to save the EG log and display it in the Enterprise Guide log tab? Is this something that can be set via an autoexec or do I need to do it as part of coding. I have already tried using below procedure proc printto log=""; run; This works quite nicely but I don't get the log in the EG-Log tab anymore. 2. Is there any option to activate logging facility on only one specific SPDS or SAS library? We would like to setup our environment to see which metadata user is accessing which table. Also, we would like to see which specific columns were accessed (however this feature is not much important). I'm using SAS 9.4M2 and SPDS 5.1 Answer: For #1, the logging you are looking for can be achieved by modifying the logconfig.xml of the workspace server. Please check SAS document for logconifg.xml. For #2 and SPDS: You can explore the default logging on...

Question: Wondering if anyone can help me with answer to this question. We have set up a new SAS server, we have a service account with "Login as batch job" permission setup for the connection to SASApp. In the User Manager in SAS Management Console, we have multiple users and groups setup for access. Our problem is, while the service account can be used to connect to SAS App and the user accounts can be used to make the initial connection to the server, the users don't want to have to enter in the credentials of the service account each time they open up SASApp. Other than using the SASApp account for both the initial connection, I can't think of any other way to cache those credentials (if that's even possible). Additionally, is there any way users who can connect to the server can use SASApp without having that "Logon as batch job" permission? We have a multitude of users who will be using this server (along with many who will be added on down the ro...

Question: This question is related to SAS version 9.4. There is one instance of Linux (Redhat Enterprise Linux 7) test server where we have installed SAS 9.4 and the post configuration is completed for Lev 1.  I got the prompt and able to write SAS Code. Now, I want to run SAS job in batch mode with command line like (sas sas-program-name.sas), what are the configuration that needs to be done? Answer: Keep in mind that you have to use the absolute path if the directory of an app is not in your PATH variable. For example: /path-to/sas sasprogram.sas Additional options can be used like this: To write log: -log saslog.log To use a specific config file: -config sasv9.cfg Example:  Below is how I run sas from Windows in command line: c:\Program Files\SASHome\SASFoundation\9.4\Sas.exe” -sysin c:\SASPrograms\prog1.sas -config ”c:\Program Files\SASHome\SASFoundation\9.4\sasv9.cfg Below is the code I used to run from Linux: /sas/config/Lev1/...

Question: When validating the SAS Server from SAS Management Console, I received the following error: The authentication server is not SETUID ROOT.  So, I ran the setuid.sh utility and restarted the services many times. I just checked the elssrv sasauth sasperm setuid bit. There were no error in sasauth-debug.log, sasauth-access.log, sasauth-error.log.  Any suggestions? Answer: Please do the following:    1) Run /<SASConfig>/Lev<X>/ObjectSpawner/ObjectSpawner.sh stop  2) Edit /<SASConfig>/Lev<X>/ObjectSpawner/ObjectSpawner.sh and add the code shown below right after SCRIPT=`basename $0`:  if [ -n ""$TKPATH"" ]; then  unset TKPATH  fi   if [ -n ""$TK_PATHLIST"" ]; then  unset TK_PATHLIST  fi    3) Run /<SASConfig>/Lev<X>/ObjectSpawner/ObjectSpawner.sh start  The above code change in ObjectSpawner.sh should fix the issue.