Hello all   I run a SAS query and when I get the data set I export it to excel and manually manipulate the data. I also use formulas to create new columns in the dataset. I was hoping someone would be able to help me do that within my SAS query if its possible that it can be done.   In the attached spreadsheet, there are two columns (light colored headings), that I add to the other two columns. The UNIQ DOS column was created by using the excel formula =IF(D1=D2,0,1).  It shows when the BEGDATE changes within the same MEMNO grouping. If its the same date as the date above it within the same MEMNO grouping it populates the cell with a 0, if the BEGDATE changes within the same MEMNO grouping it populates the cell with a 1.   The column labeled DATE COUNT does a cumulative count of all the 1's within the MEMNO grouping. That number is ascertained using the excel formula =COUNTIF($A$2:A2,A2). Can these formulas and data manipulations be done within the SAS query?   Any assistance would be greatly appreciated.   Thanks ... View more

Hello all   I have a data set that includes upwards to 50 columns and I want the data to be sorted based on three of those columns. I have tried the following but it doesnt seem to work. Any help would be appreciated.   PROC SQL; CREATE Table Results as Select * from step2 WHERE MSG1 NOT IN ('HP_CC_EXACT_DUP','HP_DC_COB_EOP_MIS','HP_DC_COB_REC_INACTV','HP_DC_ILR_SUS_WC', 'HP_DC_PR_FL','HP_EXCL_OON_PROV','HP_ILR_SUS_Q_NO_RTN','HP_MAN_DENY_BILLED_INCORR','HP_MAN_DENY_DUPE', 'HP_MAN_DENY_MISMATCH_SERV','HP_MAN_DENY_VEND_AUDIT','HP_MAN_MEHN_PROV_DUPBILL','HP_MAN_NDM_PRV_MSSNG_MPIN_OR_NPI', 'HP_MAN_NOREF','HP_MAN_PAY_COOR_NOPAYPRIMARY','HP_MBRST_AUTH','HP_NDM_NOMATH_RATE_EXHIBIT','CLA-FL-BENS-018', 'HP_NDM_PRV_ACTV_AFT_END_EFF','HP_NDM_PRV_TERM_B4_STRT_EFF','HP_PRC_DU','HP_PRC_FQ','HP_PRC_QW','CLA-FL-PPRI-002', 'HP_PRC_VO','HP_PRC_ZT','CLA-FL-BENS-033','HP_COVG_NOCOVER_0002','HP_AUTH_NOTFOUND_NOB_OON','HP_COVG_NOCOVER_0003', 'HP_HARD_REF_EXCEED_NOB_IN','HP_HARD_REF_NOTFOUND_IN_HMO','HP_MAN_MSUP_NO_EOMB','HP_DC_ILR_OTR_CARRIER_MEM_LIAB', 'HP_MAN_NOREF','HP_MBRST_AUTH','HP_NDM_NOMATH_RATE_EXHIBIT','HP_MAN_DENY_COB_ROLLUP','HP_MAN_DENY_DATE_NOT_ON_EOB', 'HP_DC_ILR_SUS_MVA','HP_DC_PCP_CONSULT','HP_DC_REPROCESS_PENALTY','HP_LIM_UNIT_EXCEED','HP_MAN_DENY_APPEAL_FL_EXCEED', 'HP_MAN_DENY_NO_AUTH','HP_MAN_DENY_VEND_DUPE','HP_MAN_DENY_VEND_UPHOLD_DENIAL','HP_MAN_MA_AUTO_PRIME','HP_PRC_25', 'HP_PRC_42','HP_PRC_73','HP_PRC_73_NOT_CONTR','HP_PRC_CD','HP_PRC_H9','HP_PRC_PG','HP_PRC_PU','HP_REF_NOTFOUND_IN', 'HP_CD_ANCCLM_FACILITY','HP_CD_PRIMDENYTOANC_FACILITY','HP_DC_COB_DONE','HP_DC_COB_FL_NONNH','HP_DC_INVLD_BILL_TYPE', 'HP_DC_ME_FL','HP_DC_MED_COB_DONE','HP_LIM_COVDOL_EXCEED','HP_LIM_WHD_EXCEED','HP_LIM_WHD_MET','HP_LIM_WHD_METEXCEED', 'HP_MAN_CLAIM_REPLACED','HP_MAN_DENY_COBFL','HP_MAN_DENY_COBNOTACCEPT','HP_MAN_MBR_MISSING_INFO','HP_MAN_MSUP_PROV_DUPBILL', 'HP_MAN_PAY_APPEAL_REVERSED','HP_PRC_25_PROC','HP_PRC_BILATERAL_SPLIT_LINES','HP_PRC_EM','HP_PRC_EM_UNCL_SURGERY', 'HP_PRC_LATE_CHARGE','HP_PRC_MAN_ZERO_CLMLN_QTY','HP_PRC_MANUALLY_PRICED','HP_PRC_QS','HP_PRC_REPLACED','HP_PRC_ZERO_CLAIMLINE_QTY' 'CLA-FL-BENS-001','HP_CC_NPT_EXC','HP_CC_SUS_DUP','HP_DC_INVLD_PROC_REV_CD','HP_LIM_WHD_NOTMET','HP_MAN_PAY_VEND_AUDIT', 'HP_PRC_BILLED_UNITS','HP_PRC_M7','HP_PRC_T3','HP_PRC_TP_ICES_DENY','HP_PRC_TP_ICES_PAY','HP_PRC_TP_NON_ICES_DENY', 'HP_PRC_TP_NON_ICES_PAY','HP_REPLACEMENT_CLM_INVLD_DCN','XX') order by memno, begdate, APPL_FULL_SVC_NBR; quit; ... View more

Hello all. I am trying to create this Macro   %LET CODE = svc.BILL_SVC_UNIT_1_CD >= 'L0220' and svc.BILL_SVC_UNIT_1_CD <='L4631' and svc.BILL_SVC_UNIT_1_CD = '97760';   I have tried putting parenthesis around it in various ways but it still doesnt work. It will work if I took off the 97760 portion but I need that. The only other option is to include each and every  L code which as one can see is a considerable amount.   Any assistance would be greatly appreciated.   Thanks ... View more