Hello, I have a dataset which is updated weekly in which there are rows missing depending on the week’s data. I’m trying to get each row to complete and produce a list of which states haven’t reported any data that week. There should be a line for each state for each week. Once I have a row for each of the 52 weeks for each year, I want to fill in the missing rainfall value with a 0. I’ve tried a number of array variations and haven’t been able to get this to work as the values aren’t exactly missing, it’s the whole row that doesn’t exist. It would be a fairly simple complete step in R but I can’t get it to translate to SAS. The person I inherited this code from has been filling in the missing rows each week manually and I refuse to keep doing this for all 50ish ‘states’ (obviously this is a made up set). For example right now I have, State Year Week Rainfall Illinois 2020 1 2 Illinois 2021 2 5 Illinois 2021 4 6 Missouri 2021 3 8 Missouri 2021 5 1 Missouri 2022 6 3 Missouri 2022 7 2 Wisconsin 2021 1 1 Wisconsin 2021 4 3 Wisconsin 2022 6 2
... View more