topic Re: Move directory that contains excel files from one location to another 9.3 in SAS Programming

Move directory that contains excel files from one location to another 9.3

AlexeyS — Sun, 26 Dec 2021 19:13:43 GMT

Hello,

I want to move directory as is that contains excel files from one location to another. Which way is the most appropriate?

I have a SAS 9.3 version.

Thank you

Re: Move directory that contains excel files from one location to another 9.3

kelxxx — Sun, 26 Dec 2021 21:31:56 GMT

You can try this. It works for me

options noxwait;
%let source_path= C:\Users\PNG\Documents;
%let file_name= test.xlsx;
%let destination_path=C:\users\png;
X move &source_path\&file_name &destination_path;

Please give me a like if you find it useful.Thanks!

Re: Move directory that contains excel files from one location to another 9.3

SASKiwi — Sun, 26 Dec 2021 22:22:47 GMT

What OS does your SAS session run on? The required OS command and syntax to move the files depends on the OS. Your SAS session will also need to be able to access OS commands. You can check the required SAS option like this:

proc options option = xcmd;
run;

Re: Move directory that contains excel files from one location to another 9.3

Sajid01 — Mon, 27 Dec 2021 12:35:32 GMT

The best approach would be to do it at the operating system level.
If the source and destination locations are on different computers, then ftp clients like filezilla would be helpful.

Re: Move directory that contains excel files from one location to another 9.3

AllanBowe — Tue, 28 Dec 2021 09:25:39 GMT

If you don't have XCMD enabled you can use this macro to recursively copy a directory from one place to another: https://core.sasjs.io/mp__copyfolder_8sas.html