sas2

data axn;
merge axn.stk000001(keep=date clpr rename=(clpr=clpr1))
axn.stk000002(keep=date clpr rename=(clpr=clpr2));
by date;
run;
proc print;

data prices;
merge shoes discounts;
by Type;
newprice=Price*(1-Adjustment);
run;
proc print;

 

data shoes;
input name: & $14. Type: & $8. Price;
cards;
Max Flight running 152.99
Zip Fit Leather walking 93.99
Zoom Airborne running 122.99
Light Step walking 83.99
Max Step Woven walking 85.99
Zip Sneak c-train 102.99
;

proc sort data=shoes; by type;

run;
proc print;

data discounts;
input Type:$7. Adjustment;
cards;
c-train 0.25
running 0.30
walking 0.20
;
run;
proc print;