Well, I figured out what is going on here, I was getting the issue because it was creating a view and I didn't have an alias for the columns which is invalid. What is interesting is that it proceeds with the view creation but uses only the first instance of the column name rather than throwing a warning. data genders;
input gender $10.;
cards;
Male
Female
;
proc sql;
create view GENDERS_JOINED as
select
m.Gender,
f.Gender
from GENDERS m
inner join GENDERS f
on f.Gender = 'Female'
where m.Gender='Male'; This is resulting in the following: However, providing an alias for the fields it doesn't create the issue: data genders;
input gender $10.;
cards;
Male
Female
;
proc sql;
create view GENDERS_JOINED as
select
m.Gender as M_G,
f.Gender as F_G
from GENDERS m
inner join GENDERS f
on f.Gender = 'Female'
where m.Gender='Male'; If you aren't creating the view with no alias it still works fine as expected: data genders;
input gender $10.;
cards;
Male
Female
;
proc sql;
select
m.Gender,
f.Gender
from GENDERS m
inner join GENDERS f
on f.Gender = 'Female'
where m.Gender='Male';
... View more
