My question:

I have many excel files onc:\temp\p001.xls…..p100.xls

I want to rename p001.xls…..p100.xls to q001.xls…..q100.xls

ie. (rename q001.xls= p001.xls ….. q100.xls=p100.xls)

------------------------------------------------------------------------

I search this paper “Useful SAS Macros andRoutines” from SAS Global Forum 2007 by Flora and Miguel

(paper 059-2007) tofind their SAS codes only mention about

“Macro to Open(Delete) Excel file” onpage 1, None “Macro to Rename Excel file”,

Sir matyou help me to write a code follow theirs,THS!