Hello, I am unsure why the line: "order by t.month" is giving an error: ERROR: File WORK.G.DATA does not exist. Can someone help me to understand why? libname G "/server/File/location";
libname O "&myfiles_root/file/location"Access=readonly;
%let RunYear = 2021;
%let DateA = 202108_211011;
%let DateB = 2021_202110;
data C;
set G.expdtrs_&RunYear._r&DateA.;
run;
data A;
set OSC.tcoc_part_a_&DateB.;
run;
data B;
set OSC.tcoc_part_b_&DateB.;
run;
/* Compare numbers*/
proc sql;
create table compare as
select t.month
,t.apple
,t.banana
,a.orange
,b.cherry
,case
when t.apple = a.orange
then 'YES'
else 'NO'
end as difference_a_o
,case
when t.banana = b.cherry
then 'YES'
else 'NO'
end as difference_b_c
from G t
left join A a
on t.month = a.month
left join B b
on t.month = b.month
order by t.month
;
quit;
... View more