About zkhodr

zkhodr · ‎08-03-2022

Thank you!! This worked.

zkhodr · ‎08-03-2022

Thank you!!! This worked.

zkhodr · ‎08-03-2022

Hi! Thank you for your help. I have a folder on my computer with word documents named 1 - 100. I would like to rename all of them with the matching 'newname' variable in the attached SAS dataset. If I run the following code it will rename it for the first file. How do I modify this code to use the SAS dataset to rename all 100 files. Thank you again! DATA _NULL_; IF FILEEXIST("L:\Projects\1.docx") THEN DO; RC = RENAME ("L:\Projects\\1.docx", "L:\Projects\a.docx", 'file'); END; RUN;

zkhodr · ‎07-27-2022

The log shows no errors, but when I go to the actual file location the file name has not changed and is still the old name.

zkhodr · ‎07-27-2022

The set statement sets the sas dataset into the data step, so the values of the two variables are known. I am able to rename if I just choose one specific old and new name and that does not require a macro, but as soon as I try to put it in a macro to do it for multiple files it does not work.

zkhodr · ‎07-27-2022

I have a dataset with two variables: one is SSN and one is a unique study ID. I have an external folder of image files for each subject, and each image file is named by SSN. I would like to rename all external files from SSN to studyID. Following is the code that I tried, but I think I am missing a big step somewhere for making the macro part work. Thank you in advance!!! %MACRO rename (ssn, studyid); DATA _NULL_; SET data; IF FILEEXIST("L:\Projects\&ssn..docx") THEN DO; RC = RENAME ("L:\Projects\&ssn..docx", "S:\Projects\&studyid..docx", 'file'); END; RUN; %MEND; %RENAME (ssn, studyid);

Online Status	Offline
Date Last Visited	‎10-20-2022 01:36 PM

Re: Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Re: Renaming external files with SAS variables values

Renaming external files with SAS variables values