Hi, I have multiple tables coming from teradata. Example Table A , Table B , Table C  using these 3 tables ( joining -- left join using proc sql) I am creating one table suppose Table Final .   Now in my Table A , Table B and Table C I have one field as FLAG. So, Now i want to delete the records even if in any of the table A , B or C the field FLAG="N" .   that is in my Table Final i don't want records with FLAG="N".    the problem is that even if in any of the table it's N the record should be deleted.      SAMPLE DATA :   TABLE A           PHRM_SRVC_PROV_KEY PHRM_CLAIM_KEY CLM_ORG_FLAG_IND SRVC_DT PROD_SRVC_ID FLAG 125 1853 B 1-Jan-20 23155050110 Y 79 20022 B 5-Jul-20 11917004813 Y 138 10703 B 2-Mar-20 13107015790 N 153 2669 B 2-Apr-20 49884002101 N 90 6339 B 1-Feb-20 31722072250 Y   TABLE B             PHRM_SRVC_PROV_KEY CST_TYP_CD DRG_UNIT_CST PAY_TYP_IND INGR_BIL_CST INGR_SBMT_CST FLAG 125 MACHU 0.6478 P 0.05 25 Y 79 AWP 0.1999 P 4.9 25 Y 138 MACHU 2.973 P 6.95 25 N 153 MACHU 1.0836 P 5.86 50 N 90 MACHU 19.2878 P 8.01 10 Y   TABLE C         PHRM_SRVC_PROV_KEY INGR_SBMT_CST INGR_CALC_CST BIL_DSPNS_FEE FLAG 125 25 0.05 0.38 Y 79 25 4.9 0.38 Y 138 25 6.95 0.38 N 153 50 5.86 0.38 N 90 10 8.01 0.38 Y   TABLE FINAL PHRM_SRVC_PROV_KEY FLAG 125 Y 79 Y 90 Y   Hope any body helps me , thanks !! ... View more

hi , below is the small snippet :   %let year_month=202201; data try; temp=&year_month.-1; run; I want my temp to be 202112 not 202200 . Can you please help me in give a quick solution.   Thanks in advance ! ... View more

hi ,   PFB my SAS code where i want DaysCount which i have completed but could not figure out how i can generate ConsolidatedMonths ? ConsolidatedMonths -- Where the "days" field corresponding months should be populated.    Thanks in advance 🙂    data calendar; input Month $ Dates mmddyy8.; cards; MAR 03/04/18 MAR 03/13/18 MAR 03/18/18 MAR 03/25/18 APR 04/01/18 APR 04/08/18 APR 04/15/18 APR 04/22/18 APR 04/25/18 MAY 05/06/18 MAY 05/13/18 MAY 05/20/18 MAY 05/27/18 ; proc print; run; data out; set calendar; Days=day(Dates); run; proc sort data=out; by Days; run; Data out1; set out; by Days; retain DaysCount; if first.Days then DaysCount = 1 ; else DaysCount = DaysCount + 1; if last.Days then output; proc print; run; My current output is :   Obs Month Dates Days DaysCount 1 APR 21275 1 1 2 MAR 21247 4 1 3 MAY 21310 6 1 4 APR 21282 8 1 5 MAY 21317 13 2 6 APR 21289 15 1 7 MAR 21261 18 1 8 MAY 21324 20 1 9 APR 21296 22 1 10 APR 21299 25 2 11 MAY 21331 27 1     Expected Output :    Obs Month Dates Days DaysCount ConsolidatedMonths 1 APR 21275 1 1 APR 2 MAR 21247 4 1 MAR 3 MAY 21310 6 1 MAY 4 APR 21282 8 1 APR 5 MAY 21317 13 2 MAR,MAY 6 APR 21289 15 1 APR 7 MAR 21261 18 1 MAR 8 MAY 21324 20 1 MAY 9 APR 21296 22 1 APR 10 APR 21299 25 2 MAR, APR 11 MAY 21331 27 1 MAY ... View more