Hello, I have a final_table that I need to create after joining some other tables. I am dealing with large number of different structured xmls, So everytime whenever I create my final_table I would like to know if there is a way that I can check the variable is present or not before doing the join inside the proc sql. My actual scenario is : proc sql ;
create table final_table AS
select
a.customer
,a.year
,a.var1
,a.var2
,a.var3
,b.*
,c.*
from work.final_output as a
inner join prod.scores as b on a.id = b.id
inner join prod.city as c on a.business_id=c.id
quit; But in my current XML var1,var2 and var3 are not present. And I get the following error ERROR: Column var1 could not be found in the table/view identified with the correlation name a. ERROR: Column var2 could not be found in the table/view identified with the correlation name a. ERROR: Column var3 could not be found in the table/view identified with the correlation name a. So I would like to know if I can check the presence of variable when a join the table from within the proc sql. Please help Thanks in advance!
... View more
