topic Re: What is a contributing table error? in New SAS User

What is a contributing table error?

Sandeep77 — Tue, 28 Jun 2022 10:57:34 GMT

Hi Expert,

I am trying to find some information from the database and I feel that I have correctly written the code but I am getting error as following columns were not found in the contributing tables. I checked the columns in telephonenumbers database and these columns are available in the telephonenumber tables. Please suggest what is the error.

proc sql;
create table phone_numbers as
select  
tnkey as debt_code,
tnphone,
tntype 
from p2scflow.telephonenumbers
where tntype = 'D';
quit;

error:

29         proc sql;
30         create table phone_numbers as
31         select  tnkey as debt_code,
32         tnphone,
33         tntype 
34         from p2scflow.telephonenumbers
35         where tntype = 'D';
ERROR: The following columns were not found in the contributing tables: 'tntype 'n, ' tnkey'n.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
36         quit;

Re: What is a contributing table error?

FreelanceReinh — Tue, 28 Jun 2022 11:52:44 GMT

Hi @Sandeep77,

The error message indicates that your code contains unwanted characters that only look like blanks: one preceding "tnkey" (note the double space between that name and the SELECT keyword) and one following "tntype". Delete these characters in your code and retype ordinary blanks where necessary.

Re: What is a contributing table error?

Sandeep77 — Tue, 28 Jun 2022 12:08:24 GMT

Thank you!