Hi, I'm have many Business reports that are pivot based. I want to move the pivot creation in Excel to SAS so that there is no manual effort required. Can anyone please share if this is possible in EG as EG is running on SAS server and MS office is not supported on the server. Any help in this regards is highly appreciated. Thanks, Anuj ... View more

Hi, I'm working on SAS EG and have multiple codes to for one single task. SAS EG works on the server so I dont need to setup a remote connection. I want to use SAS MP connect but getting an error. I'm using the following test code (found from SAS documents available online): option sascmd="sas"; rsubmit process=task1 wait=no log=keep output=keep ; libname mydata '/export/home/agupta3'; data test; X1=10; run; endrsubmit; rsubmit process=task2 wait=no log=keep output=keep; libname mydata '/export/home/agupta3'; data test1; Yi=10; run; endrsubmit; waitfor _all_ task1 task2; *rget task1; rget task2; /*Signoff task1; Signoff task2;*/ libname mydata '/export/home/agupta3'; data mydata.sorted;   merge mydata.test mydata.test2; run; Please help me understand this issue and resolve the same. Thanks, Anu Message was edited by: Anuj Gupta ... View more