Hi,   what port are you using? Has something changed there?   Can other users/clients connect to that server?   The error messages you are seeing usually indicate that the port is not open, the user ID is not valid, or the script has been "relocated"/something has changed in the script. This is not the case here as you mentioned, so I am curious if there are other users experience the same problem?   To make sure you can resolve this quickly, contacting Tech Sup might be the best next step. Am of course happy to continue working with you here, Tech Sup is just more troubleshooting savvy than I am 🙂   Thanks Anja   ... View more

Hi,   have there been any changes made to the set up, such as changing location of the script files? Are all SAS servers up and running on the prod machine/where its failing?   Could you please add the log file including the code you are submitting, resp. give some detail about how you connect? Run the program with  options symbolgen; to see if we can get as much detail as possible (if you havent done so yet)   Thanks Anja ... View more

Hi there,   curious about the changes of a user's group membership and permissions: you mention that a txt file is read on a daily basis. Does a group membership or permissions for a user change frequently? Where is that txt file coming from, how is it created?   If I understand this correctly, the batch program you are looking for would have to compare, delete, change permissions and add the user to a new group?   The bulkload / examples Kurt suggested could help you with this as you can modify it to your needs.   Thanks Anja ... View more

Hi,   I am not sure you can create such a time defined event in Env Manager. What you could try is using one of the Stored Processes from the Report Center (In Env Mgr, Analyze, Report Center), modify it and then schedule it. See http://go.documentation.sas.com/?cdcId=evcdc&cdcVersion=2.5_M1&docsetId=evug&docsetTarget=p1ddtcqw03w6zsn1u8i0xgm6dz4n.htm&locale=en     The Stored Processes itself can be accessed via SASMC. http://go.documentation.sas.com/?cdcId=evcdc&cdcVersion=2.5_M1&docsetId=evug&docsetTarget=p04sg86zvv5xyen1ohkrm3fv9maf.htm&locale=en   Thanks Anja   ... View more

Good morning,   lets see of i can help with this ...   A metadata-bound Library is a physical library that is tied to a corresponding metadata object. So when you create a metadata-bound library, SAS generates a new metadata object and binds the physical library to that object. A user must have permissions for whatever action is requested, and at the same time, the corresponding OS id has to have the necessary permissions on the physical table.   If you'd copy data from a metadata-bound lib to another location on the OS, the security information on that tables is still "active", meaning, the information is being copied with it. See http://support.sas.com/documentation/cdl/en/seclibag/66930/HTML/default/viewer.htm#n14a0xp98mxlrgn1goddjmjr3ahf.htm   As for encryption: SAS encryption works for data in transit and data at rest. Data at rest means encryption for passwords of  configuration files, metadata repositories, SAS code, SAS data sets, SAS HDAT in Hadoop and SAS Performance Data Engine & Server (SPDE & SPDS) data. Data in transit includes connections between SAS clients and SAS servers as well as browsers and  SAS servers. It further includes encryption of data betweeen server to server, including  SAS servers or SAS servers and Third Party servers. The data sets in a metadata-bound libs are autmatically encrypted with the SAS proprietary encryption. This encryption happens automatically with all data sets, whether bound to a lib or not. If AES is added as stronger encryption key, it has to be added to the data in the metadata-bound lib.   I am not quite clear whether your mentioning of encryption is a question ?   Does that help? Please let me know in case of any further questions.   Best Anja ... View more