How to display the percentage of different race in a panel

[Lama Hammad]

Hello,

I have this data set. I want to show summary statistics of race variables. (e.g. % black patients, % white patients, % Hispanic patients) but not cross-tabs


[CODE]
* Example generated by -dataex-. For more info, type help dataex
clear
input long prscrbr_npi str44 prscrbr_last_org_name long(bene_race_wht_cnt bene_race_black_cnt bene_race_api_cnt bene_race_hspnc_cnt) int bene_race_natind_cnt float(tot_pop_race1 Black_benes1 hspnc_benes1 white_benes1 percentage)
1932299161 "Ramey" 427 8 0 0 5 440 .01814059 0 .968254 .9863946
1457431231 "Villanueva Valdes" 0 0 0 355 0 355 0 1 0 1
1457431231 "Villanueva Valdes" 0 0 0 175 0 175 0 1 0 1
1457431231 "Villanueva Valdes" 1 1 1 9 0 11 .0909091 .8181818 .0909091 1
1457431231 "Villanueva Valdes" 0 0 0 175 0 175 0 1 0 1
1669551479 "Perez-Soto" 8 3 0 358 0 369 .008130081 .9701897 .02168022 1
1669551479 "Perez-Soto" 7 10 0 661 0 678 .014749262 .9749262 .010324484 1
1669551479 "Perez-Soto" 2 8 0 358 0 368 .02173913 .9728261 .005434783 1
1669551479 "Perez-Soto" 7 6 0 661 0 674 .008902078 .9807122 .010385756 1
1669551479 "Perez-Soto" 8 2 0 661 0 671 .002980626 .9850969 .011922504 1
1376504993 "Sepulveda-Pagan" 5 1 1 3 0 9 .11111111 .3333333 .5555556 1
1942206032 "Perez Valentin" 4 3 0 236 0 243 .01234568 .9711934 .016460905 1
1982649539 "Declet Manzanet" 0 0 0 358 0 358 0 1 0 1
1376504993 "Sepulveda-Pagan" 4 5 0 74 0 83 .06024097 .8915663 .04819277 1
1336125608 "Torres Pagan" 0 0 0 331 0 331 0 1 0 1
1982649539 "Declet Manzanet" 10 1 1 7 0 18 .05555556 .3888889 .5555556 1
1215950985 "Ruiz Diaz" 0 0 0 721 0 721 0 1 0 1
1942206032 "Perez Valentin" 7 1 1 4 0 12 .08333334 .3333333 .5833333 1
1215950985 "Ruiz Diaz" 0 0 0 767 0 767 0 1 0 1
1467438804 "Cuevas" 6 10 0 303 0 319 .031347964 .9498433 .018808777 1
1942206032 "Perez Valentin" 1 3 0 233 0 237 .012658228 .9831223 .004219409 1
1215950985 "Ruiz Diaz" 0 0 0 767 0 767 0 1 0 1
1467438804 "Cuevas" 1 1 1 523 0 525 .001904762 .9961905 .001904762 1
1376609016 "Ramos Gonzalez" 4 0 0 985 0 989 0 .985986 .004004004 .98999
1942206032 "Perez Valentin" 2 4 0 233 0 239 .016736401 .9748954 .008368201 1
1336125608 "Torres Pagan" 4 1 1 7 0 12 .08333334 .5833333 .3333333 1
1215950985 "Ruiz Diaz" 1 1 1 924 0 926 .0010799136 .9978402 .0010799136 1
1336125608 "Torres Pagan" 3 4 0 322 0 329 .012158055 .9787234 .009118541 1
1336125608 "Torres Pagan" 0 0 0 331 0 331 0 1 0 1
1376504993 "Sepulveda-Pagan" 5 4 0 74 0 83 .04819277 .8915663 .06024097 1
1467438804 "Cuevas" 4 10 0 303 0 317 .03154574 .9558359 .012618297 1
1982649539 "Declet Manzanet" 0 0 0 358 0 358 0 1 0 1
1376609016 "Ramos Gonzalez" 5 1 1 2 0 8 .125 .25 .625 1
1215950985 "Ruiz Diaz" 0 0 0 721 0 721 0 1 0 1
1467438804 "Cuevas" 3 7 0 306 0 316 .0221519 .9683544 .00949367 1
1376609016 "Ramos Gonzalez" 6 0 0 985 0 991 0 .985 .006 .991
1336125608 "Torres Pagan" 2 2 0 322 0 326 .006134969 .9877301 .006134969 1
1336125608 "Torres Pagan" 6 4 0 322 0 332 .012048192 .9698795 .018072288 1
1982649539 "Declet Manzanet" 4 8 0 366 0 378 .02116402 .968254 .01058201 1
1699221515 "Mariani Ostolaza" 0 0 0 195 0 195 0 1 0 1
1215950985 "Ruiz Diaz" 0 0 0 767 0 767 0 1 0 1
1164431896 "Roman Vale" 0 0 0 286 0 286 0 1 0 1
1164431896 "Roman Vale" 0 0 0 297 0 297 0 1 0 1
1588690424 "Gonzalez" 8 8 0 1232 0 1248 .006410256 .9871795 .006410256 1
1063820355 "Alvarez" 0 0 0 87 0 87 0 1 0 1
1235187139 "Rivera" 1 1 1 1091 0 1093 .000914913 .9981702 .000914913 1
1750468955 "Ramirez" 0 0 0 379 0 379 0 1 0 1
1235187139 "Rivera" 0 0 0 66 0 66 0 1 0 1
1538233937 "Crespo" 4 3 0 166 0 173 .01734104 .9595376 .023121387 1
1538233937 "Crespo" 1 7 0 166 0 174 .04022989 .954023 .005747126 1
1528169737 "Hernandez Hernandez" 6 8 0 164 0 178 .04494382 .9213483 .033707865 1
1598759649 "Quintana-Valentin" 1 1 1 335 0 337 .002967359 .9940653 .002967359 1
1164406096 "Gonzalez Esclavon" 9 1 1 10 0 20 .05 .5 .45 1
1164461208 "Zeno Calero" 1 1 1 1 0 3 .2 .2 .2 .6
1063587574 "Soto-Villarrubia" 5 1 1 8 0 14 .071428575 .5714286 .3571429 1
1528127032 "Quinones Caraballo" 0 0 0 446 0 446 0 1 0 1
1538233937 "Crespo" 1 7 0 166 0 174 .04022989 .954023 .005747126 1
1194871277 "Muniz Molinero" 5 7 0 2225 0 2237 .003129191 .9946357 .0022351362 1
1235187139 "Rivera" 0 0 0 66 0 66 0 1 0 1
1043271430 "Varela Rosa" 1 1 1 306 0 308 .003246753 .9935065 .003246753 1
1538233937 "Crespo" 1 7 0 166 0 174 .04022989 .954023 .005747126 1
1649221607 "Machin" 0 0 0 383 0 383 0 1 0 1
1063587574 "Soto-Villarrubia" 1 1 0 342 0 344 .002906977 .994186 .002906977 1
1487791976 "Jimenez-Espinosa" 0 0 0 461 0 461 0 1 0 1
1134114846 "Sawi Hafes" 3 8 0 155 0 166 .04819277 .933735 .018072288 1
1538233937 "Crespo" 1 7 0 166 0 174 .04022989 .954023 .005747126 1
1649221607 "Machin" 0 0 0 383 0 383 0 1 0 1
1134114846 "Sawi Hafes" 7 6 0 148 0 161 .03726708 .9192547 .04347826 1
1194871277 "Muniz Molinero" 6 1 6 7 0 14 .071428575 .5 .4285714 1
1235187139 "Rivera" 0 0 0 66 0 66 0 1 0 1
1538233937 "Crespo" 9 1 1 3 0 13 .07692308 .23076923 .6923077 1
1538233937 "Crespo" 4 3 0 166 0 173 .01734104 .9595376 .023121387 1
1538233937 "Crespo" 1 7 0 166 0 174 .04022989 .954023 .005747126 1
1316141682 "Salas-Rivera" 2 8 0 101 0 111 .072072074 .9099099 .018018018 1
1184055485 "Lopez Villanueva" 3 9 0 295 0 307 .02931596 .960912 .009771987 1
1235187139 "Rivera" 1 1 1 1091 0 1093 .000914913 .9981702 .000914913 1
1750468955 "Ramirez" 0 0 0 370 0 370 0 1 0 1
1336106822 "Diaz Ruiz" 4 10 0 152 0 166 .06024097 .9156626 .024096385 1
1043277726 "Cordero" 9 5 0 313 0 327 .01529052 .9571865 .027522936 1
1588690424 "Gonzalez" 4 1 1 9 0 14 .071428575 .6428571 .2857143 1
1235187139 "Rivera" 0 0 0 66 0 66 0 1 0 1
1316141682 "Salas-Rivera" 2 8 0 101 0 111 .072072074 .9099099 .018018018 1
1487791976 "Jimenez-Espinosa" 10 1 1 8 3 22 .04545455 .3636364 .4545455 .8636364
1801885249 "Rivera Rodriguez" 5 5 0 790 0 800 .00625 .9875 .00625 1
1750468955 "Ramirez" 6 1 1 3 0 10 .1 .3 .6 1
1184055485 "Lopez Villanueva" 6 8 0 398 0 412 .019417476 .9660194 .014563107 1
1346569019 "Yulfo Ramos" 10 8 0 264 0 282 .028368793 .9361702 .035460994 1
1780667089 "Cora Santiago" 1 1 1 332 0 334 .002994012 .994012 .002994012 1
1932255353 "Quinones" 0 0 0 329 0 329 0 1 0 1
1487791976 "Jimenez-Espinosa" 0 0 0 461 0 461 0 1 0 1
1417927237 "Rivera" 0 0 0 237 0 237 0 1 0 1
1932255353 "Quinones" 0 0 0 329 0 329 0 1 0 1
1487655254 "Ramos Mendez" 0 0 0 186 0 186 0 1 0 1
1043277726 "Cordero" 1 8 0 313 0 322 .02484472 .9720497 .00310559 1
1346569019 "Yulfo Ramos" 5 8 0 264 0 277 .028880866 .9530686 .018050542 1
1528169737 "Hernandez Hernandez" 9 10 0 165 0 184 .05434782 .8967391 .04891304 1
1538233937 "Crespo" 1 7 0 166 0 174 .04022989 .954023 .005747126 1
1164431896 "Roman Vale" 0 0 0 286 0 286 0 1 0 1
1235187139 "Rivera" 0 0 0 66 0 66 0 1 0 1
1235187139 "Rivera" 0 0 0 66 0 66 0 1 0 1
end
[CODE]

[Lama Hammad]

I have a cross-table, but my advisor wants a univariate summary statistics of all the variables. I did the other variables and had no issues, but could not do it for the patients' race. I use this command

table () ( statcmd ) (), nototals statistic(percent  Black_benes1)

It gives me 100 percent. But I want to have the percentage of each race in the data set.

Any suggestion?