SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
mollywilk
Calcite | Level 5
Hey! I need a SAS program that will rename multiple files at once. Currently the files are names “blah_blah_person.pdf” and I need to update the files to “blah_blah_person_2023.pdf”. Is there a way to do this in SAS?

Please note that “blah_blah_person” is different for each file, it’s not a consistent name for each. And each file is located in a folder on my windows computer.
3 REPLIES 3
Tom
Super User Tom
Super User

just use TRANWRD().

data have;
  input oldname $200;
cards;
blah_blah_person.pdf
;

data want;
  set have;
   length newname $200;
   newname=tranwrd(oldname,'.pdf ','_2023.pdf');
run;

Now that you have both names you can use them to generate RENAME commands.

mollywilk
Calcite | Level 5
Would the rename all of the files in the folder at once?
Tom
Super User Tom
Super User

@mollywilk wrote:
Would the rename all of the files in the folder at once?

To rename a series of files you need to:

1) Get the names of the files.

2) Generate the new name you want it to have.

3) Issue a rename command for each file.

 

What part of that are you having trouble with?

What have you tried?

How can you get a list of the files? (Hint that question has been asked hundreds of times on this site).

I showed you how to generate a new name.

How can you rename one file? What command can you use?  What would you do if it was just one file you had to rename?

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 990 views
  • 0 likes
  • 2 in conversation