Hi, I am trying to set up a format but having some trouble. I'd like to set missing values to 0, set values 1-10 as *, and any other value/greater than 10 to just remain the same. Then I'd like to use the format in a proc sql step. I currently have the following: proc format; VALUE suppressf . = 0 1-10 = '*' other= ' '; proc sql; select year, month, put((count(*)), suppressf.) as recordcnt from ddata.d2020 group by year, month; quit; When I run this, it looks like the * value is working, but the ones that were missing get dropped and the other value ones are blank. (also for clarification, if there was a value of 17, i'd want it to remain 17 since it's not missing or in the range of 1-10.) I'm pretty sure there is an issue in the way i'm defining the format, as I've done other formats in the proc sql step in a similar way, and those have worked as intended. Just not sure what to fix. Any help would be really appreciated!
... View more