The DHS Program User Forum       Discussions regarding The DHS Program data and results
Home » Topics » HIV » comprehensive knowledge of HIV AIDS
comprehensive knowledge of HIV AIDS Wed, 29 July 2015 15:30
 cmjacob Messages: 1Registered: July 2015 Location: United Kingdom Member
I am doing a secondary data analysis of Women's empowerment and HIV-KAB in Zambia and my outcome measure is 'comprehensive knowledge (CK) of HIV aids. I intend to use binary logistic regression for the study and have tried to create the CK variable on SPSS. However I am not able to create it as a 1/0 variable. I have found certain other studies that have used this variable as an outcome measure but they have used stata for the same.
I was wondering if it is possible to create a 1/0 variable on SPSS for comprehensive knowledge (I tried using Compute new variable - and gave the IF command to check if answers to the 5 questions about HIV, were answered correctly ; and also recode into new variable - but it did not work.)
If someone has created this variable on SPSS before it would be great if you could share the syntax with me.
Re: comprehensive knowledge of HIV AIDS [message #6949 is a reply to message #6893] Thu, 06 August 2015 10:34
 Liz-DHS Messages: 1046Registered: February 2013 Senior Member
Dear User,
We have submitted your query to one of our experts. As soon as we have a response, we will post.
Thank you!
Re: comprehensive knowledge of HIV AIDS [message #6953 is a reply to message #6949] Thu, 06 August 2015 12:15
 Trevor-DHS Messages: 527Registered: January 2013 Senior Member
Try the following code:
* A healthy-looking person can have the AIDS virus.
IF (V756 = 1) Healthy = 1.
VARIABLE LABELS Healthy "A healthy-looking person can have the AIDS virus".
VALUE LABELS Healthy 1 "A healthy-looking person can have the AIDS virus".

* The AIDS  virus cannot be transmitted by mosquito bites [COUNTRY SPECIFIC].
IF (V754JP = 0) Mosquito = 1.
VARIABLE LABELS Mosquito "The AIDS  virus cannot be transmitted by mosquito bites [COUNTRY SPECIFIC]".
VALUE LABELS Mosquito 1 "The AIDS  virus cannot be transmitted by mosquito bites [COUNTRY SPECIFIC]".

* The AIDS virus cannot be transmitted by supernatural means [COUNTRY SPECIFIC] .
IF (V823 = 0) SNmeans = 1.
VARIABLE LABELS SNmeans "The AIDS virus cannot be transmitted by supernatural means [COUNTRY SPECIFIC]".
VALUE LABELS SNmeans 1 "The AIDS virus cannot be transmitted by supernatural means [COUNTRY SPECIFIC]".

* A person cannot become infected by sharing food with a person who has the AIDS virus [COUNTRY SPECIFIC] .
IF (V754WP = 0) Sfood = 1.
VARIABLE LABELS SFood "A person cannot become infected by sharing food with a person who has the AIDS virus [COUNTRY SPECIFIC]".
VALUE LABELS SFood 1 "A person cannot become infected by sharing food with a person who has the AIDS virus [COUNTRY SPECIFIC]".

* The two most common local misconception.
* Need to pick the two most common misconceptions - typically mosquito bites and sharing food - but this can vary from survey to survey.
COUNT MSConcep = mosquito, Sfood (1).
*COUNT MSConcep = mosquito, SNMeans (1).

* A healthy-looking person can have the AIDS virus and who reject the two most common local misconceptions.
IF (Healthy = 1 & MSConcep = 2) MCReject = 1.
VARIABLE LABELS MCReject "".
VALUE LABELS MCReject 1 "Percentage who say that a healthy-looking person can have the AIDS virus and who reject the two most common local misconceptions".

* Percentage with a comprehensive knowledge about AIDS.
IF (V754CP = 1 & V754DP = 1 & Healthy = 1 & MSConcep = 2) knowAIDS = 1.
VARIABLE LABELS knowAIDS "".
VALUE LABELS knowAIDS 1 "Percentage with a comprehensive knowledge about AIDS".

Note that the selection for the two most common mis-conceptions in the middle of the code is survey specific, and will vary from country to country.
Re: comprehensive knowledge of HIV AIDS [message #10653 is a reply to message #6953] Thu, 25 August 2016 17:25
 CKAllen Messages: 7Registered: April 2016 Location: London, UK Member
Does anyone know what the two most common local misconceptions are for Zambia 2007?
On page xxvii of the ZDHS report, it reports 'sharing food' and 'mosquito bites' as the two most common local misconceptions.
On page 192 and 193, it reports 'supernatural means' and 'mosquito bites' as the two most common local misconceptions.

I found similar inconsistencies in 2013 ZDHS report.

Re: comprehensive knowledge of HIV AIDS [message #10660 is a reply to message #10653] Fri, 26 August 2016 14:33
 Liz-DHS Messages: 1046Registered: February 2013 Senior Member
A response from Senior Technical Expert, Dr. Kia Reinis:
Quote:

Dear CK Allen,
Thank you for your question.

The misconceptions pertaining to means of transmission that are the two most common: people can get HIV from mosquito bites and people can get HIV from witchcraft or other supernatural means. This is true in both the 2007 and 2013-14, and the data in the chapter tables indicate such.

Footnote 8 in the MDG table in the 2007 report is in error, it should have referred to supernatural means, and not to sharing food.
The text on page 199 of the 2013-14 report is not correct. The excerpt from the report (shown below) that states sharing food is one of the two most common misconceptions is an error, it should have stated "that a person can get HIV via supernatural means" and not "by sharing food".

Thank you very much for bringing this to our attention.
We appreciate your use of DHS data.

[Updated on: Fri, 26 August 2016 19:11] by Moderator

Report message to a moderator

Re: comprehensive knowledge of HIV AIDS [message #10662 is a reply to message #10660] Sat, 27 August 2016 10:22
 CKAllen Messages: 7Registered: April 2016 Location: London, UK Member
Thank you, Dr. Reinis for such a quick response. This will clear up which variables to use. Very helpful!
Re: comprehensive knowledge of HIV AIDS [message #11571 is a reply to message #6953] Wed, 11 January 2017 11:01
 enansubuga Messages: 1Registered: January 2017 Location: Uganda Member
Dear Trevor,

Is it possible to have the STATA syntax for comprehensive knowledge. I guess I can better understand the recoding of variables in STATA.

Thank you.

Elizabeth
Re: comprehensive knowledge of HIV AIDS [message #12350 is a reply to message #11571] Wed, 03 May 2017 22:37
 Trevor-DHS Messages: 527Registered: January 2013 Senior Member
Its a pretty easy conversion of the SPSS code to Stata, but here it is:
* A healthy-looking person can have the AIDS virus.
gen healthy = 1 if v756 == 1
label var healthy "A healthy-looking person can have the AIDS virus"
label def Healthy 1 "A healthy-looking person can have the AIDS virus"
label val healthy Healthy

* The AIDS virus cannot be transmitted by mosquito bites [COUNTRY SPECIFIC].
gen mosquito = 1 if v754jp == 0
label var mosquito "The AIDS virus cannot be transmitted by mosquito bites [COUNTRY SPECIFIC]"
label def Mosquito 1 "The AIDS virus cannot be transmitted by mosquito bites [COUNTRY SPECIFIC]"
label val mosquito Mosquito

* The AIDS virus cannot be transmitted by supernatural means [COUNTRY SPECIFIC] .
gen snmeans = 1 if v823 == 0
label var snmeans "The AIDS virus cannot be transmitted by supernatural means [COUNTRY SPECIFIC]"
label def SNmeans 1 "The AIDS virus cannot be transmitted by supernatural means [COUNTRY SPECIFIC]"
label val snmeans SNmeans

* A person cannot become infected by sharing food with a person who has the AIDS virus [COUNTRY SPECIFIC] .
gen sfood = 1 if v754wp == 0
label var sfood "A person cannot become infected by sharing food with a person who has the AIDS virus [COUNTRY SPECIFIC]"
label def SFood 1 "A person cannot become infected by sharing food with a person who has the AIDS virus [COUNTRY SPECIFIC]"
label val sfood SFood

* The two most common local misconception.
* Need to pick the two most common misconceptions - typically mosquito bites and sharing food - but this can vary from survey to survey.
gen msconcep = 0
replace msconcep = 1 if mosquito == 1
* if sharing food is more a more common misconception than supernatural means, use the next line
replace msconcep = msconcep + 1 if sfood == 1
* if supernatural means is a more common misconception than sharing food, use the next line instead
*replace msconcep = msconcep + 1 if snmeans == 1

* A healthy-looking person can have the AIDS virus and who reject the two most common local misconceptions.
gen mcreject = 0
replace mcreject = 1 if healthy == 1 & msconcep == 2
label var mcreject "Percentage who say that a healthy-looking person can have the AIDS virus and who reject the two most common local misconceptions"
label def MCReject 1 "Percentage who say that a healthy-looking person can have the AIDS virus and who reject the two most common local misconceptions"
label val mcreject MCReject

* Percentage with a comprehensive knowledge about AIDS.
gen knowaids = 0.
replace knowaids = 1 if v754cp == 1 & v754dp == 1 & healthy == 1 & msconcep == 2
label var knowaids "Percentage with a comprehensive knowledge about AIDS"
label def knowAIDS 1 "Percentage with a comprehensive knowledge about AIDS"
label val knowaids knowAIDS
For Zambia 2007 where supernatural means is a more common misconception than sharing food, comment out the replace command for sfood, and uncomment the replace command for snmeans instead.
 Previous Topic: Unable to download HIV and geographic datasets Next Topic: AR missing values
Goto Forum:

Current Time: Tue Sep 19 09:40:42 Eastern Daylight Time 2017