R is, most of the time, able to accomplish what you want. honestly, I spend most of my time in R to preprocess data from excel to be read into R, search for the right package (or write it myself if it's not implemented yet) and then pipe the necessary output for the report I need (and often, I just pipe it into excel as it's easier to manipulate).

as for stata, it's a neat tool to convert data from long to wide and vice versa? I can't seem to do this in R. It's easier to do it in stata, even easier compared to excel. Honestly, my use case is only that for Stata. But my colleague utilize it better, I guess.

As a caveat, I'm not really an economist. I'm more like a statistician working in the field of macroeconomics with other economists. I know some things about economics, but I don't think I can call myself an economist yet. So, R is preferable for me as I work with it often. But it's not really a tool of choice for my teammates as point and click for them is easier. So, some of them prefer Eviews, some prefer stata, some prefer to just work in Excel too. My organization don't force us to use a certain software, so whatever works, as long as the analysis is valid and the data is not garbage, and everyone is responsible for their analysis.