Hi. My SAS Enterpise Guide 4.3 (4.3.0.10196) is showing unknown error   A connection could not be made to the SAS Metadata Server but is required for the current operation. Please see your administrator. -------------------------------------------------------- Connection failed ------------------------------ Technical Information Follows ------------------------------ SAS.EG.SDS.Metadata.MetadataException: Connection failed ---> System.Runtime.InteropServices.COMException (0x80042745): Software caused connection abort. An established connection was aborted by the software in your host machine, possibly due to a data transmission timeout or protocol error. at SASObjectManager.ObjectFactoryMulti2Class.CreateObjectByServer(String Name, Boolean synchronous, ServerDef pIServerDef, String LoginName, String Password) at SAS.EG.SDS.Metadata.OMSProvider.Connect() --- End of inner exception stack trace --- at SAS.EG.SDS.Metadata.OMSProvider.Connect() at SAS.EG.SDS.Metadata.MetadataManagerV2.SAS.EG.SDS.Metadata.IMetadataConfiguration.set_ActiveProvider(Provider value) at SAS.EG.SDS.Dialogs.ProviderConnectDlg.Connect(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) ------------------------------ End of Technical Information ------------------------------   It worked 2 days ago and now it is not connected.   Anyone knows how to fix it?   Thanks   ... View more

Hi, I have a left join SQL clause below:   PROC SQL; CREATE TABLE WORK.QUERY_FOR_APPEND_TABLE_SAS7BDAT AS SELECT DISTINCT  t1,clientID t1.ADJ_CREATION_DATE, t1.CREDIT_AMT, t2.EFF_DATE, FROM work.append_table t1 LEFT JOIN WORK.table2 t2 ON (t1.clientID= t2.clientID) QUIT;   For some strange reason, my observation gone up, and check variable EFF_DATE, filter out the missing value on that variable. still the observation is higher than the work.append_table.   is there a fix for that?   Thanks ... View more

Hi, I am using SAS EG 4.3 (4.3.0.10196)   Whenever I want to stop the process, the Stopping really take long (more than 1 hour).   Could I really stop the process of the SAS query instantly?   Thanks ... View more