Dealing with Missing Values

[Sattar Khan]

Greetings Everyone!

Hopefully, you will be doing well. I have a problem with missing values. I have a variable gender diversity in number. So I have created many variables from it like

gen DV1= diversityinnumber ==1
gen DV2= diversityinnumber ==2
gen DV3= diversityinnumber ==3
gen DV4= diversityinnumber>3

But when I list DV4, in this variable a value is also allotted to a missing value.

      |----------------|
1896. |   0          0 |
1897. |   0          0 |
1898. |   0          0 |
1899. |   0          1 |
1900. |   0          1 |
      |----------------|
1901. |   0          1 |
1902. |   0          1 |
1903. |   0          0 |
1904. |   0          0 |
1905. |   0          0 |
      |----------------|
1906. |   0          1 |
1907. |   0          1 |
1908. |   0          0 |
1909. |   0          0 |
1910. |   0          0 |
      |----------------|
1911. |   0          0 |
1912. |   0          0 |
1913. |   0          0 |
1914. |   0          0 |
1915. |   0          0 |
      |----------------|
1916. |   0          0 |
1917. |   0          0 |
1918. |   0          2 |
1919. |   0          2 |
1920. |   0          2 |
      |----------------|
1921. |   0          2 |
1922. |   0          2 |
1923. |   0          1 |
1924. |   0          1 |
1925. |   0          1 |
      |----------------|
1926. |   0          1 |
1927. |   1          . |
1928. |   1          . |
1929. |   1          . |
1930. |   1          . |
      |----------------|
1931. |   1          . |
1932. |   1          . |
1933. |   0          3 |
1934. |   0          3 |
1935. |   1          4 |
      |----------------|
1936. |   1          4 |
1937. |   1          4 |
1938. |   1          4 |

Kindly help me in this regard to treat with missing value.

Regards Sattar Khan

[Fei Wang]

With the code below, DV4 will be 0 for the missings.

gen DV4= diversityinnumber>3 & diversityinnumber<.

But I think your definitions of DV1-DV4 should all be adjusted as they should be missing when diversityinnumber is missing.

gen DV1 = diversityinnumber == 1 if !mi(diversityinnumber)
gen DV2 = diversityinnumber == 2 if !mi(diversityinnumber)
gen DV3 = diversityinnumber == 3 if !mi(diversityinnumber)
gen DV4 = diversityinnumber > 3 if !mi(diversityinnumber)

[Sattar Khan]

With the code below, DV4 will be 0 for the missings.

gen DV4= diversityinnumber>3 & diversityinnumber<.

But I think your definitions of DV1-DV4 should all be adjusted as they should be missing when diversityinnumber is missing.

gen DV1 = diversityinnumber == 1 if !mi(diversityinnumber)
gen DV2 = diversityinnumber == 2 if !mi(diversityinnumber)
gen DV3 = diversityinnumber == 3 if !mi(diversityinnumber)
gen DV4 = diversityinnumber > 3 if !mi(diversityinnumber)

Thank You Wang it works

[Sattar Khan]

With the code below, DV4 will be 0 for the missings.

gen DV4= diversityinnumber>3 & diversityinnumber<.

But I think your definitions of DV1-DV4 should all be adjusted as they should be missing when diversityinnumber is missing.

gen DV1 = diversityinnumber == 1 if !mi(diversityinnumber)
gen DV2 = diversityinnumber == 2 if !mi(diversityinnumber)
gen DV3 = diversityinnumber == 3 if !mi(diversityinnumber)
gen DV4 = diversityinnumber > 3 if !mi(diversityinnumber)

Dear Wang how we can do summary statistics of each above variables such as how may companies have 3 female memebers in the board, or 2 female in the board

[William Lisowski]

The question concluding post #4 was subsequently posted in a new topic with a new title that is descriptive of the new question, which is no longer about missing values. Responses should be directed to the new topic.

https://www.statalist.org/forums/for...ive-statistics