Hello everyone, I'm a new user of SAS and I'm learning how to use it more and more each day so please I apologize if this is a basic question. I have built a process using SAS EG to help me identify turnover for our organization. In this process I need to calculate the total number of employees on average for a month. Below is a recap on what I have in the table: PROC SQL; CREATE TABLE WORK.QUERY_FOR_HISTAPPT AS SELECT t1.DATECRED, t1.DATECRED_DC, t1.DATE_EFF, t1.DATE_EFF_DC, t1.LEGISTCD, t1.OCC_CD, t1.OCCTITLE, t1.EMP_ID, t1.EMPNAME, t1.BUNITNO, t1.BUNITCD, t1.APPLOCCD, t1.SUBLOCCD, t1.POS_TYPE, t1.STUDTITL, t1.OCCGRADE, t1.position FROM HRMS.HISTAPPT t1 WHERE t1.DATECRED BETWEEN '20110630' AND '20110731' AND t1.EMP_ID NOT = '000000' AND t1.STUDTITL NOT = 'Y' AND t1.OCC_CD NOT IN ( '2903', '2472', '2902', '2460', '2441', '2442', '2476', '2443', '2478', '2950', '2901', '2487', '2907', '2471', '2479', '2464', '2465', '2473', '2440', '2463', '2445', '2448', '2908', '2906', '2475', '2904', '2474', '2461', '2462' ) AND t1.SUBLOCCD NOT = 'ACAD'; QUIT; Ok, So I am pulling in all employees in an appointed positions at the end of two months, so all records are in this one table. Now I want to see if I can get the average number of employees by position type for that timeframe. I can get the actual numbers in a summary table; however, the average is really what I need. Any help would be greatly appreciated! Thanks, Shannon
... View more