Hello
I have a question regarding 0 (=zero) vs missing data.
If I have an observation that have many variables but one of the variable is not relevant to this observation (but relevant to other observations), should the value of this variable be 0 (=zero) or missing data (as I found there is a big difference between them in correlation matrix
Thanks a lot for any help!
If this is proportion on family directors it should be zero.
Note that SAS excludes records with missing values so you need a 0. I'm assuming you have another variable that indicates if the firm is a family firm.
Missing typically referers to an unknown or unobserved value where 0 refers to a value that is observed to be 0.
Also, is it categorical or continuous?
Given what information you've provided it's difficult to make a suggestion.
Please provide more background information regarding your data.
Dear @Reeza
Thanks a lot for your fast reply,
The varibale is FD ehich equal to family directors/total directors, this variable is continous.
For the observations that relate to family firms, this variable has any value. But, my data also has observations which are non-family firms. I wonder if under this variable it should be zero or missing value?
If this is proportion on family directors it should be zero.
Note that SAS excludes records with missing values so you need a 0. I'm assuming you have another variable that indicates if the firm is a family firm.
Thanks a lot, it really helps me 🙂
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.