Than your question is not data management related, but is about the coding and managing the important business code. The whole "MY PC"and "MY Spreadsheet" is also about that failing IT business alignment. There are user that want to code some thing by theirself. Selfservice BI (SAS VA) is heading more into that direction. What I feel is you are needing and looking for is a release management process (DTAP) and some version control for developing "approved code". By the way the link I gave you is mentioning what you can do as technical guy limiting (possible frustrating) your users. You can think in not trying by limiting some access, but offering some help and support for effective code management. Some actions: Give them physical locations where they should store code on adhoc (department) base or as project delivery with some local super-user person that will be responsible for organizing that an keeping it clean and understandable. When a release management process for their code is needed (DTAP Life Cycle Management)m than support that If you have many (ETL) developers think about the need and "technical how to" for version-control at the development stage. I am feeling you are dealing with al lot of analysts, being accustomed to do it their own way. That is the most difficult group. The common goal can be getting alignment to regulations you are needing to be traceable auditable and the code has to be proven being of some kind of quality. You can force them to store everything in SAS-metadata, but there must be some structure in that. With that you can get into an other question. How do you support backup/restore questions (give me my version of last week)? On the OS level you can redirect to OS-level support. With a SAS only technical implementation you have to work on that make service agreements and describe those.
... View more