Start here:   SAS Statement Regarding Remote Code Execution Vulnerability (CVE-2021-44228)     ... View more

Down side to this approach is APPEND doesn't process the base data, where as datastep will So if you only need to append a few observations to a large base dataset then data step will be less efficient. ... View more

If you don't get a response then I recommend opening a TS track for this question. Please include the following: - SAS Version you are running (the following code will report SAS version information) %put &sysvlong ; %put &sysscpl ; %put &syssite ; - Registry Report (*.txt files) for each server, please clearly name the report files to reflect the server it was executed on. ... View more

Did you try the Schema option? LIBNAME Statement for the PostgreSQL Engine  SCHEMA= LIBNAME Statement Option    ... View more

Take the PROC SORT out of the macro and hard code the values. Then run it for each case, and check you're getting the results you expect proc sort data = adam.adce out = adce_c1 ; by usubjid; where saffl='Y' and cedplddy=2 and 0<=cedpld>=14 ; run; proc sort data = adam.adce out = adce_c2 ; by usubjid; where saffl='Y' and cedplddy=2 and 0<=cedpld<14 ; run; ... View more

You are probably going to need to open a TS track for this  Please include the following: - SAS Version you are running (the following code will report SAS version information) %put &sysvlong ; %put &sysscpl ; %put &syssite ; - Registry Report (*.txt files) for each server, please clearly name the report files to reflect the server it was executed on. Please provide more context on the issue Has this been working in the past When was it last working What changed Do you know it works for the same user with 15 NFS groups in Linux x64 I did search existing tracks and found this (no idea if it helps) I think we found the issue which is an NFS export option. The option for more than 16 user groups over NFS is not enabled on this NFS export.       ... View more

The error message indicates it's a user/password issue, but you appear to have tested that based on " I can access the login ID and password page with below URL." I recommend you open a TS track for this question. Please include the following: - SAS Version you are running (the following code will report SAS version information) %put &sysvlong ; %put &sysscpl ; %put &syssite ; - Registry Report (*.txt files) for each server, please clearly name the report files to reflect the server it was executed on. - The code - The full log - Has this been working in the past, if so when was it last working, and what has changed?   ... View more

There are multiple ways to read Excel files into SAS e.g. Comparing SAS LIBNAME Engines for PC Files Data  ... View more

@EyalGonen Can you post your question in English, you are more likely to get a response then. I ran google translate on it, and it looks like you are asking about Using Regular Expressions in PROC FORMAT there's a link on that page to an example: Example 10: Creating a Format Using Perl Regular Expressions  ... View more