Missing data

[Chinyelu Patrick]

Please am new to the use of Stata, please what command should I use to view missing values in a arge dataset

[Wei Hai Deng]

Depends on what your goal is but if it is just to explore your data and output your missing data pattern then try

help misstable
misstable summarize var1 var2 var3, all
misstable patterns var1 var2 var3

otherwise also try

help tab1
tab1, missing

Best,
Wei

[Chinyelu Patrick]

Thank you so much for your response. I have a dataset that contains 274 variables and 61 observations.

[Chinyelu Patrick]

Thank you so much for your response. I have a dataset that contains 274 variables and 2500 observations. I want to find entries or data that were not entered

[Wei Hai Deng]

Did the above code answer your question?
What I mean is, what do you plan to do with the information afterwards? Are you imputing missings, summarizing missing patterns, do you need to export the results in a table, etc.

[Chinyelu Patrick]

Thank you Wei for your response I appreciate it. I did use the code - misstable summarize variables name - it worked for some and did not work for some variables. I am monitoring a database, where fieldworkers are doing surveys using tablets and as the data is input, it goes into the database. So I am supposed to monitor the data and find out if there are missing information so I can ask the fieldworker to fill in the data so that we don't have missing data.

[Wei Hai Deng]

Personally, this sounds like a task that should be automated with some Python, alternatively https://redash.io/ which is open source and gives you visual reports. Have it detect missings and send out emails to relevant people automatically.

But back to your Stata question.

it worked for some and did not work for some variables.

What do you mean? Are you missing variables, got an error (what is it?), are the numbers wrong... Please provide full details on what you are seeing and asking about. It is hard to help when I don't know what the issue is. I recommend you give full details on what your data looks like and what you would like to do.

ssc install dataex

Can help to produce an example dataset based on your data for posting here on Statalist.

misstable only reports numeric variables that contain missing information. variables with no missings or are string are not reported.
Maybe you're looking for something like:

ssc install mdesc