/*--------------------------------------------
Read in data from SAS transport file
File ex6_prep.do

Gillian Raab August 04
------------------------------------------------*/
clear
cd "C:\Documents and Settings\gillian raab\My Documents\aprojects\peaslaptop\ex6datafiles\data"

fdause ex6.xpt,clear
/*-------------------------------------------
label define for all the variables

This is to get over the problem of assigning SAS
formats in Stata which I could not get
to work.
Any offers to help would be welcome 

---------------------------------------------*/
label define sector 1 "M"   2  "I" 3 "S" 4 "B"
label values sector sector
tabulate sector

label define  drgcode  0 "none"	1 "only cannabis" 2 "only glue" 3 "other drug or comb"
label values drgcode1 drgcode
label values drgcode2 drgcode
label values drgcode3 drgcode
label values drgcode4 drgcode
label values drgcode5 drgcode
label values drgcode6 drgcode

label define  sm  4   "Daily"    3   "Weekly"     2   " Less than weekly"     1   "Hardly ever"     0   "Non-smoker" 
label values sasmky80 sm
label values sbsmky80 sm
label values scsmky80 sm
label values sdsmky80 sm
label values sesmky80 sm
label values sfsmky80 sm

label define alc   5   "Few times/wk"  4  " Weekly"  3   "Monthly"  2   "Special occasions"    1  "hardly ever"   0  "Non-drinker"
label values rbalcy80 alc
label values rcalcy80 alc
label values rdalcy80 alc
label values realcy80 alc
label values rfalcy80 alc
label values raalcy80 alc

label define gender       1   "Male"      2   "Female" 
label values gender gender
label define ethgp    1   "non-white"   2   "white" 
label values ethgp ethgp

label define szindep       0   "Manual/high deprivation"      1   "Non-manual/low deprivation" 
label values szindep szindep

save "C:\Documents and Settings\gillian raab\My Documents\aprojects\peaslaptop\ex6datafiles\data\ex6.dta",replace