To practice reshaping, load a somewhat precleaned subset of the WDI dataset from the web. In Stata, this is only possible in years are in different observations (long form), not in different variables (wide form). For example, we may want to create a line graph from a variable. We will reshape the data in the tidy format.ĭifferent shapes of the data are useful for different tasks. This is the opposite of “ tidy data,” where each variable has its own column, and different observations such as different years are in separate rows. Variables are in separate rows, whereas years are in separate columns.
If we subtract the mean of a variable, the difference will be mean zero. generate difference_censusyear = censusyear - mean_censusyear egen mean_censusyear = mean(censusyear), by(region) There are many functions to be used in egen count, min, max, sum and mean are the most commonly used. The command egen creates a new variable with the aggregated statistics. egen average_census_year = mean(censusyear), by(incomegroup) egen n_country = count(countrycode), by(incomegroup) To filter out observations, use drop if and keep if. Stata will keep, or drop, all variables starting with the variable to the left of the - and ending with the variable to the right of the. Similarly, you can use the - character to keep or drop variables in the dataset. You can use variable name wildcards with both commands ( drop latest*). Only use them if your work is easy to reproduce if you make an error, such as right after loading a dataset. The commands keep and drop irreversibly change the data in your memory. keep countrycode shortname region incomegroup censusyear We will not use most of them, so let’s drop them. Note: Dataset has changed since last saved. Latesttradedata int %8.0g Latest trade data Latestindustr~a int %8.0g Latest industrial data Latestagricul~s str130 %130s Latest agricultural census
#Reshape long stata registration
Vitalregistra~e str48 %48s Vital registration complete Sourceofmostr~n str88 %88s Source of most recent Income and expenditure data Latesthouseho~y str77 %77s Latest household survey Latestpopulat~s str166 %166s Latest population census Imfdatadissem~d str51 %51s IMF data dissemination standard Governmentacc~t str31 %31s Government Accounting concept
#Reshape long stata manual
Systemofnatio~s str61 %61s System of National AccountsĪlternativeco~r str22 %22s Alternative conversion factorīalanceofpaym~e str33 %33s Balance of Payments Manual in useĮxternaldebtr~s str11 %11s External debt Reporting status Lendingcategory str9 %9s Lending category
Snapricevalua~n str36 %36s SNA price valuation National~ceyear str9 %9s National accounts reference year National~seyear str50 %50s National accounts base year Specialnotes str1294 %1294s Special Notes Variable name type format label variable label
0 kommentar(er)
