Modify Statement

It modifies the table.

data emp1;
input eid salary ;
cards;
101 2000
102 3000
;
data emp1;
set emp1;
newsalary=salary+1000;
run;
data emp2;
input eid salary ;
cards;
201 2500
202 3000
;

data emp2;
modify emp2;/*not allow new variables*/
newsalary=salary+1000;
run;

/*replace master file by child file by expression*/
data emp3;
input eid  des $ salary ;
cards;
101 tester 4000
102 programer 5000
103 analyst 4500
104 tester 4200
105 programer 5000
;
data emp4;
input eid hic ;
cards;
101 0.2
104 0.3
102 0.5
;
proc sort data=emp3;
by eid;
run;
proc sort data=emp4;
by eid;
run;

/*expression*/
data emp3;
modify emp3 emp4;
by eid;
salary=salary+(salary*hic);
run;
proc print data=emp3;
run;