FILENAME goptions URL "http://192.38.117.59/~linearpredictors/datafiles/goptions.sas";
%include goptions;

FILENAME url URL "http://192.38.117.59/~linearpredictors/datafiles/readVitaminD.sas";
%include url;

/*
Women from Ireland and Poland
*/ 

PROC FORMAT;
    VALUE bmigroupf
        0 = "Normal weight"
        1 = "Over weight";
RUN;

DATA irpo;
	SET vitamind (WHERE = (country in (4,6) and category=2));
    if bmi > 0 then bmigroup = 0;
    if bmi >= 25 then bmigroup = 1;

    logvitd=log10(vitd);

RUN;

proc tabulate data=irpo; 
    CLASS country bmigroup;
    var vitd;
    table (country all),(vitd*(bmigroup all))*(mean*(f=8.3) N*(f=5.0));
    format country countryf.;
    format bmigroup bmigroupf.;
run;