Missing years when uploading datas

#1

Hi,

I am trying to get datas on care for some demographic datas and insurance acces for the period 2005 to 2017, but when I open the file in csv on my laptop, only the year 2005 appears to be there.

Any toughts ?

Regards,

Alex

0 Likes

#2

For your information, whe I download it in .dta, it works fine and I get the full sample.

0 Likes

#3

Since you are extracting many samples, your data set will be relatively large. Note that although .csv files do not have a maximum row limit, if you open a .csv file in Excel only the first 1,048,576 rows will show up. This is because Excel has a maximum row limit. This also explains why the issue does not persist when you use Stata which has no maximum row limit.

0 Likes