

*CONFIDENTIAL CATALOG DATA*

Conlin and ODonoghue were given access to the catalog order information from the apparel and 
gear company after signing a confidentially agreement.  While this agreement prohibits Conlin 
and ODonoghue from publicly releasing this data, it does allow them to provide legitimate 
researchers restricted access to the data for replication and robustness checks.  This restricted 
access would involve researchers using the data at a secure site designated by Conlin and 
ODonoghue or submitting code which can be run on the data at the secure site.  Besides 
replication and robustness checks, the agreement allows Conlin and ODonoghue to grant 
researchers restricted access to the data for other acceptable research projects.

*STATA DO FILES USED TO GENERATE TABLES*

Table1and2categories.do - commands used to generate Tables 1 and 2 for individial categories as well as 
construct dataset containing orders from all seven categories.
Table1allcategories.do - commands used to generate last column of Table 1.
Table2and5allcategories.do - commands used to generate last column of Table 2 and Table 5.
fixedeffectsaer.do - commands used to generate database used in household fixed effect estimation in Table 3.
Table3.do - commands used to generate Table 3.
Table4.do - commands used to generate Table 4.
structboots.do - commands used to generate structural estimates in Table 5 for winter boots.
structhats.do - commands used to generate structural estimates in Table 5 for hats.
structparkacoats.do - commands used to generate structural estimates in Table 5 for parkas and coats.
structvests.do - commands used to generate structural estimates in Table 5 for vests.
structjackets.do - commands used to generate structural estimates in Table 5 for jackets.

*STATA DATA FILES - NAMES AND DESCRIPTION OF CONTENTS*

vestaer.dta - database containing vest orders.
glovemitaer.dta - database containing glove/mitten orders.
bootcoldaer.dta - database containing winter boots orders.
hatsaer.dta - database containing hat orders.
parkacoatsaer.dta - database containing parka and coat orders.
jacketsaer.dta - database containing jacket orders.
sportswearaer.dta - database containing sportwear orders.
totalaer.dta - generated in Table1and2categories.do by appending data from the seven catagories.
fixedeffects.dta - generated in fixedeffectsaer.do to run household fixed effect estimation.

Below is Description of variables in vestaer.dta databases. Variables are defined in a similar manner for the 
databases containing orders from the six other categories.


Contains data from C:\returns\AER\vestsaer.dta
  obs:       315,715                          
 vars:           102                          25 Jan 2006 10:18
 size:    96,924,505 (76.9% of memory free)
-------------------------------------------------------------------------------
              storage  display     value
variable name   type   format      label      variable label
-------------------------------------------------------------------------------
housid          float  %9.0g                  household id #
itemid          str5   %9s                    item id #
price           float  %9.0g                  price
creditca        byte   %8.0g                  =1 if credit card used
itemsord        byte   %9.0g                  # of items in order
reasonr         byte   %9.0g                  reason returned
age             int    %9.0g                  buyer's age
income          float  %9.0g                  buyer's income
housitms        int    %9.0g                  # of household orders
yrord           int    %9.0g                  year of order
moord           byte   %9.0g                  month of order
dord            byte   %9.0g                  day of order
zipcode         long   %9.0g                  buyer's 5 dig zipcode at order
internet        byte   %9.0g                  =1 if internet order
female          byte   %9.0g                  =1 if female buyer
giftdum         byte   %9.0g                  =1 if gift
receiver        byte   %9.0g                  =1 if not mailed to buyer
                                                address
otemmle         float  %9.0g                  ave. temp in calender month
                                                after order
otem            float  %9.0g                  temp on order date fahr
otemwi90        float  %9.0g                  ave. winter temp from 90-94
                                                month 12,1,2,3
oteml1          float  %9.0g                  temp one day before ordering
oteml2          float  %9.0g                  temp 2 days before ordering
oteml7          float  %9.0g                  temp 7 days before ordering
oteml8          float  %9.0g                  temp 8 days before ordering
oteml14         float  %9.0g                  temp 14 days before ordering
oteml15         float  %9.0g                  temp 15 days before ordering
otemle2         float  %9.0g                  temp 2 days after ordering
itemgid         byte   %9.0g                  group designation for itemid
itemte35        float  %9.0g                  % of item ordered when temp in
                                                month of and after order >35
itemte40        float  %9.0g                  % of item ordered when temp in
                                                month of and after order >40
