topic Re: Copy Excel Workbook and Save Under New Name in SAS Programming

Copy Excel Workbook and Save Under New Name

eferencik — Wed, 14 Feb 2018 17:50:43 GMT

I am trying to use SAS to copy an existing excel workbook (a template) and save it with a new name in a different folder (once updated with current data). I have tried both steps below, but I cannot get either to work. It seems like it should be simple to do, the only difference between the 2 workbooks would be the file name and location.

First tried:

options noxwait;

data _null_;

rc= system("copy S:\sas\Regular Reports\Vacancy Template.xlsx S:\oim\Regular Reports\Vacancy Report &sysdate..xlsx");

put rc=;

run;

Then I tried:

options noxwait;

data _null_;

oldname="S:\sas\Regular Reports\Vacancy Template.xlsx";

newname="S:\oim\Regular Reports\Vacancy Report &sysdate..xlsx";

rc= system(quote(catx(' ','copy',quote(trim(oldname)),quote(trim(newname)))));

put rc=;

run;

Re: Copy Excel Workbook and Save Under New Name

Reeza — Wed, 14 Feb 2018 18:01:26 GMT

If you're using SAS 9.4 try FCOPY instead.

@eferencik wrote:

I am trying to use SAS to copy an existing excel workbook (a template) and save it with a new name in a different folder (once updated with current data). I have tried both steps below, but I cannot get either to work. It seems like it should be simple to do, the only difference between the 2 workbooks would be the file name and location.

First tried:

options noxwait;

data _null_;

rc= system("copy S:\sas\Regular Reports\Vacancy Template.xlsx S:\oim\Regular Reports\Vacancy Report &sysdate..xlsx");

put rc=;

run;

Then I tried:

options noxwait;

data _null_;

oldname="S:\sas\Regular Reports\Vacancy Template.xlsx";

newname="S:\oim\Regular Reports\Vacancy Report &sysdate..xlsx";

rc= system(quote(catx(' ','copy',quote(trim(oldname)),quote(trim(newname)))));

put rc=;

run;

Re: Copy Excel Workbook and Save Under New Name

eferencik — Wed, 14 Feb 2018 18:12:33 GMT

Thank you. I searched FCOPY, found this and it works.

filename src "path-to-src" recfm=n;
filename dst "path-to-dst" recfm=n;
%let rc = %sysfunc(FCOPY(src,dst));
%put %sysfunc(SYSMSG());