panelwhiz is "charity-ware": We strongly suggest that you donate to UNICEF every year. This helps children in the world who need it most.

Download Stata SETUP-FILE to get going: Download this Stata ADO File pwupdate.ado to start the installation process in Windows/Mac/Linux. Anyone with Stata can install this. You do not need a userid or an account. There is no guarantee with this tool and programming errors cannot be avoided, just like with any program. However, when we hear from our users of a problem, we can usually fix it quickly.

panelwhiz works for you: If you know the name of a variable in ONE wave, panelwhiz knows the name of the related variables in EVERY OTHER wave. Simply click and you have selected all variables over all waves. Syntactically correct scripts retrieve the data based on your preferences. Go back anytime to old retrievals, edit, add, append, update, re-run at will!

  • Click

    Open a panelwhiz data browse page in any ONE wave and select an entire vector of variables for ALL waves with one simple mouse "click". Stata's SMCL clickables make this possible!

  • Retrieve

    For the items you have selected, panelwhiz creates a Stata DO file ON THE FLY and extracts the data, merging and matching over time and level, into a rectangularised Stata long file.

  • Done

    With your wave-stacked long file now on disk, the file can be used directly in Stata or imported into SPSS, SAS, GAUSS, R, MPlus, Excel, without any additional translation software.