ERROR: The following columns were not found in the contributing tables

[BrandonBayles]

Hello. I am new too SAS. I am trying to combine the two tables below to include The domains from the Domains table that are equivalent to the question numbers that are on both tables. I keep getting the error below which says the the columns do not exist when I look at the tables I am pretty sure I am labeling them correctly? Any help would be appreciated. Thanks.

%LET A = A;
TITLE "FINAL FORM";

PROC SQL;
CREATE TABLE FINAL_FORM_&A AS
	SELECT Student, Results&A.QuestionNum, Scores, Domains_Form&A.DomainNum, Form
		
    FROM Results&A INNER JOIN Domains_Form&A
	ON Results&A.QuestionNum  = Domains_Form&A.DomainNum;
QUIT;

PROC PRINT DATA=FINAL_FORM_&A;
RUN;

ERROR: The following columns were not found in the contributing tables: Domains_FormADomainNum, ResultsAQuestionNum.

[Astounding · Accepted solution]

When referring to a macro variable, end the reference with a dot. Since the SQL syntax also needs a dot between the table name and the field name, use two dots:

ON Results

[Astounding]

ON Results&A..QuestionNum =
Domain_form&A..DomainNum

[BrandonBayles]

That worked. Thank you.