Hi All,   My Customer SAS Site been configured with 3 tier architecture and it was working fine till last week.   since Monday on words, the SAS Users are not able to accee/expand SASApp(Under Servers) in EG to access libraries and Files Folders.   The SAS Server VM are running on physical OVM Comupte nodes for high availablity  and over the week end the Unix team upgraded kernel in OVM Compute nodes but they have not changed any of the configuration files in SAS Severs related.   No Error on EG and No errors on Objectspawner log files as well. i am able to validate all server in SAS SMC using end user account.   Can anyone suggest why its happend like this and how to get back to users to access SSApp in EG?   Thanks, Ram         ... View more

Hi All,   I am new to SAS Enterprise Miner tool and need to work on EM 13.1.  I want to access Oracle DB tables for Mining Analysis in SAS EM.    Can I access the Oracle library tables in SAS EM which I can see in SAS EG library list(SAS Admin Created for EG Access)? or   Do I need to create New Oracle Library in SAS EM tools?     Thanks, Ram. ... View more

Hi,   I am running out with below Syntax error message for SAS Proc Sql code.   the below code is working fine in Sql developer and shared with SAS user to run and collect result, but the code through error for sql functions - over, count and (+) in below code.   ==================================== select name,cde_fund_code,id_provider,D.num_check, sak,A.sAcct_rec, C.chk_sak,amt_setup,amt,B.dte_payment_issue,amt_setup -sum(amt) over (PARTITION BY A.sak_Acct_rec order by dte_payment_issue ), count(amt) over (PARTITION BY A.sak_Acct_rec order by dte_payment_issue ) from A, B, C, D where A.s_fund_code in ( '****','****') and B.acct_rec (+) = A.acct_rec and C.sak (+) = B.sak and D.chk_sak (+) = C.chk_sak;   is there any different function to use SAS Proc sql? because its working fine in Sql Developer.   How to fix this and run the code withut errors? ... View more

Hi All,   I have reported few issues with EG while Executing the EG Projects. let me explain example of code.   Users are having EG Project which is combo of multiple SAS Programes.   Programe1  ---------------> Program2 ---->Program3 ----> Program4--->Program5------>Program6....so on. (Lib Ref)                            daa step           data step         data steps     data steps          data steps     Actual happening: the Project is for Analytics to creates some target tables and takes 4-5 hours to complte it run, users running over night and going home to see result on next day morning.   Issue 1:- the Eg Project froze and EG unresponsice state on nest day morning.   or Issue 2:- when User run the above Project, Program1 assign library, and Program2 and Program3 creates few temp Tables into Work Library. when SAS start execute Program4 or 5, it throughs error with the table names as not exists(which has created as part of Program2 or 3).         or   Issue 3:- sometimes it says that the libname statement not assigned though they are in part of Program1.   Issue 4:- If the User stay with PC and complete the EG Project Run and try to open the permenent table from Project, not opening. its says the table doesnot exits. but the same table is opens from file location Server> SASApp>Files> table.   Are this happening cause any issue with Server responce? is there any options to change in EG side to interactivley complete the EG Project run for 5 hours without Froze?   Can someone suggest on it to how to fix this issues?   Thanks, Ram,   ... View more