topic Merge tables in CAS in SAS Programming https://communities.sas.com/t5/SAS-Programming/Merge-tables-in-CAS/m-p/800889#M315134 <P>Hello ,</P> <P>When i use a DATA step to merge SAS<SUP>®</SUP><SPAN>&nbsp;</SPAN>Cloud Analytic Services (CAS) tables with a BY statement, the following errors appear :</P> <DIV id="sasLogError1_1591897559138" class="sasError"><FONT color="#FF0000">ERROR: The first BY variable,<SPAN>&nbsp;</SPAN><EM>variable-name</EM>, must have the same format with all input data sets the BY statement applies to when using DATA step in Cloud Analytic Services.</FONT></DIV> <DIV class="sasError"><FONT color="#FF0000">ERROR: The action stopped due to errors.</FONT></DIV> <DIV class="sasError">&nbsp;</DIV> <DIV class="sasError"><FONT color="#000000">My variable is alphanumeric, do you know how to fix this ?</FONT></DIV> <DIV class="sasError">&nbsp;</DIV> <DIV class="sasError"><FONT color="#000000">thank you&nbsp;</FONT></DIV> Tue, 08 Mar 2022 16:23:05 GMT aloou 2022-03-08T16:23:05Z Merge tables in CAS https://communities.sas.com/t5/SAS-Programming/Merge-tables-in-CAS/m-p/800889#M315134 <P>Hello ,</P> <P>When i use a DATA step to merge SAS<SUP>®</SUP><SPAN>&nbsp;</SPAN>Cloud Analytic Services (CAS) tables with a BY statement, the following errors appear :</P> <DIV id="sasLogError1_1591897559138" class="sasError"><FONT color="#FF0000">ERROR: The first BY variable,<SPAN>&nbsp;</SPAN><EM>variable-name</EM>, must have the same format with all input data sets the BY statement applies to when using DATA step in Cloud Analytic Services.</FONT></DIV> <DIV class="sasError"><FONT color="#FF0000">ERROR: The action stopped due to errors.</FONT></DIV> <DIV class="sasError">&nbsp;</DIV> <DIV class="sasError"><FONT color="#000000">My variable is alphanumeric, do you know how to fix this ?</FONT></DIV> <DIV class="sasError">&nbsp;</DIV> <DIV class="sasError"><FONT color="#000000">thank you&nbsp;</FONT></DIV> Tue, 08 Mar 2022 16:23:05 GMT https://communities.sas.com/t5/SAS-Programming/Merge-tables-in-CAS/m-p/800889#M315134 aloou 2022-03-08T16:23:05Z Re: Merge tables in CAS https://communities.sas.com/t5/SAS-Programming/Merge-tables-in-CAS/m-p/800893#M315137 <P>Maxim 3: Know Your Data.</P> <P>Inspect all datasets participating in the MERGE for the type of the BY variable.</P> Tue, 08 Mar 2022 16:28:39 GMT https://communities.sas.com/t5/SAS-Programming/Merge-tables-in-CAS/m-p/800893#M315137 Kurt_Bremser 2022-03-08T16:28:39Z