Programming the statistical procedures from SAS

Zero Vs missing values

Accepted Solution Solved
Reply
Contributor
Posts: 69
Accepted Solution

Zero Vs missing values

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!


Accepted Solutions
Solution
‎08-28-2016 10:50 AM
Super User
Posts: 18,568

Re: Zero Vs missing values

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. 

View solution in original post


All Replies
Super User
Posts: 18,568

Re: Zero Vs missing values

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.

 

 

Contributor
Posts: 69

Re: Zero Vs missing values

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?

Solution
‎08-28-2016 10:50 AM
Super User
Posts: 18,568

Re: Zero Vs missing values

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. 

Contributor
Posts: 69

Re: Zero Vs missing values

Thanks a lot, it really helps me :-)

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 255 views
  • 1 like
  • 2 in conversation