Hi, I have a dataset as below ( I have county counts per month per year), how to create a new variable as the total count for each year per county? also I have variable Z per month per county each year, howw to get the Z median as a new variable for each county for each year? I tried this code but it is not working: DATA CORRECT_TOTAL; INPUT COUNTY YEAR PRECIPITATION TOTCOUNTS ; BY YEAR COUNTY; PRECIPITATION= MEDIAN(JAN_Z,FEB_Z,MAR_Z,APR_Z,MAY_Z,JUN_Z,JUL_Z, AUG_Z,SEP_Z, OCT_Z,NOV_Z,DEC_Z); COUNTS= SUM(JAN_COUNT, FEB_COUNT, ...); RUN; CUNTY YEAR JAN-Z JAN-COUNT FEB-Z FEB-COUNT MAR-Z MAR-COUNT APR-Z APR-COUNT MAY-Z MAY-COUNT JUN-Z JUN-COUNT JUL-Z JUL-COUNT AUG-Z AUG-COUNT SEPT-Z SEPT-COUNT OCT-Z OCT-COUNT NOV-Z NOV-COUNT DEC-Z DEC-COUNT X 2014 -0.4 2 -0.4 1 -0.2 1 -0.3 1 -0.2 2 -0.2 1 -0.6 1 -0.8 0 -0.9 1 -0.8 1 -1.6 1 -0.9 0 X 2015 -0.2 1 0 0 -0.1 4 0 3 0.3 0 0.6 1 0.9 4 1 2 0.8 4 1.2 3 1.4 1 1.3 0 X 2016 0.9 2 0.7 0 0.5 2 0.6 2 0.4 2 0.2 0 -0.2 1 -0.2 2 -0.2 0 -0.7 0 -0.6 2 -0.3 3 X 2017 0 3 0.2 4 0.4 2 0.3 3 0.2 1 0.2 1 0.4 4 -0.1 3 -0.1 4 -0.2 2 -0.7 1 -1.3 2 X 2018 -1.7 2 -1.8 0 -1.8 1 -2 4 -2.1 1 -2 1 -2.1 2 -2 1 -2.1 3 -1.1 2 -1.1 3 -0.6 1 X 2019 -0.4 5 -0.1 3 0.1 1 0.2 3 0.5 1 0.5 1 0 6 -0.1 6 0 4 -0.8 4 -0.2 4 -0.1 4 Y 2014 -0.6 6 -0.7 7 -0.5 4 -0.5 5 -0.5 8 -0.5 6 -0.8 1 -0.3 6 0.4 1
... View more