https://communities.sas.com/t5/SAS-Data-Science/data-selection-automation-process/m-p/574542#M7895 <P>Hello, all</P><P>Just have a question about data selection. The process flow is below, the append node generates a list (will be updated daily) of items to be extracted from VM_MERPS_STOCKINV. At beginning, I would like to use SAS code node to do PROC SQL, but found only one table (VW_MERPS_STOCKINV) is in training source, and cannot find the table after Append node.&nbsp;</P><P>&nbsp;</P><P>Appreciating suggestions of how to get two tables for the next node as the data input.</P><P>&nbsp;</P><P>Many thanks!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 518px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/31108i0317AA56E1DE1B7D/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Thu, 18 Jul 2019 12:57:46 GMT Jonison 2019-07-18T12:57:46Z https://communities.sas.com/t5/SAS-Data-Science/data-selection-automation-process/m-p/574542#M7895 <P>Hello, all</P><P>Just have a question about data selection. The process flow is below, the append node generates a list (will be updated daily) of items to be extracted from VM_MERPS_STOCKINV. At beginning, I would like to use SAS code node to do PROC SQL, but found only one table (VW_MERPS_STOCKINV) is in training source, and cannot find the table after Append node.&nbsp;</P><P>&nbsp;</P><P>Appreciating suggestions of how to get two tables for the next node as the data input.</P><P>&nbsp;</P><P>Many thanks!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 518px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/31108i0317AA56E1DE1B7D/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Thu, 18 Jul 2019 12:57:46 GMT https://communities.sas.com/t5/SAS-Data-Science/data-selection-automation-process/m-p/574542#M7895 Jonison 2019-07-18T12:57:46Z