topic Grouping rows in SAS Programming https://communities.sas.com/t5/SAS-Programming/Grouping-rows/m-p/814830#M321637 <P>Hi Team,</P> <P>&nbsp;</P> <P>I have data set called Test in this data set we have many column but I need Few column Total.</P> <P>&nbsp;</P> <P>IDMs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total Suppliers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bank data complete&nbsp;</P> <P>Not Required&nbsp; &nbsp; &nbsp; &nbsp; 1277&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22,830</P> <P>One IDM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1699</P> <P>Two IDMs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23,115&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24,529</P> <P>Zero IDMs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;67</P> <P>Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 24,529</P> <P>&nbsp;</P> <P>could you please help me how to create this data sets.</P> <P>&nbsp;</P> <P>Thanks in advance</P> Tue, 24 May 2022 09:54:21 GMT Saleem 2022-05-24T09:54:21Z Grouping rows https://communities.sas.com/t5/SAS-Programming/Grouping-rows/m-p/814830#M321637 <P>Hi Team,</P> <P>&nbsp;</P> <P>I have data set called Test in this data set we have many column but I need Few column Total.</P> <P>&nbsp;</P> <P>IDMs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total Suppliers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bank data complete&nbsp;</P> <P>Not Required&nbsp; &nbsp; &nbsp; &nbsp; 1277&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22,830</P> <P>One IDM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1699</P> <P>Two IDMs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23,115&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24,529</P> <P>Zero IDMs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;67</P> <P>Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 24,529</P> <P>&nbsp;</P> <P>could you please help me how to create this data sets.</P> <P>&nbsp;</P> <P>Thanks in advance</P> Tue, 24 May 2022 09:54:21 GMT https://communities.sas.com/t5/SAS-Programming/Grouping-rows/m-p/814830#M321637 Saleem 2022-05-24T09:54:21Z Re: Grouping rows https://communities.sas.com/t5/SAS-Programming/Grouping-rows/m-p/814835#M321639 <P>So your data set to left is what you have?</P> <P>It looks like a report. Try to get hold of the original/underlying data.</P> <P>As general tip: you could probably make use of user defined formats.</P> <P>You apply them in your report program (like PROC REPORT or PROC TABULATE) and it will group your rows "automatically".</P> <P><A href="https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/236-29.pdf" target="_blank">https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/236-29.pdf</A></P> Tue, 24 May 2022 09:58:31 GMT https://communities.sas.com/t5/SAS-Programming/Grouping-rows/m-p/814835#M321639 LinusH 2022-05-24T09:58:31Z Summing columns https://communities.sas.com/t5/SAS-Programming/Grouping-rows/m-p/814842#M321640 <P>This looks more like an Excel file than a SAS data set. In a SAS data set, there would be the same number of rows for each column.</P> <P><BR />Can you please actually <STRONG>SHOW US</STRONG> the SAS data set as it appears on your screen? (In this case, a screen capture is fine)</P> Tue, 24 May 2022 10:05:21 GMT https://communities.sas.com/t5/SAS-Programming/Grouping-rows/m-p/814842#M321640 PaigeMiller 2022-05-24T10:05:21Z