https://communities.sas.com/t5/SAS-Programming/Function-for-picking-out-the-variable-that-s-not-missing/m-p/389190#M277504 <P>COALESCE()</P> Fri, 18 Aug 2017 18:35:36 GMT Reeza 2017-08-18T18:35:36Z https://communities.sas.com/t5/SAS-Programming/Function-for-picking-out-the-variable-that-s-not-missing/m-p/389187#M277503 <P>Dear all,</P><P>&nbsp;</P><P>I have a dataset that have 5 date variables and only 1 date variable has value (example: date1=. date2=. date3=5/30/17 date4=. date5=.)</P><P>I want to create a new variable called datefinal that returns the date value of the variable that's not missing (so it would return 5/30/17 in the example).</P><P>Is there a SAS function for this? or do I have to use an array to do this?</P><P>Thank you!</P> Fri, 18 Aug 2017 18:32:33 GMT https://communities.sas.com/t5/SAS-Programming/Function-for-picking-out-the-variable-that-s-not-missing/m-p/389187#M277503 michan22 2017-08-18T18:32:33Z https://communities.sas.com/t5/SAS-Programming/Function-for-picking-out-the-variable-that-s-not-missing/m-p/389190#M277504 <P>COALESCE()</P> Fri, 18 Aug 2017 18:35:36 GMT https://communities.sas.com/t5/SAS-Programming/Function-for-picking-out-the-variable-that-s-not-missing/m-p/389190#M277504 Reeza 2017-08-18T18:35:36Z https://communities.sas.com/t5/SAS-Programming/Function-for-picking-out-the-variable-that-s-not-missing/m-p/389200#M277505 <P>Thank you!</P> Fri, 18 Aug 2017 18:58:50 GMT https://communities.sas.com/t5/SAS-Programming/Function-for-picking-out-the-variable-that-s-not-missing/m-p/389200#M277505 michan22 2017-08-18T18:58:50Z