A bunch of Stata do files to download SIPP files from NBER

01_download_sipp1992.do

copy https://data.nber.org/sipp/1992/sipp92w1.zip $extractdir/92w1.zip
copy https://data.nber.org/sipp/1992/sip92w1.dct $extractdir/92w1.dct
copy https://data.nber.org/sipp/1992/sipp92w2.zip $extractdir/92w2.zip
copy https://data.nber.org/sipp/1992/sip92w2.dct $extractdir/92w2.dct
copy https://data.nber.org/sipp/1992/sipp92w3.zip $extractdir/92w3.zip
copy https://data.nber.org/sipp/1992/sip92w3.dct $extractdir/92w3.dct
copy https://data.nber.org/sipp/1992/sipp92w4.zip $extractdir/92w4.zip
copy https://data.nber.org/sipp/1992/sip92w4.dct $extractdir/92w4.dct
copy https://data.nber.org/sipp/1992/sipp92w5.zip $extractdir/92w5.zip
copy https://data.nber.org/sipp/1992/sip92w5.dct $extractdir/92w5.dct
copy https://data.nber.org/sipp/1992/sipp92w6.zip $extractdir/92w6.zip
copy https://data.nber.org/sipp/1992/sip92w6.dct $extractdir/92w6.dct
copy https://data.nber.org/sipp/1992/sipp92w7.zip $extractdir/92w7.zip
copy https://data.nber.org/sipp/1992/sip92w7.dct $extractdir/92w7.dct
copy https://data.nber.org/sipp/1992/sipp92w8.zip $extractdir/92w8.zip
copy https://data.nber.org/sipp/1992/sip92w8.dct $extractdir/92w8.dct
copy https://data.nber.org/sipp/1992/sipp92w9.zip $extractdir/92w9.zip
copy https://data.nber.org/sipp/1992/sip92w9.dct $extractdir/92w9.dct

01_download_sipp1993.do

copy https://data.nber.org/sipp/1993/sipp93w1.zip $extractdir/93w1.zip
copy https://data.nber.org/sipp/1993/sip93w1.dct $extractdir/93w1.dct
copy https://data.nber.org/sipp/1993/sipp93w2.zip $extractdir/93w2.zip
copy https://data.nber.org/sipp/1993/sip93w2.dct $extractdir/93w2.dct
copy https://data.nber.org/sipp/1993/sipp93w3.zip $extractdir/93w3.zip
copy https://data.nber.org/sipp/1993/sip93w3.dct $extractdir/93w3.dct
copy https://data.nber.org/sipp/1993/sipp93w4.zip $extractdir/93w4.zip
copy https://data.nber.org/sipp/1993/sip93w4.dct $extractdir/93w4.dct
copy https://data.nber.org/sipp/1993/sipp93w5.zip $extractdir/93w5.zip
copy https://data.nber.org/sipp/1993/sip93w5.dct $extractdir/93w5.dct
copy https://data.nber.org/sipp/1993/sipp93w6.zip $extractdir/93w6.zip
copy https://data.nber.org/sipp/1993/sip93w6.dct $extractdir/93w6.dct
copy https://data.nber.org/sipp/1993/sipp93w7.zip $extractdir/93w7.zip
copy https://data.nber.org/sipp/1993/sip93w7.dct $extractdir/93w7.dct
copy https://data.nber.org/sipp/1993/sipp93w8.zip $extractdir/93w8.zip
copy https://data.nber.org/sipp/1993/sip93w8.dct $extractdir/93w8.dct
copy https://data.nber.org/sipp/1993/sipp93w9.zip $extractdir/93w9.zip
copy https://data.nber.org/sipp/1993/sip93w9.dct $extractdir/93w9.dct

01_download_sipp1996.do