ordsentl        int    %9.0g                  days between order and shipping
return          byte   %9.0g                  =1 if return
region          str2   %9s                    region of zipcode - 8 regions
moregion        byte   %9.0g                  month-region grouping
infants         byte   %9.0g                  =1 if for an infant (0 otherwise)
girls           byte   %9.0g                  =1 if for a girl (0 otherwise)
boys            byte   %9.0g                  =1 if for a boy (0 otherwise)
kids            byte   %9.0g                  =1 if for a kid (0 otherwise)
men             byte   %9.0g                  =1 if for a man (0 otherwise)
repeato         byte   %9.0g                  =1 if not first order, 0
                                                otherwise
percret         float  %9.0g                  % of prior orders returned, 0
                                                if first order
rettemp         float  %9.0g                  ave. temp on possible 2
                                                receiving dates
rettempw        float  %9.0g                  ave. temp over the 2 weeks
                                                after possible 2 receiving
                                                dates
rettemp2        float  %9.0g                  ave. temp 2 days after possible
                                                2 receiving dates
osnof           int    %9.0g                  snow on order date .1in
oswk9094        float  %9.0g                  ave. daily snow in week
os9094          float  %9.0g                  ave. daily snow
oswi9094        float  %9.0g                  ave. daily snow in winter
osnofl1         int    %9.0g                  snow 1 day before order
osnofl2         int    %9.0g                  snow 2 days before order
osnofl7         int    %9.0g                  snow 7 days before order
osnofl8         int    %9.0g                  snow 8 days before order
osnofl14        int    %9.0g                  snow 14 days before order
osnofle2        int    %9.0g                  snow 2 days after order
retsnof         float  %9.0g                  ave. snow on possible 2
                                                receiving dates
retsnof2        float  %9.0g                  ave. snow 2 days after possible
                                                2 receiving dates
orain           int    %9.0g                  rain on order date .01in
orwk9094        float  %9.0g                  ave. daily rain in week
orsu9094        float  %9.0g                  ave. daily rain in summer
or9094          float  %9.0g                  ave. daily rain
orfa9094        float  %9.0g                  ave. daily rain in fall
orwi9094        float  %9.0g                  ave. daily rain in winter
orsp9094        float  %9.0g                  ave. daily rain in spring
orainl1         int    %9.0g                  rain 1 day before order
orainl2         int    %9.0g                  rain 2 days before order
orainl7         int    %9.0g                  rain 7 days before order
orainl8         int    %9.0g                  rain 8 days before order
orainl14        int    %9.0g                  rain 14 days before order
orainle2        int    %9.0g                  rain 2 days after order
retrain         float  %9.0g                  ave. rain on possible 2
                                                receiving dates
retrain2        float  %9.0g                  ave. rain 2 days after possible
                                                2 receiving dates
orse9094        float  %9.0g                  ave. daily rain in season of
                                                order
orsl9094        float  %9.0g                  ave. daily rain in season prior
                                                to order
statefip        byte   %8.0g                  state fips
ordreclmin      int    %9.0g                  minimum days between order and
                                                receiving
ordreclmax      int    %9.0g                  maximum days between order and
                                                receiving
recreshelvemin  int    %9.0g                  minimum days between receiving
                                                and reshelving
recreshelvemax  int    %9.0g                  maximum days between receiving
                                                and reshelving
staid1          float  %9.0g                  closest station
staid2          float  %9.0g                  2nd closest station
staid3          float  %9.0g                  3rd closest station
mo12ave90       float  %9.0g                  average dec temp from 90-94
mo11ave90       float  %9.0g                  average nov temp from 90-94
mo10ave90       float  %9.0g                  average oct temp from 90-94
mo9ave90        float  %9.0g                  average sept temp from 90-94
mo8ave90        float  %9.0g                  average aug temp from 90-94
mo7ave90        float  %9.0g                  average july temp from 90-94
mo6ave90        float  %9.0g                  average june temp from 90-94
mo5ave90        float  %9.0g                  average may temp from 90-94
mo4ave90        float  %9.0g                  average april temp from 90-94
mo3ave90        float  %9.0g                  average march temp from 90-94
mo2ave90        float  %9.0g                  average feb temp from 90-94
mo1ave90        float  %9.0g                  average jan temp from 90-94        
acttemp12to3    float  %9.0g                  ave actual temp dec-mar upcoming
avemotemp90le1  float  %9.0g                  ave temp from 90-94 in lead 1
                                                month
avemotemp90le2  float  %9.0g                  ave temp from 90-94 in lead 2
                                                month
avemotemp90le3  float  %9.0g                  ave temp from 90-94 in lead 3
                                                month
actmotemple1    float  %9.0g                  ave actual temp in lead 1 month
actmotemple2    float  %9.0g                  ave actual temp in lead 2 month
actmotemple3    float  %9.0g                  ave actual temp in lead 3 month
-------------------------------------------------------------------------------

 