Posted By

sarathannapareddy on 03/31/09


Tagged

loop arrays missing in where values do dataset proc sas FREQ statemnt


Versions (?)

How to detect missing values using Arrays


 / Published in: SAS
 

URL: http://studysas.blogspot.com/2008/11/how-to-detect-missing-values-using.html

Direct link: http://ssc.utexas.edu/consulting/answers/sas/sas65.html

  1. Question:
  2. How do I exclude observations from my PROC FREQ analysis when a value is missing from a list of variables?
  3.  
  4. Answer:
  5. In the SAS DATA step, you can create a new variable ("miss" in the example below) that is set equal to 1 when a variable has a missing value, 0 otherwise. Use the ARRAY statement and a DO loop to check for missing values across a list of variables; the syntax is:
  6.  
  7. read more at...
  8.  
  9. http://studysas.blogspot.com/2008/11/how-to-detect-missing-values-using.html

Report this snippet  

You need to login to post a comment.