I have extracted from 2025 and 2024 Census SIPP files the records for householders in the month of December. There are 13910 records in 2025 and 15,877 in 2024. I am using the Catenate command to link the two files, not a merge or update command. I am creating a new file with a column indicating source.
I get a file of 15,877 records, not 33000. I get no source column. Since these records were collected in different years, the same person's record would not be the same over two years, because year is one of the data elements.
It seems that concatenation is simply not occurring. Any thoughts?
