Hi @mayasak,
Without sample data it's a bit hard to say, but my first guess is that the coding of variable GEO might be not ideal: If NUMGEO is to be the number of geocoded items, the code for "not geocoded" should be 0, not 2. Otherwise NUMGEO is likely to be too large, leading to incorrectly large values of GEOPCT, possibly GEOPCT>1, as you've observed.
Hi @mayasak,
Without sample data it's a bit hard to say, but my first guess is that the coding of variable GEO might be not ideal: If NUMGEO is to be the number of geocoded items, the code for "not geocoded" should be 0, not 2. Otherwise NUMGEO is likely to be too large, leading to incorrectly large values of GEOPCT, possibly GEOPCT>1, as you've observed.
Ya you're so right. We're dealing with counts here. Thanks a lot FreelanceReinhard. I just have another question if you don't mind. As I said, I have to see if there is any difference in death rates in small areas due to difference in geocoding in two different data sets (period 1,years 2003-2007, and period 2,years 2008-2012). Do you have any thoughts about how can I do it ? So far I've calculated percentage of geocoded data in each county (not small areas), and ANOVA tests with "period" and "sarea" as independent variables and "cause of death" as dependent variable (couldn't do the interaction terms due to 0 degrees of freedom for errors).
Thanks
Thank you,
As this is a completely different question, it will be better if you open a new thread for it. To do this, you should select a different forum within the SAS Support Communities: Analytics --> SAS Statistical Procedures.
There you will attract a more targeted audience. Also, it will be helpful to describe your data a little more (types of variables and their meaning). I am not familiar with geocoding and its implications for epidemiological research questions.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.