Help using Base SAS procedures

What is this 'n in SQL right join?

Accepted Solution Solved
Reply
Super Contributor
Posts: 338
Accepted Solution

What is this 'n in SQL right join?

Hi SAS Forum,

Could anyone help me to understand what this green highlighted 'n means in this SQL right joining?

PROC SQL;

            CREATE TABLE WORK.A33 AS

            SELECT        A11.Audit_num         LABEL  ="Audit_num",

                   A11.IDnum             LABEL  ="IDnum",

                   A11.Amount_month1     LABEL  ="Amount_month1",

                   A22.IDnum             LABEL  ="IDnum"                       AS 'IDnuma (IDnum)'n,

                   A22.Amount_month1     LABEL  ="Amount_month1"     AS Amount_month1a

                 

               FROM           WORK.A22             A22 RIGHT JOIN

                     WORK.A11             A11 ON

                     (A22.Audit_num = A11.Audit_num);

QUIT;

Thanks

Miris


Accepted Solutions
Solution
‎02-21-2014 10:32 AM
Respected Advisor
Posts: 4,919

Re: What is this 'n in SQL right join?

It asks SAS to accept the string "IDnuma (IDnum)" as a variable name. - PG

PG

View solution in original post


All Replies
Solution
‎02-21-2014 10:32 AM
Respected Advisor
Posts: 4,919

Re: What is this 'n in SQL right join?

It asks SAS to accept the string "IDnuma (IDnum)" as a variable name. - PG

PG
Super Contributor
Posts: 338

Re: What is this 'n in SQL right join?

Hi PGStats,

Thank you very much for explaining this to me.

Regards

Miris

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 177 views
  • 0 likes
  • 2 in conversation