Hello,
I am doing a secondary data analysis of pre and post-surveys for a falls prevention program. There are 427 pre and post surveys, and each pre- and post-survey notes the # of times fallen in the past three months. I am trying to create a % change variable for each observation based on the TimesFallen_pre and TimesFallen_post variables.
I tried creating the variable by using this code:
gen ReducFalls_percent = (TimesFallen_post - TimesFallen_pre)/TimesFallen_pre
However, I the result is 417 missing values. Many of the participants recorded 0 falls on the pre-survey and 0 falls on the post-survey, so I think my issue is that 0 is being treated as missing? Or the gen command won't divide by 0?
If someone could please help me figure out the correct code to create a % change variable for each observation, that would be awesome.
Thank you
Related Posts with Creating Percent Change Variable
Create Dataset in Stata using a LoopI'm having trouble finding guidance on this. I want to create a dataset that has a variable called "…
meta regression missing dataHi everybody, I have to do a meta-analysis. The aim of this meta-analysis (37 studies) is THE preva…
Help using loop to replace values in several variables with conditionsHello, Can anyone suggest a way to use a loop to replace values in several variables with conditions…
Coefplot with note() optionDear Ladies and Gentlemen, I would like to have a longer note comment under my graphs stretching ov…
Data in Stata format for Card & KruegerDoes anyone know where i can get the data of the famous Card& Krueger, 1994. AER paper on minimu…
Subscribe to:
Post Comments (Atom)
0 Response to Creating Percent Change Variable
Post a Comment