copy https://data.nber.org/sipp/1996/sipp96l1.zip $extractdir/96l1.zip
copy https://data.nber.org/sipp/1996/sip96l1.dct $extractdir/96l1.dct
copy https://data.nber.org/sipp/1996/sipp96l2.zip $extractdir/96l2.zip
copy https://data.nber.org/sipp/1996/sip96l2.dct $extractdir/96l2.dct
copy https://data.nber.org/sipp/1996/sipp96l3.zip $extractdir/96l3.zip
copy https://data.nber.org/sipp/1996/sip96l3.dct $extractdir/96l3.dct
copy https://data.nber.org/sipp/1996/sipp96l4.zip $extractdir/96l4.zip
copy https://data.nber.org/sipp/1996/sip96l4.dct $extractdir/96l4.dct
copy https://data.nber.org/sipp/1996/sipp96l5.zip $extractdir/96l5.zip
copy https://data.nber.org/sipp/1996/sip96l5.dct $extractdir/96l5.dct
copy https://data.nber.org/sipp/1996/sipp96l6.zip $extractdir/96l6.zip
copy https://data.nber.org/sipp/1996/sip96l6.dct $extractdir/96l6.dct
copy https://data.nber.org/sipp/1996/sipp96l7.zip $extractdir/96l7.zip
copy https://data.nber.org/sipp/1996/sip96l7.dct $extractdir/96l7.dct
copy https://data.nber.org/sipp/1996/sipp96l8.zip $extractdir/96l8.zip
copy https://data.nber.org/sipp/1996/sip96l8.dct $extractdir/96l8.dct
copy https://data.nber.org/sipp/1996/sipp96l9.zip $extractdir/96l9.zip
copy https://data.nber.org/sipp/1996/sip96l9.dct $extractdir/96l9.dct
copy https://data.nber.org/sipp/1996/sipp96l10.zip $extractdir/96l10.zip
copy https://data.nber.org/sipp/1996/sip96l10.dct $extractdir/96l10.dct
copy https://data.nber.org/sipp/1996/sipp96l11.zip $extractdir/96l11.zip
copy https://data.nber.org/sipp/1996/sip96l11.dct $extractdir/96l11.dct
copy https://data.nber.org/sipp/1996/sipp96l12.zip $extractdir/96l12.zip
copy https://data.nber.org/sipp/1996/sip96l12.dct $extractdir/96l12.dct

01_download_sipp2008.do

copy https://data.nber.org/sipp/2008/l08puw1.zip $extractdir/08w1.zip
copy https://data.nber.org/sipp/2008/sippl08puw1.dct $extractdir/08w1.dct
copy https://data.nber.org/sipp/2008/l08puw2.zip $extractdir/08w2.zip
copy https://data.nber.org/sipp/2008/sippl08puw2.dct $extractdir/08w2.dct
copy https://data.nber.org/sipp/2008/l08puw3.zip $extractdir/08w3.zip
copy https://data.nber.org/sipp/2008/sippl08puw3.dct $extractdir/08w3.dct
copy https://data.nber.org/sipp/2008/l08puw4.zip $extractdir/08w4.zip
copy https://data.nber.org/sipp/2008/sippl08puw4.dct $extractdir/08w4.dct
copy https://data.nber.org/sipp/2008/l08puw5.zip $extractdir/08w5.zip
copy https://data.nber.org/sipp/2008/sippl08puw5.dct $extractdir/08w5.dct
copy https://data.nber.org/sipp/2008/l08puw6.zip $extractdir/08w6.zip
copy https://data.nber.org/sipp/2008/sippl08puw6.dct $extractdir/08w6.dct
copy https://data.nber.org/sipp/2008/l08puw7.zip $extractdir/08w7.zip
copy https://data.nber.org/sipp/2008/sippl08puw7.dct $extractdir/08w7.dct
copy https://data.nber.org/sipp/2008/l08puw8.zip $extractdir/08w8.zip
copy https://data.nber.org/sipp/2008/sippl08puw8.dct $extractdir/08w8.dct
copy https://data.nber.org/sipp/2008/l08puw9.zip $extractdir/08w9.zip
copy https://data.nber.org/sipp/2008/sippl08puw9.dct $extractdir/08w9.dct
copy https://data.nber.org/sipp/2008/l08puw10.zip $extractdir/08w10.zip
copy https://data.nber.org/sipp/2008/sippl08puw10.dct $extractdir/08w10.dct
copy https://data.nber.org/sipp/2008/l08puw11.zip $extractdir/08w11.zip
copy https://data.nber.org/sipp/2008/sippl08puw11.dct $extractdir/08w11.dct
copy https://data.nber.org/sipp/2008/l08puw12.zip $extractdir/08w12.zip
copy https://data.nber.org/sipp/2008/sippl08puw12.dct $extractdir/08w12.dct
copy https://data.nber.org/sipp/2008/l08puw13.zip $extractdir/08w13.zip
copy https://data.nber.org/sipp/2008/sippl08puw13.dct $extractdir/08w13.dct
copy https://data.nber.org/sipp/2008/l08puw14.zip $extractdir/08w14.zip
copy https://data.nber.org/sipp/2008/sippl08puw14.dct $extractdir/08w14.dct
copy https://data.nber.org/sipp/2008/l08puw15.zip $extractdir/08w15.zip
copy https://data.nber.org/sipp/2008/sippl08puw15.dct $extractdir/08w15.dct
copy https://data.nber.org/sipp/2008/l08puw16.zip $extractdir/08w16.zip
copy https://data.nber.org/sipp/2008/sippl08puw16.dct $extractdir/08w16.dct

