I am creating cross tabs by State. I know some of these cross tabs will be zero, but I want to see them and keep them in the output data set so i am using the option SPARSE. I am running into a problem where the output is not keeping all of the zero cross tabs. In particular, in my case I have two cross tabs with zero values but the output is only keeping the first one. See sample code below.
Anyone have any suggestions as to what I'm doing wrong? Has anyone else had this problem?
I gave it a try and it did not help. It looks to me like you only need either LIST or OUT= for sparse to work. I am having a weird situation because it appears to work for some but not for all. I am also running the same program for other years and I haven't had any problem.