topic Re: ERROR: The following columns were not found in the contributing tables in SAS Programming

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

BrandonBayles — Tue, 26 Feb 2019 01:07:13 GMT

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.

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

Astounding — Tue, 26 Feb 2019 01:21:53 GMT

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

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

Astounding — Tue, 26 Feb 2019 01:24:16 GMT

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

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

BrandonBayles — Tue, 26 Feb 2019 01:59:53 GMT

That worked. Thank you.