Hello there! I am looking for associations between pollution concentration and the specific disease hospital admissions. pollution is averaged monthly, admissions cases are summed up per months. the year is divided in 4-scales LD 0-1-2-3.
Could you please help me to group the data with stata commands.
the example of the data is below
month admissions_2019 pm_2019 admissions_2020 pm_2020 LD
Jan 127 .026 142 .086 0
Feb 131 .028 121 .077 0
Mar 133 .02 109 .053 1
Apr 118 .008 10 .029 1
May 122 .023 33 .018 2
Jun 135 .014 75 .016 2
Jul 131 .022 29 .011 3
Aug 125 .017 75 .014 3
Sep 140 .021 148 .018 3
Oct 152 .047 107 .039 3
Nov 147 .067 153 .051 3
Dec 104 .085 115 .092 3