topic SAS DI Union error in SAS Studio https://communities.sas.com/t5/SAS-Studio/SAS-DI-Union-error/m-p/442443#M4816 <P>I have two table which I&nbsp;am trying to UNION, however, I am facing an issue where data from one fo the table get missed out.</P><P>I am working on SAS DI 4.9.</P><P>&nbsp;</P><P><U>Table 1</U></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Untitled1</TD><TD>Untitled2</TD><TD>Untitled3</TD><TD>Untitled4</TD><TD>Untitled5</TD><TD>Untitled6</TD><TD>Untitled7</TD><TD>Untitled8</TD><TD>Untitled9</TD></TR><TR><TD>LWI93262167</TD><TD>F</TD><TD>Change</TD><TD>26.9</TD><TD>09-Dec-12</TD><TD>A</TD><TD>T;T;F;F;F;T;F;T;T;F;T;F;F;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>VE98710787</TD><TD>F</TD><TD>Change</TD><TD>32.9</TD><TD>09-Dec-12</TD><TD>B</TD><TD>T;F;F;T;T;F;T; ;T;F; ;F;F;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>SDG13502113</TD><TD>F</TD><TD>No change</TD><TD>25.02</TD><TD>09-Dec-12</TD><TD>C</TD><TD>F;F;F;T;F;F;F;T;F;F; ;F;T;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>SDG38203520</TD><TD>F</TD><TD>No change</TD><TD>20.02</TD><TD>09-Dec-12</TD><TD>D</TD><TD>T;T;F;T;F;T;T; ;F;F;T;F;T;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>LW93262167</TD><TD>F</TD><TD>No change</TD><TD>27.02</TD><TD>09-Dec-12</TD><TD>E</TD><TD>T;T;F;F;F;T;F;T;F;F;T;F;T;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>Properties of table</U></P><TABLE><TBODY><TR><TD>Column</TD><TD>Type</TD><TD>length</TD><TD>Informat</TD><TD>Format</TD></TR><TR><TD>Untitled1</TD><TD>Character</TD><TD>23</TD><TD>$CHAR23.</TD><TD>$CHAR23.</TD></TR><TR><TD>Untitled2</TD><TD>Character</TD><TD>8</TD><TD>$8.</TD><TD>$8.</TD></TR><TR><TD>Untitled3</TD><TD>Character</TD><TD>15</TD><TD>$CHAR15.</TD><TD>$CHAR15.</TD></TR><TR><TD>Untitled4</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled5</TD><TD>Numeric</TD><TD>8</TD><TD>date.</TD><TD>date.</TD></TR><TR><TD>Untitled6</TD><TD>Character</TD><TD>500</TD><TD>$CHAR500.</TD><TD>$CHAR500.</TD></TR><TR><TD>Untitled7</TD><TD>Character</TD><TD>50</TD><TD>$CHAR50.</TD><TD>$CHAR50.</TD></TR><TR><TD>Untitled8</TD><TD>Character</TD><TD>10</TD><TD>$CHAR10.</TD><TD>$CHAR10.</TD></TR><TR><TD>Untitled9</TD><TD>Character</TD><TD>1000</TD><TD>$CHAR1000.</TD><TD>$CHAR1000.</TD></TR></TBODY></TABLE><P><U>Table 2</U></P><TABLE><TBODY><TR><TD>Untitled1</TD><TD>Untitled2</TD><TD>Untitled3</TD><TD>Untitled4</TD><TD>Untitled5</TD><TD>Untitled6</TD><TD>Untitled7</TD><TD>Untitled8</TD><TD>Untitled9</TD></TR><TR><TD>20170805_EAP_Account_Req_New_20180112_073647&nbsp;&nbsp;</TD><TD>1</TD><TD>4</TD><TD>32</TD><TD>05-Aug-17</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD><P>&nbsp;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</P></TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>properties of table</U></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Column</TD><TD>Type</TD><TD>length</TD><TD>Informat</TD><TD>Format</TD></TR><TR><TD>Untitled1</TD><TD>Character</TD><TD>46</TD><TD>$46.</TD><TD>$46.</TD></TR><TR><TD>Untitled2</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled3</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled4</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled5</TD><TD>Numeric</TD><TD>8</TD><TD>date.</TD><TD>date.</TD></TR><TR><TD>Untitled6</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled7</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled8</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled9</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>My output has missing values</U></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Untitled1</TD><TD>Untitled2</TD><TD>Untitled3</TD><TD>Untitled4</TD><TD>Untitled5</TD><TD>Untitled6</TD><TD>Untitled7</TD><TD>Untitled8</TD><TD>Untitled9</TD></TR><TR><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>4</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>.</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>LWI93262167&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>26.9</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>VE98710787&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>32.9</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>SDG13502113&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>25.02</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>SDG38203520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>20.02</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>LW93262167&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>27.02</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>can someone please explain or give me alternative</P> Mon, 05 Mar 2018 17:39:59 GMT Deepankar 2018-03-05T17:39:59Z SAS DI Union error https://communities.sas.com/t5/SAS-Studio/SAS-DI-Union-error/m-p/442443#M4816 <P>I have two table which I&nbsp;am trying to UNION, however, I am facing an issue where data from one fo the table get missed out.</P><P>I am working on SAS DI 4.9.</P><P>&nbsp;</P><P><U>Table 1</U></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Untitled1</TD><TD>Untitled2</TD><TD>Untitled3</TD><TD>Untitled4</TD><TD>Untitled5</TD><TD>Untitled6</TD><TD>Untitled7</TD><TD>Untitled8</TD><TD>Untitled9</TD></TR><TR><TD>LWI93262167</TD><TD>F</TD><TD>Change</TD><TD>26.9</TD><TD>09-Dec-12</TD><TD>A</TD><TD>T;T;F;F;F;T;F;T;T;F;T;F;F;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>VE98710787</TD><TD>F</TD><TD>Change</TD><TD>32.9</TD><TD>09-Dec-12</TD><TD>B</TD><TD>T;F;F;T;T;F;T; ;T;F; ;F;F;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>SDG13502113</TD><TD>F</TD><TD>No change</TD><TD>25.02</TD><TD>09-Dec-12</TD><TD>C</TD><TD>F;F;F;T;F;F;F;T;F;F; ;F;T;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>SDG38203520</TD><TD>F</TD><TD>No change</TD><TD>20.02</TD><TD>09-Dec-12</TD><TD>D</TD><TD>T;T;F;T;F;T;T; ;F;F;T;F;T;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>LW93262167</TD><TD>F</TD><TD>No change</TD><TD>27.02</TD><TD>09-Dec-12</TD><TD>E</TD><TD>T;T;F;F;F;T;F;T;F;F;T;F;T;F;T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>Properties of table</U></P><TABLE><TBODY><TR><TD>Column</TD><TD>Type</TD><TD>length</TD><TD>Informat</TD><TD>Format</TD></TR><TR><TD>Untitled1</TD><TD>Character</TD><TD>23</TD><TD>$CHAR23.</TD><TD>$CHAR23.</TD></TR><TR><TD>Untitled2</TD><TD>Character</TD><TD>8</TD><TD>$8.</TD><TD>$8.</TD></TR><TR><TD>Untitled3</TD><TD>Character</TD><TD>15</TD><TD>$CHAR15.</TD><TD>$CHAR15.</TD></TR><TR><TD>Untitled4</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled5</TD><TD>Numeric</TD><TD>8</TD><TD>date.</TD><TD>date.</TD></TR><TR><TD>Untitled6</TD><TD>Character</TD><TD>500</TD><TD>$CHAR500.</TD><TD>$CHAR500.</TD></TR><TR><TD>Untitled7</TD><TD>Character</TD><TD>50</TD><TD>$CHAR50.</TD><TD>$CHAR50.</TD></TR><TR><TD>Untitled8</TD><TD>Character</TD><TD>10</TD><TD>$CHAR10.</TD><TD>$CHAR10.</TD></TR><TR><TD>Untitled9</TD><TD>Character</TD><TD>1000</TD><TD>$CHAR1000.</TD><TD>$CHAR1000.</TD></TR></TBODY></TABLE><P><U>Table 2</U></P><TABLE><TBODY><TR><TD>Untitled1</TD><TD>Untitled2</TD><TD>Untitled3</TD><TD>Untitled4</TD><TD>Untitled5</TD><TD>Untitled6</TD><TD>Untitled7</TD><TD>Untitled8</TD><TD>Untitled9</TD></TR><TR><TD>20170805_EAP_Account_Req_New_20180112_073647&nbsp;&nbsp;</TD><TD>1</TD><TD>4</TD><TD>32</TD><TD>05-Aug-17</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD><P>&nbsp;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</P></TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>properties of table</U></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Column</TD><TD>Type</TD><TD>length</TD><TD>Informat</TD><TD>Format</TD></TR><TR><TD>Untitled1</TD><TD>Character</TD><TD>46</TD><TD>$46.</TD><TD>$46.</TD></TR><TR><TD>Untitled2</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled3</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled4</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled5</TD><TD>Numeric</TD><TD>8</TD><TD>date.</TD><TD>date.</TD></TR><TR><TD>Untitled6</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled7</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled8</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR><TR><TD>Untitled9</TD><TD>Character</TD><TD>8</TD><TD>(None)</TD><TD>(None)</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>My output has missing values</U></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Untitled1</TD><TD>Untitled2</TD><TD>Untitled3</TD><TD>Untitled4</TD><TD>Untitled5</TD><TD>Untitled6</TD><TD>Untitled7</TD><TD>Untitled8</TD><TD>Untitled9</TD></TR><TR><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>4</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>.</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>LWI93262167&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>26.9</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>VE98710787&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>32.9</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>SDG13502113&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>25.02</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>SDG38203520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>20.02</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR><TR><TD>LW93262167&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</TD><TD>27.02</TD><TD>12-Sep-12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>can someone please explain or give me alternative</P> Mon, 05 Mar 2018 17:39:59 GMT https://communities.sas.com/t5/SAS-Studio/SAS-DI-Union-error/m-p/442443#M4816 Deepankar 2018-03-05T17:39:59Z Re: SAS DI Union error https://communities.sas.com/t5/SAS-Studio/SAS-DI-Union-error/m-p/442838#M4855 <P>Why no one is answering.</P> Tue, 06 Mar 2018 11:42:16 GMT https://communities.sas.com/t5/SAS-Studio/SAS-DI-Union-error/m-p/442838#M4855 Deepankar 2018-03-06T11:42:16Z Re: SAS DI Union error https://communities.sas.com/t5/SAS-Studio/SAS-DI-Union-error/m-p/443002#M4873 This is site for volunteers, you could hope for, but require, to be answered.<BR />Also, DI Studio question should be in the Data Management forum. SAS Studio is a different product.<BR /><BR />That said, show the code generated for the trasformation.<BR />Also, please stay why you are you this transformation - what is the business rule here? Tue, 06 Mar 2018 18:35:57 GMT https://communities.sas.com/t5/SAS-Studio/SAS-DI-Union-error/m-p/443002#M4873 LinusH 2018-03-06T18:35:57Z