https://communities.sas.com/t5/SAS-Programming/Matrix-for-summation-of-different-variables/m-p/864770#M341479 Period unique id. Flag<BR />201208. 1. Open<BR />201208. 2. Closed<BR />201209. 3. Closed<BR />201210. 4 Default<BR />201211. 5. Open<BR /><BR /><BR />Need results like ( number of account)<BR />Period. Open. Closed. Default<BR />201208. 1. 1 0<BR />Similarly for other dates<BR /><BR /><BR /><BR /><BR /> Fri, 17 Mar 2023 09:55:40 GMT Madhav4114 2023-03-17T09:55:40Z https://communities.sas.com/t5/SAS-Programming/Matrix-for-summation-of-different-variables/m-p/864770#M341479 Period unique id. Flag<BR />201208. 1. Open<BR />201208. 2. Closed<BR />201209. 3. Closed<BR />201210. 4 Default<BR />201211. 5. Open<BR /><BR /><BR />Need results like ( number of account)<BR />Period. Open. Closed. Default<BR />201208. 1. 1 0<BR />Similarly for other dates<BR /><BR /><BR /><BR /><BR /> Fri, 17 Mar 2023 09:55:40 GMT https://communities.sas.com/t5/SAS-Programming/Matrix-for-summation-of-different-variables/m-p/864770#M341479 Madhav4114 2023-03-17T09:55:40Z https://communities.sas.com/t5/SAS-Programming/Matrix-for-summation-of-different-variables/m-p/864778#M341482 <PRE><CODE class=" language-sas">proc freq data=have; tables period*flag; run;</CODE></PRE> Fri, 17 Mar 2023 10:12:56 GMT https://communities.sas.com/t5/SAS-Programming/Matrix-for-summation-of-different-variables/m-p/864778#M341482 PaigeMiller 2023-03-17T10:12:56Z https://communities.sas.com/t5/SAS-Programming/Matrix-for-summation-of-different-variables/m-p/864876#M341524 <P>May want the options /nocum nopct norow nocol on the tables statement.</P> <P>&nbsp;</P> <P>Or move to another proc like Tabulate or Report that have more control/flexibility for display.</P> Fri, 17 Mar 2023 15:17:26 GMT https://communities.sas.com/t5/SAS-Programming/Matrix-for-summation-of-different-variables/m-p/864876#M341524 ballardw 2023-03-17T15:17:26Z