Hi experts,   I have sas installed on linux and sometimes I need to find out what process is filling the work area, whether due to bad programming or something else. I go into Linux and run the top command to see the running processes, but I can't find a way to distinguish the process that may be causing the problem.     ... View more

Hi Experts,   I'm generating a fix file, using a sintaxis like this data _null_; set filexyz; file '/data/filexyz' TERMSTR=crlf; put @1 account z10. @11 namex $20. @31 branch  z5. and the result is something like this: 1234      Robert A            56789 1234      Robert B            56788 as you can see there are 35 characters fixed, but when  ñ appears in the name, the result of the length of line is 34 characters 1234      Robert Ñ           56788   I appreciate too much your help, if you have any idea to solve it    ... View more

Hi guys,   I have this format date: 04Apr2023 9:51:00  and I want to convert into this format, keeping the time   04/04/2023 9:51:00  Do you known any format type I could use? ... View more

Hi experts! I'm executing a sas program from linux command line, example: /sas94/sashome/SASFoundation/9.4/sasexe/sas program.sas I have to assign a libname to connect a sql server database to obtain the data, but I have this problem    ERROR: Could not load /sas94/sashome/SASFoundation/9.4/sasexe/sasodb (32 images loaded) ERROR: /sas94/sapiq160/IQ-16_0/lib64/libodbc.so: version `VERS_3.52' not found (required by /sas94/sashome/SASFoundation/9.4/sasexe/sasodb) 1 LIBNAME SAMPLE2 ODBC NOPROMPT="Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.6.so.1.1;SERVER=999.99.9.999,8888; 1 ! DATABASE=example1;UID=usr_XX; 2 PWD=ABCD" SCHEMA=dbo; ERROR: The SAS/ACCESS Interface to ODBC cannot be loaded. The SASODB code appendage could not be loaded. ERROR: Error in the LIBNAME statement.   I also have tried this: LIBNAME SAMPLE2 ODBC DATAsrc=NAMESRC_S SCHEMA=dbo USER=usr_XX PASSWORD="{SAS222}828A4PP5CB131A25BC" ; and I obtain the same error. BUT, when I do it from SAS enterprice Guide, both libname staments work fine! any idea? ... View more

Hi experts, I need to generate a json file from a table like this ACCOUNTS DATA account1 data1 account1 data2 account1 data3 account2 data1 account2 data2 account3 data1 account3 data2 account3 data3 but, I want to generate 1 json file for each account with its own data, example: {account1, "data1", "data2", "data3"}   --> first json file {account2, "data1", "data2"}  --> second json file {account3, "data1", "data2", "data3"}   --> third json file   Any idea how to do it ? ... View more

Hi administrators experts   Is there a way to start and stop the object spawner from managment console? the sas installation is on linux or i have to do it from linux command ? ... View more