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

Hi experts  I have a table like this Id Name Percentage 1 Ricardo 100 2 Jose 100 3 Roberto 50 3 Alexander 50 4 Carlos 100 5 William 50 5 Juan 50 6 Alonso 33 6 Perez 33 6 Menjivar 34 7 Regina 100 And i Want to add a column making a count like this Id Name Percentage Count 1 Ricardo 100 1 2 Jose 100 1 3 Roberto 50 1 3 Alexander 50 2 4 Carlos 100 1 5 William 50 1 5 Juan 50 2 6 Alonso 33 1 6 Perez 33 2 6 Menjivar 34 3 7 Regina 100 1   Do you have any idea how to make it ? ... View more

Hi experts, nice to write you again ! I have a trouble modifying the length of a column in management console, when i import the metadata from a table, as a defult, it has 1024, but the length that i need for that column is 25,000 the datatype is alphanumeric. The management console accepts this chance, but when I select the table from the enterprice guide (ver.7.15), it has always 1024. I'm modifying in management console the lenght, the informat, and the format     ... View more