UrbanInstitute / education-data-package-stata

MIT License
19 stars 4 forks source link

Fix Variable Naming Issue in 'awards-by-major-example.do' for Long-to-Wide Reshape #94

Open SiqiWang0212 opened 8 months ago

SiqiWang0212 commented 8 months ago

Hi! I have feedback regarding the Stata code in 'awards-by-major-example.do' (https://github.com/UrbanInstitute/education-data-package-stata/blob/master/awards-by-major-example.do). I've noticed potential typos at lines 39 and 40. When reshaping from long to wide format in Stata, the variable names should be 'awards_6digit1' and 'awards_6digit2', following Stata's naming convention, which appends 'j' values to 'xij' variable names. However, when calculating the percent, they are used as 'awards1' and 'awards2', which leads to a 'variable not found' issue. Long-to-Wide-Screenshot