title: Is there a way to copy files using SAS EG in PCFILES server?
body: <p>I am using SAS EG with UNIX system. However, there are some instances when I need to use MS Access lookup tables, so I asked our admin if there was a solution. They installed a PCFiles server. I am not 100% sure how it works but I am now easily able to create a library off of any MS Access database like this:</p>
  
  <pre><code>libname ac PCFILES path="D:\dde\actuarial\mbrsop\2018_07/member_lookups.mdb" server=cncpwsasa1027 port=9622;
  </code></pre>
  
  <p>At the beginning of each month I need to create bunch of new folders in UNIX and copy bunch of files from previous month's folder to new folder. For UNIX files and folders I use code like this:</p>
  
  <pre><code>%sysexec cd /utils/gpfs0/files/warehouse/corp/actuarial_rpt/mbrsop/data;
  %sysexec mkdir &amp;new_month.;
  %sysexec cp /utils/gpfs0/files/projects/corp/actuarial_rpt/membership/pgm/&amp;old_month./variables.sas
      /utils/gpfs0/files/projects/corp/actuarial_rpt/membership/pgm/&amp;new_month./variables.sas;
  </code></pre>
  
  <p>Is there a way to create a folder in the PCFILES server in a similar way as above? Using the code below obviously does not work.</p>
  
  <pre><code>%sysexec cd D:\dde\actuarial\mbrsop;
  %sysexec mkdir &amp;new_month.;
  %sysexec cp D:\dde\actuarial\mbrsop\&amp;old_month./member_lookups.accdb D:\dde\actuarial\mbrsop\&amp;new_month./member_lookups.accdb;
  </code></pre>
  
  <p>How to get SAS EG to understand I want to create the folder and copy files in PCFILES server and not in UNIX?</p>