Hello, Please I need some help with data manipulation. I have clean up the data up to this point. Now, I want to create a frequency and percentages for each serv by table. The active and reserve is the count of boy in 2796 table who are active or reserve. i want to find the percentage of these count to create a table below For example: I want the (%) for Boy in PHA(table) who are Active, (%) for Boy in 2796 who are active and so on. Just like my desired table below. I think I need numerator & denominator but am not sure. Am think to get the percentage for Boy in PHA who are active, my numerator is 41043/706476 (total PHA). I don't know how to code this in SAS. Any help is highly appreciated ddata test; length serv $5 table $5 ; infile datalines dlm=',' dsd; input serv $ table $ Active Reserve ; datalines; Boy,2796,41043,7024 Boy,PHA,274220,95291 Girl,2796,3200,1231 Girl,PHA,121634,36043 Dad,2796,9915,310 TOTAL,2796,77283,11371 TOTAL,PHA,706476,195988 ; run; desired output Serv Table Active Reserve N % N % Boy PHA 274220 ? 95291 ? 2796 41043 ? 7024 ? Girl PHA 2796 Dad PHA 2796 TOTAL PHA 706476 100 195988 100 2796 77283 100 11371 100
... View more