HW6-Fall10 - transaction. b. A summary showing the total...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Math 338 Fall 2010 Name Kafai – HW 6 Due 11/8/2010 Data set EMPLOY contains: ID (employee number), GENDER, and DOB (date of birth). Data set PARTS contains: PART_NO and PRICE. Data set SALES contains: ID (employee number), TRANS (transaction number), PART_NO, and QUANTITY (for each sales call completed). Write a SAS program to read the data sets and a. A listing, sorted by ID, showing ID, the transaction number, and the total sale for each
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: transaction. b. A summary showing the total sale for each employee. c. A summary showing the total company sales for each GENDER. EMPLOY ID GENDER DOB 01 F 10/21/46 02 F 09/02/44 03 M 04/23/55 04 F 11/11/38 PARTS PART_NO PRICE 123 15 234 25 237 20 355 28 789 55 SALES ID TRANS PART_NO QUANTITY 03 1 234 5 03 1 123 9 03 2 237 4 01 1 355 5 01 1 234 3 01 1 123 9 01 2 355 5 02 1 237 11...
View Full Document

This note was uploaded on 09/19/2011 for the course MATH 338 taught by Professor Staff during the Spring '08 term at S.F. State.

Ask a homework question - tutors are online