https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440257#M109942 <P>It would help if you named your variables from the beginning to account for this need.</P> <PRE><CODE class=" language-sas">if n(of fruit_:) &gt; 0 then flag='yes';</CODE></PRE> Mon, 26 Feb 2018 17:13:14 GMT Tom 2018-02-26T17:13:14Z https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440230#M109931 <P>Dear all,</P><P>&nbsp;</P><P>I have many categories of variables and each of category include a lot of variables. I would like to create a statement that for each individual observation,&nbsp; if there is at least one variable has non missing value, then we can use this observation. Now I only know the statement like below:</P><P>if apple ne . or banana ne . or&nbsp; grape ne. then flag='yes';&nbsp;</P><P>However, since I have tons of variables in each category, it will be very time consuming to type them individually. I'm wondering if there is an efficient way to do it.</P><P>&nbsp;</P><P>I appreciate any thoughts and recommendations.</P><P>Thank you!</P> Mon, 26 Feb 2018 16:29:58 GMT https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440230#M109931 huhuhu 2018-02-26T16:29:58Z https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440237#M109934 <P>Use the N function to count the number of non missing values.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">If n(of var1-var3) &gt;=1 then do;</CODE></PRE> Mon, 26 Feb 2018 16:25:01 GMT https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440237#M109934 Reeza 2018-02-26T16:25:01Z https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440241#M109936 <P>Thank you for your recommendation! but they are not consecutive variables. They locate at random place in a large dataset.</P> Mon, 26 Feb 2018 16:28:56 GMT https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440241#M109936 huhuhu 2018-02-26T16:28:56Z https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440253#M109941 <P>If the variables you are concerned about are all numeric, you could use:</P> <P>&nbsp;</P> <P>if n(of _numeric_) &gt; 0 then do;</P> Mon, 26 Feb 2018 16:55:52 GMT https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440253#M109941 Astounding 2018-02-26T16:55:52Z https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440257#M109942 <P>It would help if you named your variables from the beginning to account for this need.</P> <PRE><CODE class=" language-sas">if n(of fruit_:) &gt; 0 then flag='yes';</CODE></PRE> Mon, 26 Feb 2018 17:13:14 GMT https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440257#M109942 Tom 2018-02-26T17:13:14Z https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440262#M109945 <P>If you don't have a naming convention or they're not placed sequentially then unfortunately you're stuck listing them all out.&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/79834">@huhuhu</a> wrote:<BR /> <P>Thank you for your recommendation! but they are not consecutive variables. They locate at random place in a large dataset.</P> <HR /></BLOCKQUOTE> <P><BR /><BR /></P> Mon, 26 Feb 2018 17:23:10 GMT https://communities.sas.com/t5/SAS-Programming/How-to-refer-a-long-list-of-variables-instead-of-typing/m-p/440262#M109945 Reeza 2018-02-26T17:23:10Z