Try SQL Passthru. That's exactly like using SQL Developer:
proc sql;
connect using myora;
execute (
INSERT INTO Customer_t (customerid, customername, customeraddress, customercity, customerstate, customerpostalcode) VALUES (100, 'Cool Future', '123 Lake Side Drive', 'Ithaca', 'NY', '14850')
) by myora;
run;
... View more
