I am sure that my EG Server allow me to submit x command or pipe command. But if I submit: x "test.vbs"; Things goes strange, I can see a vbs process in task manager on EG Server computer, but the vbs task never stop until I mannually terminate it.   So I test this: filename temp pipe "calc"; data _null_; infile temp; input text $256.; run; I switch to EG Server computer and there is a Windows Calculator process in task manager(the highlighted one), but no software interface of Windows Calculator can be seen.  What's wrong with it? ... View more

I'd like to ask: When I use EG to connect to the server and submit a data-step code,   1. The server executes code slowly, likely constrained by network latency, single-core CPU performance, disk read/write speed (HDD), memory allocation (8GB per user in the workgroup), and memory read/write performance; 2. My local computer significantly outperforms the server in all these hardware metrics;   Besides switching to PC SAS on my local machine, how else can I leverage my local computer's hardware advantages to accelerate code execution? ... View more

When using SAS DMS, I can use the system option: AWSTITLE to name a SAS session, so I can switch between different projects (one session for one project) and don't mix them up.   How should I achieve this when using EG? ... View more

I am using fcopy() function to copy an Excel file, here is the code: filename spec "spec.xlsx" recfmt=n; filename speccopy "%sysfunc(pathname(work))\spec.xlsx" recfmt=n; data _null_; rc=fcopy('spec','speccopy'); if rc>0 then do; msg=sysmsg(); put msg=; end; run; It works usually, but failed while I am editing this Excel file, how to make fcopy() just make a copy of the Excel file while the file is on editing? ... View more

Thanks @Patrick  for inspiring me. When using DOW-Loop, I used to not writing a "stop" statement, but today I see difference from this post:Why read data 1 times or 2 times when declare hash object with or with... - SAS Support Communities   DOW-Loop with "put _n_=" above: data _null_; put _n_=; do until(_eof_); set sashelp.class end=_eof_; end; run; SAS Log: _N_=1 _N_=2   DOW-Loop with "put _n_=" above and "stop" behind: data _null_; put _n_=; do until(_eof_); set sashelp.class end=_eof_; end; stop; run; SAS Log: _N_=1   DOW-Loop with "put _n_=" behind: data _null_; do until(_eof_); set sashelp.class end=_eof_; end; put _n_=; run; SAS Log: _N_=1 I have read The SAS Supervisor - SAS Support Communities and still not figure it out. ... View more

This is an example of submiting hash declare statements with "if _n_=1" block: data want; if _n_=1 then do; declare hash h(dataset:"sashelp.class(where=((weight*0.4536)/(height*0.0254)**2>20))"); h.definekey('age'); h.definedone(); end; do until(_eof_); set sashelp.class end=_eof_; bmi=(weight*0.4536)/(height*0.0254)**2; if h.check()=0 then output; end; run; SAS log shows the lookup table was read 1 times: NOTE: There were 5 observations read from the data set SASHELP.CLASS. WHERE ((weight*0.4536)/((height*0.0254)**2))>20; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.WANT has 10 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds Removing the "if _n_=1" block": data want; declare hash h(dataset:"sashelp.class(where=((weight*0.4536)/(height*0.0254)**2>20))"); h.definekey('age'); h.definedone(); do until(_eof_); set sashelp.class end=_eof_; bmi=(weight*0.4536)/(height*0.0254)**2; if h.check()=0 then output; end; run; SAS log shows the lookup table was read 2 times: NOTE: There were 5 observations read from the data set SASHELP.CLASS. WHERE ((weight*0.4536)/((height*0.0254)**2))>20; NOTE: There were 5 observations read from the data set SASHELP.CLASS. WHERE ((weight*0.4536)/((height*0.0254)**2))>20; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.WANT has 10 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds What makes that difference? ... View more