02_confirm_sipp_manifest.do

confirm file $extractdir/08w10.dct
confirm file $extractdir/08w10.zip
confirm file $extractdir/08w11.dct
confirm file $extractdir/08w11.zip
confirm file $extractdir/08w12.dct
confirm file $extractdir/08w12.zip
confirm file $extractdir/08w13.dct
confirm file $extractdir/08w13.zip
confirm file $extractdir/08w14.dct
confirm file $extractdir/08w14.zip
confirm file $extractdir/08w15.dct
confirm file $extractdir/08w15.zip
confirm file $extractdir/08w16.dct
confirm file $extractdir/08w16.zip
confirm file $extractdir/08w1.dct
confirm file $extractdir/08w1.zip
confirm file $extractdir/08w2.dct
confirm file $extractdir/08w2.zip
confirm file $extractdir/08w3.dct
confirm file $extractdir/08w3.zip
confirm file $extractdir/08w4.dct
confirm file $extractdir/08w4.zip
confirm file $extractdir/08w5.dct
confirm file $extractdir/08w5.zip
confirm file $extractdir/08w6.dct
confirm file $extractdir/08w6.zip
confirm file $extractdir/08w7.dct
confirm file $extractdir/08w7.zip
confirm file $extractdir/08w8.dct
confirm file $extractdir/08w8.zip
confirm file $extractdir/08w9.dct
confirm file $extractdir/08w9.zip
confirm file $extractdir/92w1.dct
confirm file $extractdir/92w1.zip
confirm file $extractdir/92w2.dct
confirm file $extractdir/92w2.zip
confirm file $extractdir/92w3.dct
confirm file $extractdir/92w3.zip
confirm file $extractdir/92w4.dct
confirm file $extractdir/92w4.zip
confirm file $extractdir/92w5.dct
confirm file $extractdir/92w5.zip
confirm file $extractdir/92w6.dct
confirm file $extractdir/92w6.zip
confirm file $extractdir/92w7.dct
confirm file $extractdir/92w7.zip
confirm file $extractdir/92w8.dct
confirm file $extractdir/92w8.zip
confirm file $extractdir/92w9.dct
confirm file $extractdir/92w9.zip
confirm file $extractdir/93w1.dct
confirm file $extractdir/93w1.zip
confirm file $extractdir/93w2.dct
confirm file $extractdir/93w2.zip
confirm file $extractdir/93w3.dct
confirm file $extractdir/93w3.zip
confirm file $extractdir/93w4.dct
confirm file $extractdir/93w4.zip
confirm file $extractdir/93w5.dct
confirm file $extractdir/93w5.zip
confirm file $extractdir/93w6.dct
confirm file $extractdir/93w6.zip
confirm file $extractdir/93w7.dct
confirm file $extractdir/93w7.zip
confirm file $extractdir/93w8.dct
confirm file $extractdir/93w8.zip
confirm file $extractdir/93w9.dct
confirm file $extractdir/93w9.zip
confirm file $extractdir/96l10.dct
confirm file $extractdir/96l10.zip
confirm file $extractdir/96l11.dct
confirm file $extractdir/96l11.zip
confirm file $extractdir/96l12.dct
confirm file $extractdir/96l12.zip
confirm file $extractdir/96l1.dct
confirm file $extractdir/96l1.zip
confirm file $extractdir/96l2.dct
confirm file $extractdir/96l2.zip
confirm file $extractdir/96l3.dct
confirm file $extractdir/96l3.zip
confirm file $extractdir/96l4.dct
confirm file $extractdir/96l4.zip
confirm file $extractdir/96l5.dct
confirm file $extractdir/96l5.zip
confirm file $extractdir/96l6.dct
confirm file $extractdir/96l6.zip
confirm file $extractdir/96l7.dct
confirm file $extractdir/96l7.zip
confirm file $extractdir/96l8.dct
confirm file $extractdir/96l8.zip
confirm file $extractdir/96l9.dct
confirm file $extractdir/96l9.zip

