Thank you, it was helpful. But why does the "collaps" command create a new dataset and delete the old. Is there a similar command that does the same thing, but creates new aggregate variables within the existing dataset?
Thank you for the comment! The collapse creates a new dataset on the basis of summary statistics of the old dataset. That is the purpose of the command. If you really want to keep the old dataset, simply wrap the collapse command in a preserve/restore group, creating a new dataset, saving it, and then merge it onto the old. I explained the preserve/restore and merge in two other videos.
Concise and informative!
Very helpful!
you are my life saver.
Thank you, it was helpful. But why does the "collaps" command create a new dataset and delete the old. Is there a similar command that does the same thing, but creates new aggregate variables within the existing dataset?
Thank you for the comment!
The collapse creates a new dataset on the basis of summary statistics of the old dataset. That is the purpose of the command. If you really want to keep the old dataset, simply wrap the collapse command in a preserve/restore group, creating a new dataset, saving it, and then merge it onto the old. I explained the preserve/restore and merge in two other videos.
How to collapse on mode for categorical variables?
Hi!
Never tried but my suggestion would be first use egen to generate the mode, and then you can keep the first obs when using collapse.
i get error message from this code: collapse (sum) project1, by(countryname, year, internationalsectorname). why :(
Good idea to show the error message toy get so we have an idea what is going on :)