PROC SQL; CREATE TABLE WORK.PTNT_PAYOR AS SELECT DISTINCT E.SPCLTY_PHMCY_PHMCY_ID, datepart(E.ORDR_HDR_FILL_DT) format=mmddyy10. as FILL_DATE, E.RX_RX_NB AS PRESCRIPTION_NUMBER, E.PTNT_ID AS PATIENT_ID, E.PTNT_FIRST_NM, E.PTNT_LAST_NM, E.ORDR_HDR_ORDR_TYPE, E.ORDR_DTL_DRUG_DSPNS_QTY, SUM(E.ORDR_DTL_DRUG_DSPNS_QTY) FORMAT=8. AS TOTAL_QTY, UPCASE(E.PRODUCT_DESC_1) AS PRODUCT_DESC FROM SASUSER.SPCLTY_PTNT_DETAIL E WHERE E.PAYOR_LVL_1_LOW_ID IN('IBMSHAZ1C','PENNSPA2C','NQR-NQRH','WELLSFA1C','FEPPBM01C') GROUP BY E.SPCLTY_PHMCY_PHMCY_ID, E.PTNT_ID ORDER BY E.SPCLTY_PHMCY_PHMCY_ID, E.PTNT_ID; QUIT; There are 300 records in the file. I did not try proc means yet. will give it a try Thanks
... View more