if ~(("&sampdate"d<='16sep2006'd) and ("&PERFDATE"d>='16sep2006'd) and (DATE_CREDIT_LIMIT_CHG='16sep2006'd)); is this meaning   any one of the following: 1. ("&sampdate"d<='16sep2006'd) 2. ("&PERFDATE"d>='16sep2006'd) 3. (DATE_CREDIT_LIMIT_CHG='16sep2006'd) is not true?   ... View more

Proc SQL; create table acct_list_cen_limit_2A as select org_code, account_no, LOGO, card_type, relationship_no, date_Credit_limit_chg as Date_Credit_limit_chg, ratio, p_credit_limit*Ratio as p_credit_limit, IND_CENTRAL_LIMIT, FIRST_DEFAILT, SAMP_OS, SAMP_CRLIM*RATIO as SAMP_CRLIM, PBI_BALANCE as PBI_BALANCE, DEFAULT_AMT AS DEFAULT_AMT, SAMP_CRLIM_ALL*RATIO AS SAMP_CRLIM_ALL, MONTH_DEF AS MONTH_DEF, PORTFOLIO AS PORTFOLIO, REL_CNT AS REL_CNT FROM ACCT_LIST_CEN_LIMIT_2; QUIT; Why are some variables being renamed to the same name? what does this mean? ... View more

data seta; input apple banana; datalines; 1 1 2 2 3 3 run; proc sort data=seta; by apple; run; data setb; input apple orange lemon pear; datalines; 11 11 11 11 22 22 22 22 1 2 3 4 run; proc sort data=setb; by apple; run; data outina; merge seta (in=a) setb; by apple; run; data outnoth; merge seta setb; by apple; run; proc print data=seta; run; proc print data=setb; run; proc print data=outina; run; proc print data=outnoth; run; I am getting exact same result for with or without (in=a), why? I was believing (in=a) is like a left join... where only observations  with apple =1,2,3 would be included...         ... View more

string = COLLATE(1,256); high4=substr(string,55); APPLICANT_ID=translate(sup_id_no,high4,string); sup_id_no=translate(sup_id_no,high4,string); EMAIL=translate(EMAIL,high4,string); looks like the above code is doing some masking or decryption... am I right? What exactly are they trying to do?  Are they reversible?   ... View more

data &Portofo._VAL2(keep=MOB_VAL_P MOB); set &Portofo._VAL; by MOB; if first.MOB then CNT=0; CNT+1; MOB_VAL_P=CNT/&total_val; if LAST.MOB; run; does CNT means CNT+1? what is the line 'by MOB' doing here? what does it do?   ... View more

data &Portoffo._VAL(keep=MOB DQ_6); set monthly.score_&Portofo._VAL(keep=account_no CURR_DELQ MONTH_ON_BOOK bad); where bad in ('1' '0'); run; I cannot find 'bad' column in my dataset month.score_&Portofo., could it be created by the clause 'where bad in ('1' '0');   or it has to be from dataset month.score_&Portofo.??       ... View more

proc sql; create table mthbal_bal as select mthbal_org as ambs_org, mthbal_acct as ambs_acct, mthbal_curr_bal as mthend_bal, mthbal_crlim, intnx("month", a.mthbal_load_Dt,0,"E") as mthend_date from mthbal a, acct_new_all b where a.mthbal_org=b.org_code and a.mthbal_acct=b.account_no; quit; what kind of program is this? looks like 'join' but without saying what the join is? what is it doing? ... View more

Hi when i use join for two table i know i van use select a. b. To specify where to get the table. For example Select a.apple a.lemon b.size b.colour weight origin from fruit a left join info b on a.cost=b.cost But what if I have some variable where no a. Or b like weight and origin in the above Next to it, how do i know where these variAble is from? ... View more