Hi, Thanks for the code, but when I'm using Proc SQL fro updating the table, I am getting some errors. I am using the following code, where employee is the name of my table and Emp_ID is one of the variable. %let dsid=%sysfunc(open(employee)); %let var_num=%sysfunc(varnum(&dsid,Emp_Add)); proc sql; %if %eval(&var_num) >0 %then %do; update employee as a set Emp_ID = Emp_ID * 100; end; %else %do; select account_number from Employee_Salary %end; %quit; It says %IF, %else are not valid in open code!
... View more