CSPro Users Forum

I KEEP SEEING BLANK RECORDS IN MY HOUSEHOLD ROSTER. I NEED TO PREVENT IT FROM HAPPENING. ONE HOUSEHOLD MEMBER BUT 42 EXTRA BLANK OCCURRENCES. IT HAS HAPPENED TO MANY HOUSEHOLDS.

Are you creating 43 occurrences and then skipping all but the first in the roster? If you post your zipped application here or to the mailing list cspro@lists.census.gov we will be able to test it and look at the code to see more details about where this problem is happening.

Thanks,
Justin

He can always use the delete occurrence

// remove "blank" person records
do numeric i = totocc(PERSON_REC) while i >= 1 by -1

if RELATIONSHIP(i) = notappl and SEX(i) = notappl and AGE(i) = notappl then
delete(PERSON_REC(i));
endif;

enddo;

You generally don't want to do this kind of clean up on collected data, you should be correcting the source of the error, i.e., how did the blank records get generated in the first place. Once we see the application we can figure out what's going on.

Hello,
I had this situation, and it happened when for example you enter only the first line in the roster, and the roster is defined with 40 occurrences, then you exit the roster and do a partial save, then all the occurrences remain there, but if you end the case, all the empty lines are removed.

Hope this information can help.

Mario

Hi Mario,

If you can reproduce this problem then you're gold! If we can't reproduce it then we often can't find the source of the bug.

Sorry for delayed response, Happy New Year!
Sherrell