topic Re: sas in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/sas/m-p/369641#M65050 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/144104">@vinod4842</a> wrote:<BR /> <PRE class="lang-sql prettyprint prettyprinted"><CODE><SPAN class="pln">Name Score A </SPAN><SPAN class="lit">2</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">A </SPAN><SPAN class="lit">1</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN></CODE></PRE> <P>I want a query which give the following output.</P> <PRE class="lang-sql prettyprint prettyprinted"><CODE><SPAN class="pln">Name Score A </SPAN><SPAN class="lit">2</SPAN><SPAN class="pln">A </SPAN><SPAN class="lit">1</SPAN><SPAN class="pln">Subtotal </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">Subtotal </SPAN><SPAN class="lit">6</SPAN></CODE></PRE> <P>Please help me with an procSQL code</P> <HR /></BLOCKQUOTE> <P>Please help me by explaining how you get the output from the input.</P> Thu, 22 Jun 2017 18:57:59 GMT PaigeMiller 2017-06-22T18:57:59Z sas https://communities.sas.com/t5/SAS-Procedures/sas/m-p/369638#M65049 <PRE class="lang-sql prettyprint prettyprinted"><CODE><SPAN class="pln">Name Score A </SPAN><SPAN class="lit">2</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">A </SPAN><SPAN class="lit">1</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN></CODE></PRE><P>I want a query which give the following output.</P><PRE class="lang-sql prettyprint prettyprinted"><CODE><SPAN class="pln">Name Score A </SPAN><SPAN class="lit">2</SPAN><SPAN class="pln">A </SPAN><SPAN class="lit">1</SPAN><SPAN class="pln">Subtotal </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">Subtotal </SPAN><SPAN class="lit">6</SPAN></CODE></PRE><P>Please help me with an procSQL code</P> Thu, 22 Jun 2017 18:50:56 GMT https://communities.sas.com/t5/SAS-Procedures/sas/m-p/369638#M65049 vinod4842 2017-06-22T18:50:56Z Re: sas https://communities.sas.com/t5/SAS-Procedures/sas/m-p/369641#M65050 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/144104">@vinod4842</a> wrote:<BR /> <PRE class="lang-sql prettyprint prettyprinted"><CODE><SPAN class="pln">Name Score A </SPAN><SPAN class="lit">2</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">A </SPAN><SPAN class="lit">1</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN></CODE></PRE> <P>I want a query which give the following output.</P> <PRE class="lang-sql prettyprint prettyprinted"><CODE><SPAN class="pln">Name Score A </SPAN><SPAN class="lit">2</SPAN><SPAN class="pln">A </SPAN><SPAN class="lit">1</SPAN><SPAN class="pln">Subtotal </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">B </SPAN><SPAN class="lit">3</SPAN><SPAN class="pln">Subtotal </SPAN><SPAN class="lit">6</SPAN></CODE></PRE> <P>Please help me with an procSQL code</P> <HR /></BLOCKQUOTE> <P>Please help me by explaining how you get the output from the input.</P> Thu, 22 Jun 2017 18:57:59 GMT https://communities.sas.com/t5/SAS-Procedures/sas/m-p/369641#M65050 PaigeMiller 2017-06-22T18:57:59Z Re: sas https://communities.sas.com/t5/SAS-Procedures/sas/m-p/369650#M65052 <P>Instead of recieving an answer you're seeing this post because your question is unclear.&nbsp;</P> <P>&nbsp;</P> <P>Please take the time to properly explain your question, provide sample input and output data where appropriate, and detail your logic. Without this we are forced to guess what you want. Or we just ignore your question. It's in your best interest to take the time to do so.&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 22 Jun 2017 19:13:19 GMT https://communities.sas.com/t5/SAS-Procedures/sas/m-p/369650#M65052 Reeza 2017-06-22T19:13:19Z