DATA &Portfolio_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; hi can you let me know what does the statement "by MOB;" doing on the third row? what does it mean when it comes after set statement?  also should the "if last.MOB" statement put higher up? or it does not matter where it is positioned?  ... View more

data samp; set samp; if samp_ex="" then exclude='N'; else exclude='Y'; if samp_ex=""; run; can you let me know if the statement "if samp_ex="": means the data step only runs if samp_ex="" is true, ie samp_ex is null is true... is the data step the same if this if statement "if samp_ex" is place directly under "set samp;"   I am confused because: 1. I was thinking the statement after "if samp_ex="" " only runs when "if samp_ex="" is true. the statement after it is "run", does that mean the whole data step only runs when "if samp_ex="" is true, ie the statement if samp_ex="" then exclude='N'; else exclude='Y'; wouldnt run either if samp_ex is not null?   or if samp_ex="" then exclude='N'; else exclude='Y'; runs anyway as it is before "if sam_Ex-"""   2, I was told the "if samp_ex=""" or a where statement could be put anywhere in the data step and the data step only runs if the if statement is true or the where condition is fulfilled...    please kindly assist, thanks. also  ... View more

data fruit; merge apple and orange; by size; run; proc sort data=apple; by size; run; proc sort data=orange; by size; run; if I have the code above, is the sorting gonna be done after merging or it can automatically sort first as I am aware that is sas sorting must be done before merging .... unfortunately the code I am encounterin is like the above, I am puzzled if it needs changing or sas would do sorting before merging ... View more

hi if I have created a macro variable using the code included, how can I indicate this variable is a macro variable in other sas program? or the only time I will recall it is to using it as &total_dev where it is now a value assigned...   what I really mean is how to indicate a variable is macro but not calling it with & where a value is assigned..    proc sql noprint select distinct count(*) into :total_dev from &Portofo._dev; quit;   ... View more

%macro gen_base(Portofo,dev) data &Portofo._VAL (KEEP= MOB DQ_6); set monthly.score_&Portofo.(keep=account_no CURR_DELQMONTH_ON_BOOK bad); .... run; gen_base(old_gwic_others_&P_YYMMDD.,Gwic_old_others); Hi All I am having the above code and I am not sure what is the value of &Portofo._VAL on the second line , the data line. should it be old_gwic_others_&P_YYMMDD.? or old_gwic_others_&P_YYMMDD._VAL... and &dev would be "Gwic_old_others" ... View more

proc format; value scorefmt low-539 ="SCORE<540" 540-559="540<=SCORE<560" 560-579="560<=SCORE<580"; run; data Range; length SCORE_LBL $15. Sort_order 8.; SCORE_LBL="SCORE<540"; Sort_order=1;output; SCORE_LBL="540<=SCORE<560"; Sort_order=2;output; SCORE_LBL="560<=SCORE<580"; Sort_order=3;output; SCORE_LBL="580<=SCORE<600"; Sort_order=4;output; SCORE_LBL="600<=SCORE<620"; Sort_order=5;output; ; run; proc print data=Range; run; I have some proc format code. my question is, is the programs creating the variable SCORE_LBL  and Sort_order from nothing? there is no input data set and dataset Range is created. so What is happening in the proc format code? where does score_lbl or is it an assumption for later use if we feed in scores...? ... View more

SELECT A.*, CASE WHEN A.ORG CODE IN ('251' '301' '302' '303') THEN 'HKG' WHEN A.ORG_ CODE IN ('306' '307' '308' '309') THEN 'CHN' ELSE 'MAC' END AS PORTFOLIO, B.RELATIONSHIP NO, B.IND_CENTRAL AS IND_CENTRAL, B.PBI AS PBI_PIMIT, B.CREDIT_LIMIT AS SAMP_CRLIM, B.CURRENT_BAL AS SAMP_OS FROM ACCT_NEW_ALL A LEFT JOIN ACCT_LIST_SAMP B ON AR.ORG_CODE=B.ORG_CODE AND R.BCCOUNT_NO=B.ACCOUNT_NO; QUIT; I understand case when and left join but putting together I cannot understand especially the line end as portfolio, I thought normally case when finish at the word end, now it continues with as portfolio and more, could you help me to interpret? ... View more