Simple code formatting lets the error stand out like a beacon:
proc sql;
create table NZ as select
Olympicscs1.Probability,
Olympicscs1.Account_Name as Client,
Olympicscs1.Champ,
Olympicscs1.Last_Modified_Date as Modified,
format MMDDYY8.,
Olympicscs1.Deal_Comments,
Olympicscs1.Tot_Budget format dollar20.,
Olympicscs2.Digi_Budget format dollar20.
from Olympicscs1, Olympicscs2
where
Olympicscs1.Probability=Olympicscs2.Prob_Digi and
Olympicscs1.Account_Name=Olympicscs2.Account_Name and
Olympicscs1.Probability NE 0
order by Olympicscs1.Probability
;
quit;
Writing spaghetti code is the main culprit here.
... View more
