topic Re: cumulative percent in SAS Procedures

topic Re: cumulative percent in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216373#M53249 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">data want;</SPAN></P><P>set have nobs=_nobs_;</P><P>cumulative_percent=_n_/_nobs_;</P><P>format cumulative_percent percent6.0;</P><P>run;</P></BODY></HTML> Sun, 05 Apr 2015 01:21:22 GMT stat_sas 2015-04-05T01:21:22Z cumulative percent https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216368#M53244 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I have a dataset in which i'd like to create a variable which represents cumulative percent of observations. Can you please let me know whether this is possible?</P><P></P><P>For example:</P><P>Obs Company Sales Cumulative_Percent</P><P>1      Abc          350                   0.33</P><P>2      xyz           500                   0.66</P><P>3      sdt            450                   1.00</P></BODY></HTML> Sat, 04 Apr 2015 23:35:39 GMT https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216368#M53244 qsilver23 2015-04-04T23:35:39Z Re: cumulative percent https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216369#M53245 <HTML><HEAD></HEAD><BODY><P>Possible in a variety of ways, one of the simplest is PROC FREQ</P><P></P><P>proc freq data=have;</P><P>table company/out=want outcum;</P><P>weight sales;</P><P>run;</P><P></P><P>proc print data=have;</P><P>run;</P></BODY></HTML> Sat, 04 Apr 2015 23:47:05 GMT https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216369#M53245 Reeza 2015-04-04T23:47:05Z Re: cumulative percent https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216370#M53246 <HTML><HEAD></HEAD><BODY><P>Hi, investigate PROC FREQ. It can give you Frequency Counts, Cum Frequency, Percent and Cum Percent. In addition, if you want it (and you are running SAS 9.3 or higher), you can get automatic graphs from PROC FREQ, too. You should be able to test this code, since SASHELP.SHOES is generally available on all installations of SAS.<BR />  </P><P>Cynthia<BR />           </P><P><SPAN style="font-family: courier new,courier;"><STRONG>ods graphics on;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>proc freq data=sashelp.shoes;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  title '1) taking all defaults';</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  tables region;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>run;</STRONG></SPAN></P><P>  </P><P><SPAN style="font-family: courier new,courier;"><STRONG>proc freq data=sashelp.shoes;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  title '2) adding plots';</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  tables region / plots=all;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>run;</STRONG></SPAN></P><P>  </P><P><SPAN style="font-family: courier new,courier;"><STRONG>proc freq data=sashelp.shoes;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  title '3) adding nocum';</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  tables region / nocum;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>run;</STRONG></SPAN></P><P></P><P><SPAN style="font-family: courier new,courier;"><STRONG>proc freq data=sashelp.shoes;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  title '4) using nopercent';</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  tables region / nopercent;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>run;</STRONG></SPAN></P><P>    </P><P><SPAN style="font-family: courier new,courier;"><STRONG>ods output onewayfreqs=work.outfrq;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>proc freq data=sashelp.shoes;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  title '5) making dataset -- output same as #1';</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  tables region ;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>run;</STRONG></SPAN></P><P>  </P><P><SPAN style="font-family: courier new,courier;"><STRONG>proc print data=work.outfrq noobs;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  title '6) print only desired variables';</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>  var region frequency cumpercent;</STRONG></SPAN></P><P><SPAN style="font-family: courier new,courier;"><STRONG>run;</STRONG></SPAN></P></BODY></HTML> Sat, 04 Apr 2015 23:52:36 GMT https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216370#M53246 Cynthia_sas 2015-04-04T23:52:36Z Re: cumulative percent https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216371#M53247 <HTML><HEAD></HEAD><BODY><P>Thanks Reeza. Will this be based on observation (row) or sales? Hoping to leverage your example on observation.</P></BODY></HTML> Sun, 05 Apr 2015 00:19:18 GMT https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216371#M53247 qsilver23 2015-04-05T00:19:18Z Re: cumulative percent https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216372#M53248 <HTML><HEAD></HEAD><BODY><P>Thanks Reeza. Will this calc the cumulative percent by observation (row)? just want to make sure it's not based on sales. For example, if there are 3 rows, each row will be divided by 3. 1/3, 2/3, 3/3. </P></BODY></HTML> Sun, 05 Apr 2015 00:28:06 GMT https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216372#M53248 qsilver23 2015-04-05T00:28:06Z Re: cumulative percent https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216373#M53249 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">data want;</SPAN></P><P>set have nobs=_nobs_;</P><P>cumulative_percent=_n_/_nobs_;</P><P>format cumulative_percent percent6.0;</P><P>run;</P></BODY></HTML> Sun, 05 Apr 2015 01:21:22 GMT https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216373#M53249 stat_sas 2015-04-05T01:21:22Z Re: cumulative percent https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216374#M53250 <HTML><HEAD></HEAD><BODY><P>Amazing!! Thank you so much. I really appreciate the prompt solution.</P></BODY></HTML> Sun, 05 Apr 2015 01:32:28 GMT https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216374#M53250 qsilver23 2015-04-05T01:32:28Z Re: cumulative percent https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216375#M53251 <HTML><HEAD></HEAD><BODY><P>No, I misread your question. If you only have each company listed once you could remove the WEIGHT statement and it would calculate the row percent for you.</P></BODY></HTML> Sun, 05 Apr 2015 23:29:23 GMT https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/m-p/216375#M53251 Reeza 2015-04-05T23:29:23Z