i think i'd like to try something like the following instead of creating a new table each time?
Proc SQL;
DELETE * FROM ShipAlt.PricingInfo;
Proc SQL;
INSERT INTO ShipAlt.PricingInfo
/* with applicable code to input his code created a new table each time didn't it?
SELECT DISTINCT t1.NIIN, t2.STD_PRICE
FROM SHIPALT.FMPMIS t1
INNER JOIN CROSSREF.V_ITEMS_MECH t2 ON (t1.NIIN = t2.NIIN)
ORDER BY t1.NIIN;
/* this code created a new table each time and it seems to inheirit the datatypes and lengths from the FMPMIS table I will try to employ your put statement for the string value of nine characters but how to format a whole number and two position decimal in the second column of PrincingInfo?
... View more