Hi Prateek1 You should drop , after Olympicscs1.Last_Modified_Date as Modified in this way format MMDDYY8. runs for this variable, on other hand you should write a variable for the format. 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;
... View more