Calculated references work in the PROC SQL WHERE clause as below.
proc sql noprint;
create table task as
select
name,
sex,
age,
age*10 as myVar
from
sashelp.class
where
calculated myVar ge 150;
quit;
I wonder why it does not work in an ON clause?
data romans;
length roman $ 4;
age='11';roman='XI';output;
age='12';roman='XII';output;
age='13';roman='XIII';output;
age='14';roman='XIV';output;
age='15';roman='XV';output;
age='16';roman='XVI';output;
run;
proc sql noprint;
create table task as
select
a.name,
a.sex,
a.age,
strip(put(a.age,8.)) as myVar,
b.roman
from
sashelp.class a
inner join romans b
on calculated myVar=b.age;
quit;
... View more
![SASGF 2020 [Virtual] Attendee](/html/@A53A708409112314CE528E074D4C8C1F/badge_icons/badge_sasgf20_attendee.png "SASGF 2020 [Virtual] Attendee"){kind=icon}
