[Andrew Musau]

It is indeed interesting! Gotcha2 explains it:

One feature of preserve that catches many users by surprise is that, if you preserve data in a do file, the data is automatically and silently restored when the do file finishes even if no restore command has been reached (including when the do file crashes!)

Adding the line

tab enquetecible

within the dofile will clear the mystery.

[Kamala Kaghoma]

I've tried but I am still getting the same 95 observations for all the variables I try to tabulate.

[Andrew Musau]

Add the following two commands before restore at the end of the do-file and copy and paste the output as I do below. Make sure the last statement that you see is "end of do-file".

tab Educ_1
tab enquetecible

My output:

. tab Educ_1

 Ecoles: organisée & |
         bien gérées |      Freq.     Percent        Cum.
---------------------+-----------------------------------
 En  total désaccord |          9        9.47        9.47
       En  désaccord |         35       36.84       46.32
              Neutre |         19       20.00       66.32
            D'accord |         28       29.47       95.79
Tout à fait d’accord |          4        4.21      100.00
---------------------+-----------------------------------
               Total |         95      100.00

. tab enquetecible

                Enquêté cîble |      Freq.     Percent        Cum.
------------------------------+-----------------------------------
                       Ménage |      1,258       92.98       92.98
Ménage et Unité de production |         95        7.02      100.00
------------------------------+-----------------------------------
                        Total |      1,353      100.00

. *********************************************************************
. /*
>
> restore
> *************************************
> ** MODULE CIVISME FISCAL **
> *************************************
>

end of do-file

[Kamala Kaghoma]

Dear Andrew, Thank you for the response. the added part is available in the dofile I have which has another part that I didn't put in the one I've uploaded here. However, from the output above, it appears clearly that though we are supposed to have the output of (tab Educ_1) for 1353 observations, it is appearing only for the 95 onces representing a small part of the set of units which have responded to the questionnaire. That is where my true problem resides. I have no clue on what can be the reason for that exclusion of the rest of observations.

[Kamala Kaghoma]

In fact, if I try

 keep if inlist(enquetecible,1)

or

 keep if inlist(enquetecible, 2)

all the variables loose their observations, even those for which there is no missing observations.!

[Andrew Musau]

I suggest that you look at the responses for the variable "Educ_1". While it is true that you have 1353 observations for the variable "enquetecible", you have only 95 responses for the former.

. tab Educ_1 if enquetecible==3

                   Educ_1 |      Freq.     Percent        Cum.
--------------------------+-----------------------------------
                D'accord  |         28       29.47       29.47
    En  total
désaccord   |          9        9.47       38.95
          En  désaccord   |         35       36.84       75.79
                   Neutre |         19       20.00       95.79
     Tout à fait d’accord |          4        4.21      100.00
--------------------------+-----------------------------------
                    Total |         95      100.00

. tab Educ_1 if enquetecible==1
no observations

.

[Kamala Kaghoma]

I suggest that you look at the responses for the variable "Educ_1". While it is true that you have 1353 observations for the variable "enquetecible", you have only 95 responses for the former.

No, in the dataset that I've attached in post #21 even for the "Educ_1" there more than 1200 non-missing observations. It is this situation that is really difficult to understand.

[Andrew Musau]

We have different datasets then. Importing the dataset and without doing anything else, this is what I get. From my side, I see nothing inconsistent.

. import excel "C:\Users\709554\Desktop\BD_all1_versions_25.01.2020.xlsx", sheet("perception_qlty") firstrow cl
> ear
(549 vars, 1,682 obs)

. tab Educ_1

                   Educ_1 |      Freq.     Percent        Cum.
--------------------------+-----------------------------------
                D'accord  |         28       29.47       29.47
    En  total
désaccord   |          9        9.47       38.95
          En  désaccord   |         35       36.84       75.79
                   Neutre |         19       20.00       95.79
     Tout à fait d’accord |          4        4.21      100.00
--------------------------+-----------------------------------
                    Total |         95      100.00

EDIT: Maybe the confusion is caused by how you define an observation. Yes, the dataset has 1682 observations, but when you tabulate, you get the frequency of non-missing observations for a given variable. The above shows that Educ_1 has 95 non-missing observations.

[Kamala Kaghoma]

Dear Andrew,
Many thanks for all. there was a replication of variables in the datasets and when I wrote my dofile I did not realize that. So while I was referring to the replicates of the same variables with their number of observations STATA was considering the initial ones which were restricted to just a sub-sample. After being aware of this issue I think everything is now fine with. I've just obtained this:

. tab contact12m_Mairie, nolab

contact12m_ |
     Mairie |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      1,488       94.30       94.30
          1 |         59        3.74       98.04
          3 |         31        1.96      100.00
------------+-----------------------------------
      Total |      1,578      100.00

Many thanks.