using aggreated independent variable in logistic regression

[Fredrick orwa]

hi,
just asking if I can use something like carriage prevalence?(yearly carriage prevalence of streptocus pneumonia) as independent variable in logistic regression model. Where outcome variable is ipd status (1=positive,0=negative).The data is an individual level data where people's blood have been cultured to see if they turn streptoccus pneumonia positive.

[Leonardo Guizzetti]

It's unclear to me if you want to analyze binary (0/1) coded data using logistic regression with individual-level data. If this is true, then yes, no problems. What is unclear is what you mean by aggregated, because that now means you don't have individual-level data. Perhaps you can resolve this apparent conflict if the first sentence doesn't apply?

[Carlo Lazzaro]

Frederick:
as far as I know, prevelence is an aggreagated measure.
Threfore, unless you do not make your issue more detailed (by the way, why not posting a tentative Stata code of what you're after?), it is difficult (for me, at least), to reply more positively.

[Rich Goldstein]

if I understand correctly, then one implication is that the data are clustered in some fashion and this should be accounted for in some way (e.g., by using "vce(cluster clustvar)" as an option to your command), assuming that there are at least, say, 40 such clusters

[Carlo Lazzaro]

Frederick:
shamelessly taking advantage of Rich's methodological assist, you may be interested in Cameron_Miller_Cluster_Robust_October152013.pdf (ucdavis.edu).

[Fredrick orwa]

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input int ageyears float(year agecat1 hiv_status ipd_outtcome) long sex float(hiv_prevalence hiv_prevalence_Allages carriage_prevalence carriage_prevalence_Allages)
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 1 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 1 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 .  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 0 .  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 1 1 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 1 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 1 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
4 2018 1 1 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 1 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 .  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 1 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
3 2018 1 2 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 .  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
4 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 1 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 2 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 .  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
4 2018 1 1 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 1 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 1 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 1 1 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 .  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 1 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 1 0 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 1 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 1 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
4 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
2 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 1 1 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 1  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 0 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
1 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 2 1 2  .9681189 13.101247 57.28617 55.17107
3 2018 1 3 1 2  .9681189 13.101247 57.28617 55.17107
0 2018 1 3 1 1  .9681189 13.101247 57.28617 55.17107
0 2017 1 1 1 1 1.0991716 13.018712 72.72727 59.15789
1 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
3 2017 1 1 1 2 1.0991716 13.018712 72.72727 59.15789
3 2017 1 1 1 1 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
2 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 2 0 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
3 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
3 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 2 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
4 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 1 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 1 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
2 2017 1 1 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
1 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 . 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 1 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
4 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
2 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 0 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
3 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
3 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
4 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
4 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
4 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
2 2017 1 2 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
1 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 2 1 1 1.0991716 13.018712 72.72727 59.15789
3 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 . 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
3 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
3 2017 1 3 1 2 1.0991716 13.018712 72.72727 59.15789
4 2017 1 3 0 2 1.0991716 13.018712 72.72727 59.15789
2 2017 1 3 1 1 1.0991716 13.018712 72.72727 59.15789
0 2017 1 3 0 1 1.0991716 13.018712 72.72727 59.15789
end
label values agecat1 fg
label def fg 1 "<5", modify
label values hiv_status hivty
label def hivty 1 "Positive", modify
label def hivty 2 "Negative", modify
label def hivty 3 "Unknown", modify
label values ipd_outtcome ipd_out
label def ipd_out 0 "no ipd", modify
label def ipd_out 1 "ipd", modify
label values sex sex1
label def sex1 1 "Female", modify
label def sex1 2 "Male", modify

------------------ copy up to and including the previous line ------------------

Listed 500 out of 27562 observations



.
Above is my data.It is invidual level data but I nave merged carriage prevalence dat with it by year.
Was thinking of running the below code:
logistic ipd_outtcome b2.hiv_status i.sex hiv_prevalence carriage_prevalence year.But I have a feeling yearly hiv prevalence/carriage prevalence won't make sense in this model since am dealing with individual level data.Is that true?
Regards,
Fred