https://communities.sas.com/t5/SAS-Programming/Convert-data-set-into-two-way-report-without-aggregation/m-p/889320#M351355 <P>DEFINE cat1 as GROUP, cat2 as ACROSS, and value as ANALYSIS. Combine cat2 and value with a comma in the COLUMN statement. This will work with your data as the cat1/cat2 combinations are unique.</P> Tue, 15 Aug 2023 11:09:50 GMT Kurt_Bremser 2023-08-15T11:09:50Z https://communities.sas.com/t5/SAS-Programming/Convert-data-set-into-two-way-report-without-aggregation/m-p/889319#M351354 <P>Hello</P> <P>I want to convert sas data set into summary report (Two -way summary report).</P> <P>The summary report should NOT aggregate any&nbsp; &nbsp;value and just display it</P> <P>Required summary report</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ronein_0-1692096999260.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/86730iE91A8DFC2053590C/image-size/medium?v=v2&amp;px=400" role="button" title="Ronein_0-1692096999260.png" alt="Ronein_0-1692096999260.png" /></span></P> <P>&nbsp;</P> <P>What is the way to do it please?</P> <PRE><CODE class=" language-sas">data have; input cat1 $ cat2 $ value; cards; a 1 10 a 2 20 a 3 30 b 1 40 b 2 50 b 3 60 c 1 70 c 2 80 c 3 90 ; Run;</CODE></PRE> Tue, 15 Aug 2023 10:57:04 GMT https://communities.sas.com/t5/SAS-Programming/Convert-data-set-into-two-way-report-without-aggregation/m-p/889319#M351354 Ronein 2023-08-15T10:57:04Z https://communities.sas.com/t5/SAS-Programming/Convert-data-set-into-two-way-report-without-aggregation/m-p/889320#M351355 <P>DEFINE cat1 as GROUP, cat2 as ACROSS, and value as ANALYSIS. Combine cat2 and value with a comma in the COLUMN statement. This will work with your data as the cat1/cat2 combinations are unique.</P> Tue, 15 Aug 2023 11:09:50 GMT https://communities.sas.com/t5/SAS-Programming/Convert-data-set-into-two-way-report-without-aggregation/m-p/889320#M351355 Kurt_Bremser 2023-08-15T11:09:50Z