I have a file. Columns of each student's ID card, city of residence, educational institution, column on whether or not he dropped out of school. If we drop then a column gets 1 if we don't drop then a column gets zero. For example I want to prepare a table with a calculation of how many students there are in each group of cities by type of institution. How many students dropped out by city and type of institution. And what is the percentage of dropouts by city and type of institution. I want to prepare the table using SAS with the TABULATE function Example of results The goal is to calculate the number and percentage of dropouts without also showing the non-dropouts. That is, not to show the complements. I was able to calculate the amounts but not percentages. This is what I tried: 1. proc tabulate data=a missing; class City Educational_Institution ; var Dropped_Out; table City* Educational_Institution, n*Dropped_Out Dropped_Out*sum Dropped_Out*pctn<n> ; run; 2. proc tabulate data=a missing; class City Educational_Institution ; var Dropped_Out; table City* Educational_Institution, n*Dropped_Out Dropped_Out*sum Dropped_Out*pctn<Dropped_Out> ; run; The highlighted part does not work. I also tried all kinds of options with PCTSUM. What am I missing? I would appreciate help. Thanks
... View more
