@buddha_d wrote:
I agree, CSV is much better format. But I am doing it as my boss wants me to do it this way (importing directly from excel rather than saving it for as CSV file and then reading it). Thanks
Record the amount of time each change takes you for a short period of time, perhaps one or two weeks. Project that time time over a year. Apply your pay rate to the time. Use that information to lead into a discussion about overall cost of a process versus the one minute to do save as and change the input file name and output datset names if you are creating multiple data sets.
Add it some bits about the cost in what happens with variable type changes such as changing variables to match other data sets for combined analysis and reporting.
You may have a bit more success if approaching management with impact to bottom line information.