topic Union in PROC sql with columns in Cyrillic in SAS Programming https://communities.sas.com/t5/SAS-Programming/Union-in-PROC-sql-with-columns-in-Cyrillic/m-p/713001#M219899 <P>Hi, users.</P><P>&nbsp;</P><P>I have a problem trying to merge together several tables. I have tables that have column names in Cyrillic. When I use my code, I receive column names inside of columns instead of required data. Columns that have English names are displayed correctly.</P><P>Correct data example:</P><TABLE><TBODY><TR><TD>num_merch</TD><TD>num_term</TD><TD>HUB</TD><TD>DT_AGR_START</TD><TD>Type_merch</TD><TD>CNUM</TD><TD>MCC</TD></TR><TR><TD>1594027</TD><TD>94027</TD><TD>МСК</TD><TD>26SEP18</TD><TD>2CAN</TD><TD>Y39611</TD><TD>6300</TD></TR><TR><TD>1563425</TD><TD>63425</TD><TD>МСК</TD><TD>14FEB17</TD><TD>INPAS</TD><TD>401368</TD><TD>5039</TD></TR><TR><TD>1566280</TD><TD>66280</TD><TD>МСК</TD><TD>27SEP17</TD><TD>INPAS</TD><TD>Z65620</TD><TD>5651</TD></TR><TR><TD>1791510</TD><TD>91510</TD><TD>МСК</TD><TD>13SEP16</TD><TD>YARUS</TD><TD>CABFT8</TD><TD>5812</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I receive example:</P><TABLE><TBODY><TR><TD>num_merch</TD><TD>num_term</TD><TD>HUB</TD><TD>DT_AGR_START</TD><TD>Type_merch</TD><TD>CNUM</TD><TD>MCC</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>CAAGNR</TD><TD>5814</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>DAABCF</TD><TD>5131</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>400387</TD><TD>5732</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>401368</TD><TD>5039</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>CAB7HQ</TD><TD>5231</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I use code:</P><P>&nbsp;</P><P>proc sql;<BR />create table test as<BR />select<BR />'Номер мерчанта в<BR />Alpha' as num_merch,<BR />'Номер терминала в<BR />Alpha' as num_term,<BR />'ХАБ' as HUB,<BR />'Дата начала дейтсвия договора' as DT_AGR_START,<BR />'Тип мерчанта' as Type_merch,<BR />CNUM,<BR />MCC<BR /><BR />from WORK.JAN_2020</P><P>union all<BR /><BR />select<BR />'Номер мерчанта в<BR />Alpha' as num_merch,<BR />'Номер терминала в<BR />Alpha' as num_term,<BR />'ХАБ' as HUB,<BR />'Дата начала дейтсвия договора' as DT_AGR_START,<BR />'Тип мерчанта' as Type_merch,<BR />CNUM,<BR />MCC<BR /><BR />from WORK.FEB_2020<BR />;<BR />quit;</P><P>&nbsp;</P><P>Do you have any ideas?</P> Thu, 21 Jan 2021 08:03:45 GMT Anzelikue 2021-01-21T08:03:45Z Union in PROC sql with columns in Cyrillic https://communities.sas.com/t5/SAS-Programming/Union-in-PROC-sql-with-columns-in-Cyrillic/m-p/713001#M219899 <P>Hi, users.</P><P>&nbsp;</P><P>I have a problem trying to merge together several tables. I have tables that have column names in Cyrillic. When I use my code, I receive column names inside of columns instead of required data. Columns that have English names are displayed correctly.</P><P>Correct data example:</P><TABLE><TBODY><TR><TD>num_merch</TD><TD>num_term</TD><TD>HUB</TD><TD>DT_AGR_START</TD><TD>Type_merch</TD><TD>CNUM</TD><TD>MCC</TD></TR><TR><TD>1594027</TD><TD>94027</TD><TD>МСК</TD><TD>26SEP18</TD><TD>2CAN</TD><TD>Y39611</TD><TD>6300</TD></TR><TR><TD>1563425</TD><TD>63425</TD><TD>МСК</TD><TD>14FEB17</TD><TD>INPAS</TD><TD>401368</TD><TD>5039</TD></TR><TR><TD>1566280</TD><TD>66280</TD><TD>МСК</TD><TD>27SEP17</TD><TD>INPAS</TD><TD>Z65620</TD><TD>5651</TD></TR><TR><TD>1791510</TD><TD>91510</TD><TD>МСК</TD><TD>13SEP16</TD><TD>YARUS</TD><TD>CABFT8</TD><TD>5812</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I receive example:</P><TABLE><TBODY><TR><TD>num_merch</TD><TD>num_term</TD><TD>HUB</TD><TD>DT_AGR_START</TD><TD>Type_merch</TD><TD>CNUM</TD><TD>MCC</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>CAAGNR</TD><TD>5814</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>DAABCF</TD><TD>5131</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>400387</TD><TD>5732</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>401368</TD><TD>5039</TD></TR><TR><TD>Номер мерчанта вAlpha</TD><TD>Номер терминала вAlpha</TD><TD>ХАБ</TD><TD>Дата начала дейтсвия договора</TD><TD>Тип мерчанта</TD><TD>CAB7HQ</TD><TD>5231</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I use code:</P><P>&nbsp;</P><P>proc sql;<BR />create table test as<BR />select<BR />'Номер мерчанта в<BR />Alpha' as num_merch,<BR />'Номер терминала в<BR />Alpha' as num_term,<BR />'ХАБ' as HUB,<BR />'Дата начала дейтсвия договора' as DT_AGR_START,<BR />'Тип мерчанта' as Type_merch,<BR />CNUM,<BR />MCC<BR /><BR />from WORK.JAN_2020</P><P>union all<BR /><BR />select<BR />'Номер мерчанта в<BR />Alpha' as num_merch,<BR />'Номер терминала в<BR />Alpha' as num_term,<BR />'ХАБ' as HUB,<BR />'Дата начала дейтсвия договора' as DT_AGR_START,<BR />'Тип мерчанта' as Type_merch,<BR />CNUM,<BR />MCC<BR /><BR />from WORK.FEB_2020<BR />;<BR />quit;</P><P>&nbsp;</P><P>Do you have any ideas?</P> Thu, 21 Jan 2021 08:03:45 GMT https://communities.sas.com/t5/SAS-Programming/Union-in-PROC-sql-with-columns-in-Cyrillic/m-p/713001#M219899 Anzelikue 2021-01-21T08:03:45Z Re: Union in PROC sql with columns in Cyrillic https://communities.sas.com/t5/SAS-Programming/Union-in-PROC-sql-with-columns-in-Cyrillic/m-p/713004#M219901 <P>Cyrilic are not legal characters for a sas variable name.</P> <P>Next is a line in your code:</P> <PRE><CODE class=" language-sas">'Номер мерчанта в Alpha' as num_merch</CODE></PRE> <P>try to change it into:</P> <PRE><CODE class=" language-sas">'Номер мерчанта в Alpha'n as num_merch</CODE></PRE> <P>The same for other Cyrilic variables.</P> Thu, 21 Jan 2021 08:13:10 GMT https://communities.sas.com/t5/SAS-Programming/Union-in-PROC-sql-with-columns-in-Cyrillic/m-p/713004#M219901 Shmuel 2021-01-21T08:13:10Z