Date:         Wed, 29 Jul 2009 06:22:15 -0400
Reply-To:     Mark Marquez <sickpurple@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mark Marquez <sickpurple@GMAIL.COM>
Subject:      Joining tables problem

hi all,

i have a simple problem in joining tables. my code is this:

PROC SQL;
      CREATE TABLE WORK._BIL_TERM_LOAN AS
      SELECT
        A.SAS_SOC_CDE,
        A.DUE_DTE,
        CASE
          WHEN B.NEW_REF_NO NE "" THEN
            B.NEW_REF_NO
          ELSE
            A.REF_NO
          END AS REF_NO,
        A.ACC_NO,
        A.ACC_NO_INTERNAL,
        A.FCYFLUCT,
        A.FCYBRTYP,
        A.INTREVED,
        A.ACC_PRINCIPAL_PAID_AMOUNT,
        A.REPAYMENT_TERM,
        A.USANCE_DAY,
        A.LOFCBALN,
        A.LOFBBALN,
        A.CCY_CDE,
        A.LOHKCUSL,
        A.LOHKBANL,
        A.ACCINT_FL,
        A.ACCINT_FL_CUST,
        A.SUSINT_FL,
        A.INTERATE,
        A.REPAYMTD,
        A.NOFINSTL,
        A.REPAYPER,
        A.REPAYAMT,
        A.INT_RATE_SIGN,
        A.FCYRLOAD,
        A.RECORD_STATUS,
        A.EUSANCEF,
        A.CREATE_DATE,
        A.HIBOR_RATE_SIGN,
        A.FCYRLOAD_HIBOR,
        A.GOV_GUAR_RATIO,
        A.REF_NO AS OLD_ACC_NO,
        A.LAST_UPDTE_DTE
      FROM HDATA.BIL_TERM_LOAN A
      LEFT JOIN MAP.BLS_MAPPING B
        ON
          A.REF_NO = B.OLD_REF_NO
      ;
    QUIT;




now i want the code to join tables even if 2 or more variables are missing
as long ast its not the joining key (REF_NO). pls help!!!