In  AIX 64 bit OS environment we have 8 power servers running which host our Demand Forecasting application running under SAS 9.3   The Storage team have advised that they can not do this via a DDBoost client or an Avamar client.   Can someone let me know how we could back up these servers to an EMC Domain. ... View more

An issue where we are seeing saved SAS codes getting cleared or emptied on a random basis We are using SAS EG7.1. SAS codes resides in LINUX platform(server)   ... View more

HI All,   We have a DB2 library defined in metadata and a table has various columns defined with a CCSID format at the database side. The columns are registered in metadata with the format & informat of $HEX80. and we are able to convert these to proper text using the input function: C_ALTERNATE_N_A_LINE_1 = input(ALTERNATE_N_A_LINE_1,$EBCDIC40.); however, we wanted to do this at SMC level to prevent users having to write a coded workaround. Do you know if its possible to do this? We have tried various formats & informats but cannot get the data to display proper text without having to code the workaround. ... View more

Hi,   We are migrating from SAS9.2 to SAS9.4. We discovered that in one PROC SQL steps show that the method that the SQL optimizer includes a sort(sqxsort)  in SAS 9.2. but the same code using the same data, for SAS 9.4, it removes the sort(dont know the reason).This has huge implications because the data output is differ   Please help me in this       ... View more

Am geeting the following error in sas di: “Exception thrown when waiting for a response from the peer”. The issue is random really getting. Sometimes it happens whilst trying to run a job after stopping it manually (from within DI), sometimes it’s just after saving a job and sometimes it’s just the simple running of a job ... View more

Group by differences in SAS9.2 and 9.4 ... View more

I am trying to register new tables in metadata from a predefined Oracle library, not update the metadata of pre-existing tables. When I use the Register Tables wizard in Management Console the new tables do not appear in the list of available tables. When I use proc metalib to register the tables manually it produces the below error . When I create an empty defintion in DI Studio and use the update metadata option, it produces the same error as when I run proc metalib manually.   error: 33 proc metalib; 34 omr(library=lpdw); 35 run; ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [METALIB ] Segmentation Violation Traceback of the Exception: /sas94/software/dev/compute/SASFoundation/9.4/sasexe/sas() [0x52809e] /sas94/software/dev/compute/SASFoundation/9.4/sasexe/sas() [0x41f08e] /sas94/software/dev/compute/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x2ac00c1d45d4] /lib64/libpthread.so.0() [0x323720f790] /sas94/software/dev/compute/SASFoundation/9.4/sasexe/sasmetas(fillTableType+0xb5) [0x2ac06c71c915] /sas94/software/dev/compute/SASFoundation/9.4/sasexe/sasmetas(refmeta+0xab9) [0x2ac06c71b709] /sas94/software/dev/compute/SASFoundation/9.4/sasexe/sasmetas(sasmetas+0x211c) [0x2ac06c71044c] /sas94/software/dev/compute/SASFoundation/9.4/sasexe/sas(vvtentr+0x101) [0x41eca1] /lib64/libpthread.so.0() [0x3237207a51] 2 The SAS System 13:37 Monday, January 25, 2016 /lib64/libc.so.6(clone+0x6d) [0x3236ee893d] NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE METALIB used (Total process time): real time 0.31 seconds cpu time 0.11 seconds ... View more