Help using Base SAS procedures

Including Missing Values in Analyis

Reply
N/A
Posts: 0

Including Missing Values in Analyis

If I want to include missing value category in proc phreg procedure. how do I do it?
Specifically, I have 3 levels of income: 1, 2 amd 99 (unknown). How do I set 99 to missing yet include it in analysis so that I would not lose other observations?

Thanks very much! Message was edited by: natasha85
Trusted Advisor
Posts: 2,113

Re: Including Missing Values in Analyis

Rather sounds like you want to treat it as missing some times and not others. That calls for multiple variables.

There are a several approaches to attack the problem. 1) and 2) model the effect of missing explicitly and are reasonable when there is moderate missing data so the model has enough power. It is particularly valuable if the missingness is not at random. 3) applies different principles and is much more useful when the presence of missing is more of a nuisance.

1) Leave it as 3 levels and treat it as a class variable.
2) Equivalently, and I find this to be more interpretable.
-- create a new variable IncomeMiss that is coded 0/1, with the 1 as missing and 0 otherwise.
-- recode income to 0/1 with the level of interest being the 1, and 0 otherwise.
-- put both variables in the model as continuous.
Then the effect of Income level 1 is measured by the coefficient for income and the effect of missing income is captured in the other variable.
3) Apply PROC MI and MIANALYZE.

Doc Muhlbaier
Duke
Valued Guide
Posts: 632

Re: Including Missing Values in Analyis

If income is a classification variable, you can specify the MISSING option on the CLASS statement. Missing levels of the classification variable will be included in the analysis.
N/A
Posts: 0

Re: Including Missing Values in Analyis

Thank you all!
Ask a Question
Discussion stats
  • 3 replies
  • 303 views
  • 0 likes
  • 3 in conversation