I have a problem regarding an Excel file that has missing values that are indicated with an asterisk (*).
If I use search and replace in Excel, Excel thinks that there are asterisks (*) in all the cells. So, this is not the way to get rid of the asterisks (*). When I import the Excel file in Stata, Stata thinks that this variable is string. But it is not possible to destring the variable, because of the asterisk (*). I tried to encode the variable, and then the data becomes 'blue'. The asterisks (*) remain in the data. Stata knows the values (like mean, etc.), but cannot recognize the missing values.
Can somebody help me with the missing values that are indicated with an asterisk (*) ? How can I get rid of these asterisks (*) such that Stata knows that these asterisks (*) are missing values?
Thanks in advance.
Related Posts with Replace missing values that are indicated with an asterisk (*)
Expand spell data into a panel with specific reoccuring observation datesDear Statalisters, I have an administrative dataset that is updated on the 1st and 15th day of ever…
Combining two parents education variables to one variable for bothDear Stataforumists, I am currently having some trouble combining two variables into one. The reaso…
SUR vs GMM, 3SLS vs GMMHello, I'm trying to understand how GMM works and noticed that GMM produces the same estimates as O…
Count max of events in any 3 year period, in set of 20 years of data?!?Hi there, I have to see the maximum of deals a company has completed within any three- year period …
difference in difference in stataI'm doing a Diff in Diff and I'm first making a graph I put in the following command: twoway (line s…
Subscribe to:
Post Comments (Atom)
0 Response to Replace missing values that are indicated with an asterisk (*)
Post a Comment