Write a SAS program that uses the SAS tables below to achieve the following objective. You may assume that the VENDOR and AP_TRANS tables are part of the MYLIB library.

Objects - Produce a table showing the vendor number, vendor name, invoice number, invoice date and invoice amount for each accounts payable transaction. Sort this output by invoice number within vendor number. Produce a report for each vendor, showing vendor name, invoice number, invoice date and invoice amount. Give this output the title "Accounts Payable Invoice Report". Produce subtotals and totals. Format amounts currency with 2 decimal places.

?

VENDOR Field No. 1 12 2 AP TRANS Field Description Vendor number Vendor name Field Name VENDOR_NO VENDOR_NAME| Field No. Field Description Vendor number Invoice number 1234 2 3 4 Invoice amount Invoice date Field Name VENDOR_NO INVOICE NO INVOICE_DATE INVOICE AMOUNT