topic Re: counting number of firms and missing values in SAS Programming https://communities.sas.com/t5/SAS-Programming/counting-number-of-firms-and-missing-values/m-p/118204#M293210 <HTML><HEAD></HEAD><BODY><P>PROC FREQ and PROC UNIVARIATE are two very useful procedures when it comes to data exploration.</P></BODY></HTML> Mon, 21 Oct 2013 04:31:35 GMT Patrick 2013-10-21T04:31:35Z counting number of firms and missing values https://communities.sas.com/t5/SAS-Programming/counting-number-of-firms-and-missing-values/m-p/118202#M293208 <HTML><HEAD></HEAD><BODY><P>Hi I am trying to get a feel for my data and the number of unique observations</P><P></P><P>I am wanting to</P><OL><LI>count the number of firms (the variable is called cusip).</LI><LI>count the number of firm names (the variable is called firms)</LI></OL><P></P><P>Any help is appreciated</P></BODY></HTML> Mon, 21 Oct 2013 04:06:16 GMT https://communities.sas.com/t5/SAS-Programming/counting-number-of-firms-and-missing-values/m-p/118202#M293208 wschnell1 2013-10-21T04:06:16Z Re: counting number of firms and missing values https://communities.sas.com/t5/SAS-Programming/counting-number-of-firms-and-missing-values/m-p/118203#M293209 <HTML><HEAD></HEAD><BODY><P>Please try,</P><P></P><P>proc sql;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; select count(distinct cusip) as count_cusip, count(distinct firms) as count_firms from data;</P><P>quit;</P><P></P><P>Thanks,</P><P>jagadish</P></BODY></HTML> Mon, 21 Oct 2013 04:26:01 GMT https://communities.sas.com/t5/SAS-Programming/counting-number-of-firms-and-missing-values/m-p/118203#M293209 Jagadishkatam 2013-10-21T04:26:01Z Re: counting number of firms and missing values https://communities.sas.com/t5/SAS-Programming/counting-number-of-firms-and-missing-values/m-p/118204#M293210 <HTML><HEAD></HEAD><BODY><P>PROC FREQ and PROC UNIVARIATE are two very useful procedures when it comes to data exploration.</P></BODY></HTML> Mon, 21 Oct 2013 04:31:35 GMT https://communities.sas.com/t5/SAS-Programming/counting-number-of-firms-and-missing-values/m-p/118204#M293210 Patrick 2013-10-21T04:31:35Z