topic Re: need help in calculating percentage in SAS Health and Life Sciences https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/need-help-in-calculating-percentage/m-p/180212#M1961 <HTML><HEAD></HEAD><BODY><P>hear N is count of the subjcts (pt) ...i done the answer by using retain statement ...thank you ballardw and linusH for quick respose</P></BODY></HTML> Fri, 21 Feb 2014 04:42:33 GMT javvadi 2014-02-21T04:42:33Z need help in calculating percentage https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/need-help-in-calculating-percentage/m-p/180209#M1958 <HTML><HEAD></HEAD><BODY><P>dear friends </P><P>i have dataset and i need to calculate the percentages ....</P><P></P><P>Pt Aebodsys aedecod</P><P>1 Soc1&nbsp;&nbsp; pt1</P><P>1 soc1 pt1</P><P>1 soc2 pt1</P><P>2 soc1 pt1</P><P>2 soc1 pt2</P><P>I have a dataset like this and I want to create percentage like this..</P><P></P><P>Denominator is aebodsys count-group </P><P></P><P>Nominator is aedecod count-subgroup</P><P></P><P>Aebodsys aedecod n percent</P><P>Soc1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/2=100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pt1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/2=100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pt2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ½=50</P><P>Soc2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1=100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pt1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1=100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>thank you</P></BODY></HTML> Thu, 20 Feb 2014 10:58:52 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/need-help-in-calculating-percentage/m-p/180209#M1958 javvadi 2014-02-20T10:58:52Z Re: need help in calculating percentage https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/need-help-in-calculating-percentage/m-p/180210#M1959 <HTML><HEAD></HEAD><BODY><P>PROC FREQ?</P></BODY></HTML> Thu, 20 Feb 2014 11:34:45 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/need-help-in-calculating-percentage/m-p/180210#M1959 LinusH 2014-02-20T11:34:45Z Re: need help in calculating percentage https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/need-help-in-calculating-percentage/m-p/180211#M1960 <HTML><HEAD></HEAD><BODY><P>What does this line represent?</P><P>Soc1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/2=100</P><P></P><P>Your example data has 4 records with Soc1, so how does it get an n of 2? and what is the denominator? I think you might want to provide a few more example records as 2 is showing in so many places we can't tell where the 2 is coming from.</P></BODY></HTML> Thu, 20 Feb 2014 16:52:08 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/need-help-in-calculating-percentage/m-p/180211#M1960 ballardw 2014-02-20T16:52:08Z Re: need help in calculating percentage https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/need-help-in-calculating-percentage/m-p/180212#M1961 <HTML><HEAD></HEAD><BODY><P>hear N is count of the subjcts (pt) ...i done the answer by using retain statement ...thank you ballardw and linusH for quick respose</P></BODY></HTML> Fri, 21 Feb 2014 04:42:33 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/need-help-in-calculating-percentage/m-p/180212#M1961 javvadi 2014-02-21T04:42:33Z