Hi All, I have been searching around and am not sure it is even possible, but I was wondering if anyone knows a way to force sas to do this. I am running a simple proc tabulate with a by statement. There are a few more of my by statement variables that do now have any options. For example: Proc Tabulate data=have; By state; Class cat1 cat2 / preloadfmt; Table cat1 all, cat2 all / printmiss misstext=‘0’; Format cat1 c1_var. Cat2 c2_var2.; Run; For my by statement, out of states 1 - 50, States 22 and 37 do not have any observations this quarter, so they don’t come up in the output…but is there a way to force them to, showing all zeroes or null? I have poked around online and found one article on the matter….but I am having a bit of a challenging time making it work and am hoping for a more…straightforward solution if possible. I appreciate any insight!
... View more