topic Nonmissing values in SAS Programming https://communities.sas.com/t5/SAS-Programming/Nonmissing-values/m-p/128260#M26210 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a question. Please help as soon as possible. </P><P> Suppose i have a dataset Which having variables like V, V1. V2, V3,V4,V5.V6,V7 and so on in order. I want to create a new Variable in such a way that if V is not missing then New varible will have the value of V. If V is missing then&nbsp; New varible will have the value of V1. If V and V1 are both missing then New varible will have the value of V2. If V, V1 and V2 are missing then New varible will have the value of V3&nbsp; and so on.</P><P>Can any one suggest , How should we proceed.</P><P></P><P>Thanks in Advance.</P></BODY></HTML> Wed, 30 Oct 2013 06:18:44 GMT nandanosho 2013-10-30T06:18:44Z Nonmissing values https://communities.sas.com/t5/SAS-Programming/Nonmissing-values/m-p/128260#M26210 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a question. Please help as soon as possible. </P><P> Suppose i have a dataset Which having variables like V, V1. V2, V3,V4,V5.V6,V7 and so on in order. I want to create a new Variable in such a way that if V is not missing then New varible will have the value of V. If V is missing then&nbsp; New varible will have the value of V1. If V and V1 are both missing then New varible will have the value of V2. If V, V1 and V2 are missing then New varible will have the value of V3&nbsp; and so on.</P><P>Can any one suggest , How should we proceed.</P><P></P><P>Thanks in Advance.</P></BODY></HTML> Wed, 30 Oct 2013 06:18:44 GMT https://communities.sas.com/t5/SAS-Programming/Nonmissing-values/m-p/128260#M26210 nandanosho 2013-10-30T06:18:44Z Re: Nonmissing values https://communities.sas.com/t5/SAS-Programming/Nonmissing-values/m-p/128261#M26211 <HTML><HEAD></HEAD><BODY><P>try coalesce function</P><P></P><P>new=coalesce(V,V1, V2, V3,V4,V5,V6,V7);</P><P></P><P>thanks,</P><P>jagadish</P></BODY></HTML> Wed, 30 Oct 2013 06:27:05 GMT https://communities.sas.com/t5/SAS-Programming/Nonmissing-values/m-p/128261#M26211 Jagadishkatam 2013-10-30T06:27:05Z Re: Nonmissing values https://communities.sas.com/t5/SAS-Programming/Nonmissing-values/m-p/128262#M26212 <HTML><HEAD></HEAD><BODY><P>Thanks. It works</P></BODY></HTML> Wed, 30 Oct 2013 09:19:07 GMT https://communities.sas.com/t5/SAS-Programming/Nonmissing-values/m-p/128262#M26212 nandanosho 2013-10-30T09:19:07Z