Dear all,
I am a first time Stata user for my master thesis. My dataset has 304 observations and I am working with a checklist. Each checklist step is a variable (Step1-10), that has categorical value (completed vs not completed) but is coded as 1(completed) and 0(not completed).
My aim is to in the end be able to say that on average x/10 checklist steps were completed per observation. I thought I would start by calculating the amount of steps completed per observation. I was trying to generate a new variable for this (Checklist Score) that would give me the sum of the values over Step1-Step10 in each row.
I tried:
egen x=rowtotal (Step1-Step10)
but this seemes to show me something different.
If anyone has a tip I would be very grateful.
Resa
I am a first time Stata user for my master thesis. My dataset has 304 observations and I am working with a checklist. Each checklist step is a variable (Step1-10), that has categorical value (completed vs not completed) but is coded as 1(completed) and 0(not completed).
My aim is to in the end be able to say that on average x/10 checklist steps were completed per observation. I thought I would start by calculating the amount of steps completed per observation. I was trying to generate a new variable for this (Checklist Score) that would give me the sum of the values over Step1-Step10 in each row.
I tried:
egen x=rowtotal (Step1-Step10)
but this seemes to show me something different.
If anyone has a tip I would be very grateful.
Resa

Comment