topic Re: Can we use SAS program to rename the file name in a folder in SAS Programming

Can we use SAS program to rename the file name in a folder

SASuserlot — Mon, 17 Oct 2022 13:11:50 GMT

Can we use the SAS to rename the file name that already existed in the folders using the system commands? if so can you please tell me how to achieve this:

Folder: "c\documents\study

Old filename: stdy_details.xlsx

New Name: Stdy2022.xlsx

I want to rename the old file with new name. If possible both ways using base SAS and X command .Thanks for your time.

Re: Can we use SAS program to rename the file name in a folder

sbxkoenk — Mon, 17 Oct 2022 13:20:59 GMT

Hello,

With the SAS RENAME function , you can also rename external files !

See here :

SAS® 9.4 and SAS® Viya® 3.5 Programming Documentation | SAS 9.4 / Viya 3.5
Functions and CALL Routines
RENAME Function
Renames a member of a SAS library, an entry in a SAS catalog, an external file, or a directory.
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p14axci3mo3egan1okbcydvbt433.htm

Koen

Re: Can we use SAS program to rename the file name in a folder

SASuserlot — Mon, 17 Oct 2022 13:35:20 GMT

Thank you. Is it possible using x commands?

Re: Can we use SAS program to rename the file name in a folder

sbxkoenk — Mon, 17 Oct 2022 13:40:55 GMT

Of course, with X-command or CALL SYSTEM.

Unless your SAS administrator has disabled that functionality in the configuration file.

option XCMD enables the X command in SAS.

option noXCMD disables the X command in SAS.

Koen

Re: Can we use SAS program to rename the file name in a folder

SASuserlot — Mon, 17 Oct 2022 13:52:04 GMT

Thank you, if possible can you please give me an example how to rename a file using x command using SAS. I am not that great with he x commands in SAS. in the following scenario

Folder: "c\documents\study

Old filename: stdy_details.xlsx

New Name: Stdy2022.xlsx

Re: Can we use SAS program to rename the file name in a folder

sbxkoenk — Mon, 17 Oct 2022 14:06:03 GMT

*proc options; *run;

options noxwait;
x 'cd C:\documents\study';
x 'ren stdy_details.xlsx Stdy2022.xlsx';
/* end of program */

Koen

Re: Can we use SAS program to rename the file name in a folder

SASuserlot — Mon, 17 Oct 2022 14:18:09 GMT

Thank you. It worked for me.