Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.
Friday, March 3, 2023
Help! How do I use the command collapse?
Hi, I have a question about an exercise we did in my econometrics class. I have this database of teachers and schools of about 62,000 observations, and I'm asked to use the collapse command to count how many schools and how many teachers there are, but when I collapse (count) teacher_id school_id and then list , the result is more than 60 thousand in each of the variables. Now, I know that it is not the result since for each school there must be a certain number of teachers. I've been searching the forums and I see that some people use the command to generate a gen=cons constant but I don't really know how to use it. So if anyone knows or wants to contribute something, I would greatly appreciate it.
No comments:
Post a Comment