proc sql; create table want as select b.*,a.Sales_rep from b b left join a a on a.id= b.id; quit; ... View more

Have you tried following ? May be it is to do with large sas log file.   If you submit a job that generates an abnormally large log, SAS Enterprise Guide might display the following error: An error occurred executing the workspace job "job_name". The server is disconnected. If SAS Enterprise Guide logging is enabled, the following error is logged.   ERROR SAS.Shared.Exceptions.ServerExceptionHelper [(null)] - MapException() - Mapping error for: System.Runtime.InteropServices.COMException (0x80010108): The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))     Workaround If the job in question generates the error soon after being submitted, try redirecting the streamed SAS log by adding the following code to the top of the program and submit the program again.   proc printto log="c:\path-on-server\EG.log"; run; Then, check the SAS log to verify that the program has completed. If it did complete, then redirecting the log is the only current workaround.   ... View more

Read my post again with respect to how data should be posted. I won't start to type data from screen in my precious spare time. Your post does NOT convey any pertinent information about data types, formats and other attributes. If you do a join, post the code of the join. ... View more

Until you have posted example data as requested (data step!), and an example of the wanted mail, I'm out of here. ... View more