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.
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).
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.