display in green "If you got this far, all required SIPP files are present"

03_unzip_sipp.do

// need to change directory because Stata does not know about
// destination directories

cd "$extractdir"

unzipfile 08w10.zip, replace
unzipfile 08w11.zip, replace
unzipfile 08w12.zip, replace
unzipfile 08w13.zip, replace
unzipfile 08w14.zip, replace
unzipfile 08w15.zip, replace
unzipfile 08w16.zip, replace
unzipfile 08w1.zip, replace
unzipfile 08w2.zip, replace
unzipfile 08w3.zip, replace
unzipfile 08w4.zip, replace
unzipfile 08w5.zip, replace
unzipfile 08w6.zip, replace
unzipfile 08w7.zip, replace
unzipfile 08w8.zip, replace
unzipfile 08w9.zip, replace
unzipfile 92w1.zip, replace
unzipfile 92w2.zip, replace
unzipfile 92w3.zip, replace
unzipfile 92w4.zip, replace
unzipfile 92w5.zip, replace
unzipfile 92w6.zip, replace
unzipfile 92w7.zip, replace
unzipfile 92w8.zip, replace
unzipfile 92w9.zip, replace
unzipfile 93w1.zip, replace
unzipfile 93w2.zip, replace
unzipfile 93w3.zip, replace
unzipfile 93w4.zip, replace
unzipfile 93w5.zip, replace
unzipfile 93w6.zip, replace
unzipfile 93w7.zip, replace
unzipfile 93w8.zip, replace
unzipfile 93w9.zip, replace
unzipfile 96l10.zip, replace
unzipfile 96l11.zip, replace
unzipfile 96l12.zip, replace
unzipfile 96l1.zip, replace
unzipfile 96l2.zip, replace
unzipfile 96l3.zip, replace
unzipfile 96l4.zip, replace
unzipfile 96l5.zip, replace
unzipfile 96l6.zip, replace
unzipfile 96l7.zip, replace
unzipfile 96l8.zip, replace
unzipfile 96l9.zip, replace

// return to rootdir

cd "$rootdir"

main.do

// this should be in the master file. Copied here for te4sting
global rootdir : pwd
global extractdir "$rootdir/raw"

// These parameters should be set in the master file
global sippdownload 0
global sippextract  1

cap mkdir "$extractdir"
if $sippdownload == 1  {
  do 01_download_sipp1992.do
  do 01_download_sipp1993.do
  do 01_download_sipp1996.do
  do 01_download_sipp2008.do
}

do 02_confirm_sipp_manifest.do

if $sippextract == 1 {
  do 03_unzip_sipp.do
}

display in green "SIPP preparation done"

exit, clear STATA