topic What is this 'n in SQL right join? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/What-is-this-n-in-SQL-right-join/m-p/182008#M46350 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-size: 12pt;"><STRONG style="background: white; font-family: 'Courier New';">Hi SAS Forum,</STRONG></SPAN></P><P> </P><P><SPAN style="color: #000000; font-size: 12pt;"><STRONG style="background: white; font-family: 'Courier New';">Could anyone help me to understand what this green highlighted 'n means in this SQL right joining?</STRONG></SPAN></P><P> </P><P><SPAN style="font-size: 12pt;"><STRONG style="color: navy; background: white; font-family: 'Courier New';">PROC</STRONG> <STRONG style="color: navy; background: white; font-family: 'Courier New';">SQL</STRONG><SPAN style="font-family: 'Courier New'; background: white; color: black;">;</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">CREATE</SPAN> <SPAN style="font-family: 'Courier New'; background: white; color: blue;">TABLE</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;"> WORK.A33 </SPAN><SPAN style="font-family: 'Courier New'; background: white; color: blue;">AS</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">SELECT</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A11.Audit_num&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"Audit_num"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A11.IDnum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"IDnum"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A11.Amount_month1&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"Amount_month1"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A22.IDnum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"IDnum"</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">AS</SPAN> <SPAN style="font-family: 'Courier New'; background: white; color: purple;">'IDnuma (IDnum)'<SPAN style="background: lime;">n</SPAN></SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A22.Amount_month1&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"Amount_month1"</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">AS</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;"> Amount_month1a</SPAN></SPAN></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">FROM</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WORK.A22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A22 </SPAN><SPAN style="font-family: 'Courier New'; background: white; color: blue;">RIGHT</SPAN> <SPAN style="font-family: 'Courier New'; background: white; color: blue;">JOIN</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;"> </SPAN></SPAN></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WORK.A11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A11 ON </SPAN></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 12pt;"> </SPAN></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (A22.Audit_num = A11.Audit_num);</SPAN></P><P><SPAN style="font-size: 12pt;"><STRONG style="color: navy; background: white; font-family: 'Courier New';">QUIT</STRONG><SPAN style="font-family: 'Courier New'; background: white; color: black;">;</SPAN></SPAN></P><P></P><P><SPAN style="color: black; font-size: 12pt; background: white; font-family: 'Courier New';">Thanks</SPAN></P><P></P><P><SPAN style="color: black; font-size: 12pt; background: white; font-family: 'Courier New';">Miris</SPAN></P></BODY></HTML> Fri, 21 Feb 2014 15:25:26 GMT Mirisage 2014-02-21T15:25:26Z What is this 'n in SQL right join? https://communities.sas.com/t5/SAS-Procedures/What-is-this-n-in-SQL-right-join/m-p/182008#M46350 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-size: 12pt;"><STRONG style="background: white; font-family: 'Courier New';">Hi SAS Forum,</STRONG></SPAN></P><P> </P><P><SPAN style="color: #000000; font-size: 12pt;"><STRONG style="background: white; font-family: 'Courier New';">Could anyone help me to understand what this green highlighted 'n means in this SQL right joining?</STRONG></SPAN></P><P> </P><P><SPAN style="font-size: 12pt;"><STRONG style="color: navy; background: white; font-family: 'Courier New';">PROC</STRONG> <STRONG style="color: navy; background: white; font-family: 'Courier New';">SQL</STRONG><SPAN style="font-family: 'Courier New'; background: white; color: black;">;</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">CREATE</SPAN> <SPAN style="font-family: 'Courier New'; background: white; color: blue;">TABLE</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;"> WORK.A33 </SPAN><SPAN style="font-family: 'Courier New'; background: white; color: blue;">AS</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">SELECT</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A11.Audit_num&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"Audit_num"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A11.IDnum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"IDnum"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A11.Amount_month1&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"Amount_month1"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A22.IDnum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"IDnum"</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">AS</SPAN> <SPAN style="font-family: 'Courier New'; background: white; color: purple;">'IDnuma (IDnum)'<SPAN style="background: lime;">n</SPAN></SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A22.Amount_month1&nbsp;&nbsp;&nbsp;&nbsp; LABEL&nbsp; =</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"Amount_month1"</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">AS</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;"> Amount_month1a</SPAN></SPAN></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">FROM</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WORK.A22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A22 </SPAN><SPAN style="font-family: 'Courier New'; background: white; color: blue;">RIGHT</SPAN> <SPAN style="font-family: 'Courier New'; background: white; color: blue;">JOIN</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;"> </SPAN></SPAN></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WORK.A11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A11 ON </SPAN></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 12pt;"> </SPAN></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (A22.Audit_num = A11.Audit_num);</SPAN></P><P><SPAN style="font-size: 12pt;"><STRONG style="color: navy; background: white; font-family: 'Courier New';">QUIT</STRONG><SPAN style="font-family: 'Courier New'; background: white; color: black;">;</SPAN></SPAN></P><P></P><P><SPAN style="color: black; font-size: 12pt; background: white; font-family: 'Courier New';">Thanks</SPAN></P><P></P><P><SPAN style="color: black; font-size: 12pt; background: white; font-family: 'Courier New';">Miris</SPAN></P></BODY></HTML> Fri, 21 Feb 2014 15:25:26 GMT https://communities.sas.com/t5/SAS-Procedures/What-is-this-n-in-SQL-right-join/m-p/182008#M46350 Mirisage 2014-02-21T15:25:26Z Re: What is this 'n in SQL right join? https://communities.sas.com/t5/SAS-Procedures/What-is-this-n-in-SQL-right-join/m-p/182009#M46351 <HTML><HEAD></HEAD><BODY><P>It asks SAS to accept the string "<SPAN style="color: #800080; font-family: 'Courier New'; font-size: 16.363636016845703px; background-color: #ffffff;">IDnuma (IDnum)</SPAN>" as a variable <SPAN style="color: #008000;"><STRONG>n</STRONG></SPAN>ame. - PG</P></BODY></HTML> Fri, 21 Feb 2014 15:32:24 GMT https://communities.sas.com/t5/SAS-Procedures/What-is-this-n-in-SQL-right-join/m-p/182009#M46351 PGStats 2014-02-21T15:32:24Z Re: What is this 'n in SQL right join? https://communities.sas.com/t5/SAS-Procedures/What-is-this-n-in-SQL-right-join/m-p/182010#M46352 <HTML><HEAD></HEAD><BODY><P>Hi PGStats,</P><P>Thank you very much for explaining this to me.</P><P>Regards</P><P></P><P>Miris</P></BODY></HTML> Sun, 23 Feb 2014 13:48:43 GMT https://communities.sas.com/t5/SAS-Procedures/What-is-this-n-in-SQL-right-join/m-p/182010#M46352 Mirisage 2014-02-23T13:48:43Z