Hello @AliZiya  Typically change of   permissions persists reboot. However, as this is not happening indicates that something is running that resets the permissions. Work with the SAS tech Support to find if this is due to some script in SAS. If that is not the case then it is better to investigate. There is another approach, you can create a boot time script to do what you want but would not prefer this. Better to identify the root cause and handle the issue rather than   provide a symptomatic solution. ... View more

Hello Check if that is in your path. Use the following  command echo $PATH The output should have  /opt/sas/sashome/SASFoundation/9.4/sas if not run this command  export PATH=$PATH:/opt/sas/sashome/SASFoundation/9.4/sas Then try executing the SAS command as you have been trying. ... View more

Hello @AliZiya  What is your environment? Is it a cloud based installation? ... View more

Hello In the event one cannot add hardware resources, the feasible option to re examine the code /algorithm. Look for alternative approaches to accomplish the same task. ... View more

Hello @aman_rai02  As I understand it, you are using path based libraries. Make sure permissions particularly write permissions are enforced at OS level regardless of the approach that is being followed to create libraries. ... View more

Hello @jawad_at_msc  This is something that can be easily accomplished. But you will have to involve your Windows Admin/infrastructure/storage teams.  1.An additional disk can be attached to your server. While executing the SAS codes the output data sets are saved here. 2.Provide access to a shared drive. This is the final location for your datasets. You can dispense with the local disk and directly use shared drive. But this will result in performance degradation. Read/Write will be slow. ... View more

Hello @jbond007  I suggest checking up the permissions/acl on the directory. Possible discuss with the OS Admin, ... View more

@kumarsandip975  Please  try after restarting mid-tier/web applications. ... View more

Hello @jkaran321 , @AniyaSantiago  There are two important factors that one needs to consider when selection between Windows and Linux. 1.The SAS installer account needs to be a local administrator (there is a chance that other service accounts may be setup as admin account), whereas on Linux it is a standard account. 2.Second on Linux files created are not executable by default whereas on Windows they are. (One does come across the use xl2xlsx.vbs script to convert the file to xlsx format.) This is a sign of the system being vulnerable. These factors tilt the scale in favor of Linux as the OS. ... View more

Hello @Jaymod  Please see this forum post for resolution of youir issue Solved: SAS 9.4, Using 7zip to zip and encrypt a file via batch - SAS Support Communities  ... View more

There are multiple approaches to handle this situation. At the high level, a simple and easy to manage approach, which I would prefer, has the following three steps  1.Fresh install and configuration of SAS on Linux 2.Export the metadata content as packages from the source machine and import in the destination 3.Export data using Proc cport in the source and import using Proc cimport. However, the devil is in the details. The exact approach would depend on your environment. You can also use the migration utility. ... View more

Hello @pavank  Looks like you want to clarify if your method of finding the last record is correct or not. Yes it is. Often SAS provides multiple approaches to do the same thing. Anything that one is comfortable with and gives the correct result is OK. ... View more

Hello @sumi_saslearner  Have a look at the following reference https://www.mssqltips.com/sqlservertip/2771/using-sas-access-and-proc-sql-to-save-sas-data-in-sql-server/ Please note SQL server does support varchar formats whereas in SAS, CAS supports varchar but not SAS 9.4 . ... View more

Hello @thesasuser  If one is using Adding for office, and executes the code from there, the results can be exported to the excel file. Please explore this option. ... View more

There should not be any. However I would recommend configuring your server for https. ... View more