/**Exercise: Time Use Variables and Weekday and Weekend Time Diaries/
svyset [weight=wt06];

/*Recode day of the week*/
gen newday=.;
	replace newday=1 if day>=2 & day<=6;
	replace newday=2 if day==7;
	replace newday=3 if day==1;

/*keep only respondents 25 to 64*/
keep if age>=25 & age<=64;

/*generate new time use variables*/
gen ex_new=ex64+ex46;
gen exal_new=exal64+exal46;
gen exoth_new=exoth64+exoth46;

/*create dummy variable for female*/
gen female=0;
	replace female=1 if sex==2;
		
/*generate means for exercising by gender, by gender & day*/
svy: mean ex612 ex126 ex_new, over(female);
svy: mean ex612 ex126 ex_new, over(female newday);

/*generate means for exercising alone by gender, by gender & day*/
svy: mean exal612 exal126 exal_new, over(female);
svy: mean exal612 exal126 exal_new, over(female newday);

/*generate means for exercising with others by gender, by gender & day*/
svy: mean exoth612 exoth126 exoth_new, over(female);
svy: mean exoth612 exoth126 exoth_new, over(female newday);