When loaded in R, for samples 2019-2023 and variable CPSFAMSIZE, the value NIU only shows up in the data frame for certain rows, the rest are completely empty showing no value. Is it a faulty data extract? Thank you for your attention to this matter.
I was able to load your extract into R and did not observe this issue. I recommend reviewing this ipumsr vignette, which walks through the steps of loading an IPUMS fixed-width extract into R. You will need to download two files from the My Data page: (1) your .dat.gz compressed data file and (2) the corresponding .xml DDI codebook. The data file should be saved in the same folder as the .xml codebook. You should then set this folder as your working directory in R, load the ipumsr package, and run the accompanying R code provided on the My Data page (under command files):
ddi ← read_ipums_ddi(“meps_00001.xml”)
data ← read_ipums_micro(ddi)
This will apply the correct codes to your data.