For example, he was calculating column percentages in Excel instead of in Stata with the correct options in tabulate. He was doing further analyses, not just reproducing a table he’d made. Like seriously wtf is it with this guy? Kidding. Pasting output from one table to another has been more error proof for me than typing each cell one by one. It works well enough, but I'm wondering if there are any better solutions that would let me paste data from the result window in STATA directly into excel cells, rather than exporting an otherwise unnecessary excel doc.Įdit: The reason I want to be able to paste directly is (a) to avoid a lot of unnecessary typing and (b) reduce the possibility of human error. What I usually do is export my cleaned data to an excel doc, make a quick pivot table, then paste the numbers from there into my template. When I try to paste the table into excel, each row is pasted into a single cell, rather multiple cells. Say in STATA I created a frequency table with "gender" as the columns and "ethnicity" as the rows using tab ethnicity gender. I might be missing something simple, but STATA results do not seem to paste easily into Excel. I'm frequently using STATA to process data that needs to go into an existing excel template.
Other users who have found the question cross-posted are encouraged to share the links as a reply as well. If you've asked a question, let people know where else you asked the question and what your solution(s) were! When you post a question on another platform, include those links in your questions or as a reply (if it's Discord, just mention it).See the sticked "READ ME: How to best ask for help in /r/Stata" post on how to comment here if all else fails. Make sure to include the word "Stata" in your search query. Perform a web search for your question prior to posting here. Stata's online community has been active for many years and many questions and solutions are documented on StataList, which are highly indexed on contemporary search engines (e.g., Google). Stata has extensive and complete documentation you can read before posting here (and you can type help followed by the command name in console to see it, e.g. This is not a place to find Stata tutoring. Do not request that the /r/Stata community do your homework for you. Assume good faith questions and comments. Be nice when posting or commenting to a post.The Code Block on Discord (run by Asjad Naqvi of The Stata Guide).
0 kommentar(er)
