Friday, 7 October 2011

IF Statement


Conditional  statement
data es;
input eid salary sale;
cards;
234 2500 500
256 3423 400
231 4500 321
289 5000 450
211 3678 345
221 6000 400
235 8900 567
223 9100 600
;
data emp1;
set es;
newsalary = salary+1000;
run;
proc print data=emp1;
run;
data emp2;
set es;
if sale>=500 then newsalary=salary+2000;
else newsalary=salary+1000;
run;
proc print data=emp2;
run;
data emp3;
set es;
if sale>=500 then newsalary=salary+2000;
else if sale>=400 and sale<500 then newsalary=salary+1500;
else if sale>=300 and sale<400 then newsalary=salary+1000;
else newsalary=salary;
proc print data=emp3;
run;
data emp4;
set es;
if sale>=500 then rating='A+++';
else if sale>=400 and sale<500 then rating='A++';
else if sale>=300 and sale<400 then rating='A+';

proc print data=emp4;
run;

No comments:

Post a Comment