LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2009, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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!!!


Back to: Top of message | Previous page | Main SAS-L page