Rename variables with the same suffix

[jackblack]

Thank you all for your help.  I don't want to say why it was set up in that way but have to read the data. 

Ksharp, if I understand your code correctly it will rename all variables from all datasets in WORK.  Can you show me the results? 

We have 3 years datasets monthly and I may need some of them so I am not sure your first.memname and last.memname will work from the data storage folder.

I remembered I did a similar job before but I don't have the code anymore because of changing jobs.  I think basically we need prco contents to create and output a file that has a statement of rename then using %include in next data steps.

[Shmuel]

Renaming all variables by compressing 0-9 digits from their names, needs a check: 

are there variable names where the digits are not the suffix of yymm format (like 1601) !

If there are such variables, the code should check for suffix being in a given period (like 1601 - 1612).

[jackblack]

I am sure there are more than one way to do this job but I tried Shmuel's code and it works for me.  Thank you all again.