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

I am learning the lesson "Forecasting Using Model Studio in SAS® Viya®" from learn.sas.com and trying to repeat the demo "Pipeline Comparision".   I think the result of comparision is very confusing. Before comparision, the distribution graph of MAPE of "Pipeline1" and "Honest Assessment Auto" are different: But after I select both 2 pipelines and click Compare button, the distribution graph of MAPE become different and difficult to explain:   Why will this happen? I think the distribution graph of MAPE should be same before and after click Compare button.  ... View more