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
Normalizing GraphsHello All, I am attempting to normalize my graph to match the unconditional average for the corresp…
Availability of PDF format for graph exportDear All, Stata's electronic help files for graph export mention availability of different file for…
How can I copy the entire Stata code *.do I'm running in an excel fileHi, I am running multiple simulations per day and I would like to get all necessary information enc…
Running svy and clogit and get "the group() variable is not nested within the final stage sampling units" errorHi, I am working with National Inpatient Sample (NIS). Considering the survey design, I am running …
Reporting format for Stata's own commandsDear All, I've noticed just now that some of Stata's own commands report the output diagnostics usi…
Subscribe to:
Post Comments (Atom)
0 Response to Creating Percent Change Variable
Post a Comment