BLANK OCCURRENCES IN ROSTER

Discussions about editing and cleaning data
Post Reply
RERII
Posts: 56
Joined: March 4th, 2015, 11:34 am

BLANK OCCURRENCES IN ROSTER

Post by RERII »

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.
justinlakier
Posts: 152
Joined: November 21st, 2022, 4:41 pm

Re: BLANK OCCURRENCES IN ROSTER

Post by justinlakier »

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
PURPLESTUFF
Posts: 3
Joined: November 30th, 2023, 12:43 pm

Re: BLANK OCCURRENCES IN ROSTER

Post by PURPLESTUFF »

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;
sherrell
Posts: 397
Joined: April 2nd, 2014, 9:16 pm
Location: Washington, DC

Re: BLANK OCCURRENCES IN ROSTER

Post by sherrell »

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.
Mariovaisman
Posts: 133
Joined: February 11th, 2013, 8:26 am

Re: BLANK OCCURRENCES IN ROSTER

Post by Mariovaisman »

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
sherrell
Posts: 397
Joined: April 2nd, 2014, 9:16 pm
Location: Washington, DC

Re: BLANK OCCURRENCES IN ROSTER

Post by sherrell »

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
Post Reply