topic SQL SIMPLE QUENSTION .. SBD HELP ME! in SAS Programming https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825155#M325912 <P>&nbsp;</P> <P>This is a table A and B.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 654px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/73684iDEFA4936EB4E278C/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3.png" style="width: 284px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/73687iC282D8AEC42EE197/image-size/large?v=v2&amp;px=999" role="button" title="3.png" alt="3.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>I want to create the following result by using SQL with the KEY value of the DTGBN column.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.png" style="width: 266px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/73686i2B1A66FF673D674E/image-size/large?v=v2&amp;px=999" role="button" title="2.png" alt="2.png" /></span></P> <P>&nbsp;</P> <P>some body help me!!!!</P> Sun, 24 Jul 2022 14:12:54 GMT AmeeKang 2022-07-24T14:12:54Z SQL SIMPLE QUENSTION .. SBD HELP ME! https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825155#M325912 <P>&nbsp;</P> <P>This is a table A and B.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 654px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/73684iDEFA4936EB4E278C/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3.png" style="width: 284px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/73687iC282D8AEC42EE197/image-size/large?v=v2&amp;px=999" role="button" title="3.png" alt="3.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>I want to create the following result by using SQL with the KEY value of the DTGBN column.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.png" style="width: 266px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/73686i2B1A66FF673D674E/image-size/large?v=v2&amp;px=999" role="button" title="2.png" alt="2.png" /></span></P> <P>&nbsp;</P> <P>some body help me!!!!</P> Sun, 24 Jul 2022 14:12:54 GMT https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825155#M325912 AmeeKang 2022-07-24T14:12:54Z Re: SQL SIMPLE QUENSTION .. SBD HELP ME! https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825157#M325913 <P>Please explain the logic used here to give the desired result to be 100+300+50+70-20</P> <P>&nbsp;</P> <P>How do you get that from the original data, what is the logic?</P> <P>&nbsp;</P> <P>What does table B have to do with this problem?</P> Sun, 24 Jul 2022 14:28:14 GMT https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825157#M325913 PaigeMiller 2022-07-24T14:28:14Z Re: SQL SIMPLE QUENSTION .. SBD HELP ME! https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825177#M325925 <P>How do you know that you are supposed to:</P> <OL> <LI>Add the four RFAMT entries in blue cells (100+300+50+70)</LI> <LI>Subtract the RFAMT in yellow (-20)</LI> <LI>Ignore the RFAMT in the white cell (970000090)</LI> </OL> <P>&nbsp;</P> <P>Why do you refer to the DTBIN column as a key?</P> Mon, 25 Jul 2022 01:36:34 GMT https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825177#M325925 mkeintz 2022-07-25T01:36:34Z Re: SQL SIMPLE QUENSTION .. SBD HELP ME! https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825197#M325936 <P>Just guessing:</P> <UL> <LI>DTGBN: T = addition, M = substraction</LI> <LI>table_b.accno must match either table_a.iacno or table_a.oacno</LI> </UL> <P>Right?</P> <P>Drop the idea of using sql, data step is most likely better readable an far easier to code.</P> <P>Until you post the data in usable form (data steps with datalines) i can't suggest any code.</P> Mon, 25 Jul 2022 09:25:26 GMT https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825197#M325936 andreas_lds 2022-07-25T09:25:26Z Re: SQL SIMPLE QUENSTION .. SBD HELP ME! https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825207#M325940 <P>Another thing you need to tell us: what exactly do you expect as output? A dataset, a table, a line in the log? How should it look like?</P> Mon, 25 Jul 2022 10:23:39 GMT https://communities.sas.com/t5/SAS-Programming/SQL-SIMPLE-QUENSTION-SBD-HELP-ME/m-p/825207#M325940 andreas_lds 2022-07-25T10:23:39Z