Stata as a collaborative tool

I present a set of do- and ado-files that allow a systematic analysis for economic indicators such as revenues, expenditures and public debt in Mexico on its fiscal system and long-term sustainability with Stata. Updated data are automatically imported from various sources, such as the Timely Statistics of the Ministry of Finance (for example, import delimited https://...), the Economic Information System of the Institute of Statistics (INEGI), and the Censuses and household surveys. After cleaning and saving the databases (sysdir_site) in a “hosting” of a tax simulator, a sysprofile.do file is elaborated to link all the Stata programs in the office to a shared folder. This process allows access to 78 programmed do- and ado-files as well as preprocessed databases. With this, anyone can easily request income, expenditures, both financing and indebtedness specific to a given year, and desired concepts in a coordinated work. In addition, an internal command is introduced to automatically integrate Stata values into LaTeX documents, which facilitates the generation of reports and documents with accurate and up-to-date information.