topic Re: Arrays in SAS Studio https://communities.sas.com/t5/SAS-Studio/Arrays/m-p/364333#M2672 <P>the output&nbsp; the am looking is,&nbsp; a&nbsp; 7th varable " No_of_Miss"&nbsp; that contain the number of missing values(number of "NA") of each raws. Like...&nbsp; Number of "NA" in the 1st raw&nbsp; as the 1st&nbsp; observation of "No_of_Miss",&nbsp; number of "NA" in the 2nd raw as the second obsercation on"No_Of_Miss"....etc</P> Mon, 05 Jun 2017 19:06:32 GMT NVN 2017-06-05T19:06:32Z Arrays https://communities.sas.com/t5/SAS-Studio/Arrays/m-p/364156#M2659 <P>Please help we with this problem &nbsp;to &nbsp;count the missing values across raw with &nbsp;two diamensional array.</P><P>&nbsp;</P><P>Dataset name : Subset.csv. The following is the data set.</P><P>&nbsp;</P><P>&nbsp; &nbsp; &nbsp;i_Day5 &nbsp; &nbsp; Day6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Day7 &nbsp; &nbsp; City1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;City2 &nbsp; &nbsp; City3</P><P>1 &nbsp; Friday &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Delhi &nbsp; &nbsp; NA</P><P>2 &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN>NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp;Mumbai</SPAN></P><P>3 &nbsp; Friday &nbsp; &nbsp; &nbsp;<SPAN>NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp;NA</SPAN></P><P>4 &nbsp;&nbsp;<SPAN>Friday &nbsp; &nbsp;&nbsp;Saturday &nbsp; &nbsp; Na &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bangalore &nbsp; Delhi &nbsp; &nbsp; &nbsp;NA</SPAN></P><P>5 &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; NA</P><P>6 &nbsp; &nbsp;<SPAN>Friday &nbsp; &nbsp; Saturday &nbsp; &nbsp;Sunday &nbsp; &nbsp;Bangalore &nbsp; Delhi &nbsp; &nbsp; NA</SPAN></P><P>7 &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN>NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Delhi &nbsp; &nbsp; NA</SPAN></P><P>8 &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp;NA</P><P>9 &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NA &nbsp; &nbsp; &nbsp; &nbsp;NA</P><P>10 &nbsp;&nbsp;<SPAN>Friday &nbsp; &nbsp; Saturday &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA &nbsp; &nbsp; &nbsp; NA</SPAN></P><P>&nbsp;</P><P>&nbsp;</P> Sun, 04 Jun 2017 20:46:09 GMT https://communities.sas.com/t5/SAS-Studio/Arrays/m-p/364156#M2659 NVN 2017-06-04T20:46:09Z Re: Arrays https://communities.sas.com/t5/SAS-Studio/Arrays/m-p/364282#M2668 <P>And what do you expect the output to look like?</P> <P>&nbsp;</P> <P>Note that to use values of variables "across" rows outside of IML is going to involve some work.</P> <P>&nbsp;</P> <P>And 'NA' is not 'missing' as used by SAS. So it looks like your question may be the "the number of NA values".</P> Mon, 05 Jun 2017 14:42:27 GMT https://communities.sas.com/t5/SAS-Studio/Arrays/m-p/364282#M2668 ballardw 2017-06-05T14:42:27Z Re: Arrays https://communities.sas.com/t5/SAS-Studio/Arrays/m-p/364333#M2672 <P>the output&nbsp; the am looking is,&nbsp; a&nbsp; 7th varable " No_of_Miss"&nbsp; that contain the number of missing values(number of "NA") of each raws. Like...&nbsp; Number of "NA" in the 1st raw&nbsp; as the 1st&nbsp; observation of "No_of_Miss",&nbsp; number of "NA" in the 2nd raw as the second obsercation on"No_Of_Miss"....etc</P> Mon, 05 Jun 2017 19:06:32 GMT https://communities.sas.com/t5/SAS-Studio/Arrays/m-p/364333#M2672 NVN 2017-06-05T19:06:32Z