Dear all,
I have a very big panel dataset in a long format. I used the list command quiet often to- among other things- sample a portion of my data so I can better understand it and/or because I need to print it for future references. The problems comes when I include the if statement in my list command. For example if I want to list 10 observation of ID=100- because ID=100 has thousand of rows, the list command may not return any observation.
. This may be the case because the observation = ID 100 may not be in the first 10 observations of my dataset. Is there a way to use the "in 1/10" option but only for the observation I want, for example if ID==100, return the fist 10 observations?
Also a common data cleaning procedure I do is to check for missing values. However, missing values can be system missing for numeric variables (.) or empty spaces for string "" , " " etc.I use the tabmiss command to check for missing values but this command is not sensitive to string missing. Is there a way to check for all king of missing values at once- numeric string (blank spaces)?
I have a very big panel dataset in a long format. I used the list command quiet often to- among other things- sample a portion of my data so I can better understand it and/or because I need to print it for future references. The problems comes when I include the if statement in my list command. For example if I want to list 10 observation of ID=100- because ID=100 has thousand of rows, the list command may not return any observation.
Code:
list ID in 1/10 if ID==100
Also a common data cleaning procedure I do is to check for missing values. However, missing values can be system missing for numeric variables (.) or empty spaces for string "" , " " etc.I use the tabmiss command to check for missing values but this command is not sensitive to string missing. Is there a way to check for all king of missing values at once- numeric string (blank spaces)?
Comment