Number of Observation Missing

[Irlandi Paradizsa]

Hi everyone, I am fairly new in using stata. So many feedbacks is very much appreciated. I am currently doing my master thesis research and I am stumped on the missing observation.

I have a total number of observation data equal to 18.102

However, when i run the command to do didregress, the number of obs turns only into 96. as the picture below.

Here are some snippet of the data that i am using.

For your information, 'Tahun' means year.


Thank you so much in advance for your help.

[Andrew Musau]

Are you sure you had all 18,102 observations in the dataset when running the regression? What do you get if you run

didregress (konsumsi) (treatafter) in 2000/4000, group(id) time(tahun)

[Irlandi Paradizsa]

Are you sure you had all 18,102 observations in the dataset when running the regression? What do you get if you run

didregress (konsumsi) (treatafter) in 2000/4000, group(id) time(tahun)

Dear Andrew, thanks for the reply. Yes I am sure for the dataset used. However after running the command, the it returned like this. Any idea why?

Thanks.

[Andrew Musau]

Let's see the first 150 observations then. Copy and paste the result of the following:

dataex, count(150)

Do not post this as a screenshot. Copy and paste the text as is.

[Irlandi Paradizsa]

Let's see the first 150 observations then. Copy and paste the result of the following:

dataex, count(150)

Do not post this as a screenshot. Copy and paste the text as is.

hi Andrew, thanks for the reply. I had some help outside this thread. It was actually to create a new set of ID. I did not understand why, but the former ID didn't work but as soon as it changes into a new ID, the number of observation is not missing anymore.