https://communities.sas.com/t5/New-SAS-User/Counting-by-two-variables/m-p/563901#M10952 <P>Hi all,</P><P>&nbsp;</P><P>I have data as below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="snip 1.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/30021iD7A8E37CFAE0BA1E/image-size/large?v=v2&amp;px=999" role="button" title="snip 1.PNG" alt="snip 1.PNG" /></span></P><P>&nbsp;</P><P>And want output as below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="snip 2.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/30022i6DC3F2ACE8127589/image-size/large?v=v2&amp;px=999" role="button" title="snip 2.PNG" alt="snip 2.PNG" /></span></P><P>&nbsp;</P><P>is there any simple procedure which can give results like above&nbsp; by trt01pn and cmatc4 and cmpt (Don't worry about percentages).</P><P>&nbsp;</P><P>Thanks,</P><P>Adithya</P> Wed, 05 Jun 2019 22:09:31 GMT chinna0369 2019-06-05T22:09:31Z https://communities.sas.com/t5/New-SAS-User/Counting-by-two-variables/m-p/563901#M10952 <P>Hi all,</P><P>&nbsp;</P><P>I have data as below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="snip 1.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/30021iD7A8E37CFAE0BA1E/image-size/large?v=v2&amp;px=999" role="button" title="snip 1.PNG" alt="snip 1.PNG" /></span></P><P>&nbsp;</P><P>And want output as below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="snip 2.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/30022i6DC3F2ACE8127589/image-size/large?v=v2&amp;px=999" role="button" title="snip 2.PNG" alt="snip 2.PNG" /></span></P><P>&nbsp;</P><P>is there any simple procedure which can give results like above&nbsp; by trt01pn and cmatc4 and cmpt (Don't worry about percentages).</P><P>&nbsp;</P><P>Thanks,</P><P>Adithya</P> Wed, 05 Jun 2019 22:09:31 GMT https://communities.sas.com/t5/New-SAS-User/Counting-by-two-variables/m-p/563901#M10952 chinna0369 2019-06-05T22:09:31Z https://communities.sas.com/t5/New-SAS-User/Counting-by-two-variables/m-p/563907#M10953 PROC TABULATE would come pretty close or PROC FREQ. Both can can calculate the percents but will not place them in the same 'column'.<BR /> Wed, 05 Jun 2019 22:22:46 GMT https://communities.sas.com/t5/New-SAS-User/Counting-by-two-variables/m-p/563907#M10953 Reeza 2019-06-05T22:22:46Z