I have a dataset of >2000 hospitals that contains the two variables (columns) 1. HRR Code (numeric code for hospital referral region that the hospital belongs to). There are 306 distinct HRR codes 2. BDTOT (Number of beds in each hospital) I want to compute a new column that will show the number of beds in all hospitals in a particular HRR. Is there a conditional expression (possibly with a wildcard) that I can use to sum all the hospital beds for each instance of the 306 HRRs? Thanks for helping out.
... View more