# Data download issue Stata18

**URL:** <https://forum.ipums.org/t/data-download-issue-stata18/5469>\
**Category:** USA\
**Created:** [September 28, 2023, 6:34pm UTC](https://forum.ipums.org/t/data-download-issue-stata18/5469 "2023-09-28T18:34:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gab\_res](https://avatars.discourse-cdn.com/v4/letter/g/f17d59/32.png) [@gab\_res](https://forum.ipums.org/u/gab_res)\
**Post date:** [September 28, 2023, 6:34pm UTC](https://forum.ipums.org/t/data-download-issue-stata18/5469/1 "2023-09-28T18:34:39Z")

</div>

Hi,

I’ve extracted a 5% sample for the US Census from IPUMS USA and also the lines of code to import these data into Stata (18 version).

When I run the code folder\filename.dat.gz, the matrix of data is full of missing observations.  
Additional info: once downloaded the file extract is quite small in size (127MB), while on the webpage “Extract request” it says the file size is 1341.4MB.

Any help/consideration at this point is greatly appreciated.

Thank you,  
Gabriele

---

<div class="post-metadata">

**Author:** ![Ivan\_Strahof](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/ivan_strahof/32/626_2.png) [@Ivan\_Strahof](https://forum.ipums.org/u/Ivan_Strahof)\
**Post date:** [September 29, 2023, 8:49pm UTC](https://forum.ipums.org/t/data-download-issue-stata18/5469/2 "2023-09-29T20:49:15Z")

</div>

Hi Gabriele,

I was able to download and input the data from your extract #113 into Stata without encountering these missing observations. Regarding the difference in the file sizes, the _Extract Request_ page reports the size of the file once it has been decompressed, while the 127MB refers to the compressed file size. I recommend reviewing [these instructions for opening IPUMS extracts](https://usa.ipums.org/usa/extract_instructions.shtml). Make sure that the downloaded .gz.dat file is decompressed; we recommend [7-zip for Windows users](https://7-zip.org/) and [the Unarchiver for Mac](https://theunarchiver.com/) as free decompression software. I hope that helps!
