About pankak

pankak · ‎05-25-2015

I have a dataset: id_acc info_date ov_credit ov_debit account_balance interest_rate_anuual 111 30june2007 500 700 6000 0.18% 111 31jul2007 500 600 6008 0.18% 111 31aug2007 500 200 8000 0.18% 111 30sep2007 300 100 7000 0.18% 111 31oct2007 400 300 9000 0.18% 111 30nov2007 200 400 10000 0.18% I want the ouput in the following manner.Please suggest ome logic account_bal1=account_balance+sum(ov_debit ,-ov_credit )+interest_rate_anuual; account_bal2=account_bal1+sum(ov_debit ,-ov_credit )+interest_rate_anuual; account_bal3=account_bal2+sum(ov_debit ,-ov_credit )+interest_rate_anuual; Please suggest some logic.

pankak · ‎05-10-2015

I have a dataset and i need to flag the sum their delinquency period and after that i need sum of each delinquent period. data have; infile datalines; input id_acc acc_no status_code $5. info_date date9. act_bal total_debt total_credit ; format info_date date9.; datalines; 1111 999585548 D1A 30Jun2007 500 1000 2000 1111 999585548 AAA 31Jul2007 500 1000 2000 1111 999585544 D1A 31Aug2007 400 5000 4600 1111 999585547 D2A 30Sep2007 500 1000 2000 1111 999585540 D1D 31Oct2007 300 1000 2000 1111 999585544 AAA 30Nov2007 500 1300 2000 1111 999585547 AAA 31Dec2007 500 1000 2000 1111 999585540 D1D 31Jan2008 500 1000 2000 1111 999585544 D2D 28Feb2008 200 1800 2000 1111 999585547 D3D 31Mar2008 500 1000 2000 1111 999585540 D4D 30Apr2008 500 1000 2000 1111 999585540 D5D 31May2008 500 1000 2000 1111 999585540 AAA 30Jun2008 500 1000 2000 1111 999585540 AAA 31Jul2008 100 2000 3000 1111 999595540 D1D 31Aug2008 200 1000 2000 1111 999587540 LEP 30Sep2008 500 1000 2000 1111 999587540 LEP 31Oct2008 500 1000 2000 1111 999585540 LEP 30Nov2008 500 1000 2000 1112 999505548 D2A 30Jun2007 500 1000 2000 1112 999505548 AAA 31Jul2007 400 1000 2000 1112 999505544 D1A 31Aug2007 500 1000 2000 1112 999505547 D2A 30Sep2007 500 1000 2000 1112 999505540 D1D 31Oct2007 500 1000 2000 1112 999505544 D2D 30Nov2007 500 1000 2000 1112 999505547 D3D 31Dec2007 700 1000 2000 1112 999505540 D4D 31Jan2008 500 1000 2000 1112 999505544 D5D 28Feb2008 500 1000 2000 1112 999505547 D6D 31Mar2008 500 1000 2000 1112 999505540 LEP 30Apr2008 500 1000 2000 1112 999505540 LEP 31May2008 800 1000 2000 1112 999505540 LEP 30Jun2008 500 1000 2000 1112 999505540 LEP 31Jul2008 500 1000 2000 1112 999505540 LEP 31Aug2008 500 1000 2000 1112 999505540 LEP 31Oct2008 900 1000 2000 1112 999505540 LEP 30Nov2008 500 1000 2000 ; run; proc print; run; The code i am using is: proc sort data=have; by id_acc info_date; run; %let del =_n_; data second; set have; if first.id_acc=1 and status_code in ('D1A','D2A','D1D','D2D','D3D','D4D','D5D','D6D') THEN do; balance_at_def=act_bal; delinquey=1; end; if first.id_acc=0 and status_code in ('D1A','D2A','D1D','D2D','D3D','D4D','D5D','D6D') THEN do; balance_at_def=act_bal; delinquey=&del; end; by id_acc info_date; run; Output: status_ total_ total_ net_ balance_ Obs id_acc acc_no code info_date act_bal debt credit charges at_def delinquey 1 1111 999585548 D1A 30JUN2007 500 1000 2000 -1000 500 1 2 1111 999585548 AAA 31JUL2007 500 1000 2000 -1000 . . 3 1111 999585544 D1A 31AUG2007 400 5000 4600 400 400 3 4 1111 999585547 D2A 30SEP2007 500 1000 2000 -1000 500 4 5 1111 999585540 D1D 31OCT2007 300 1000 2000 -1000 300 5 6 1111 999585544 AAA 30NOV2007 500 1300 2000 -700 . . 7 1111 999585547 AAA 31DEC2007 500 1000 2000 -1000 . . 8 1111 999585540 D1D 31JAN2008 500 1000 2000 -1000 500 8 9 1111 999585544 D2D 28FEB2008 200 1800 2000 -200 200 9 10 1111 999585547 D3D 31MAR2008 500 1000 2000 -1000 500 10 11 1111 999585540 D4D 30APR2008 500 1000 2000 -1000 500 11 12 1111 999585540 D5D 31MAY2008 500 1000 2000 -1000 500 12 13 1111 999585540 AAA 30JUN2008 500 1000 2000 -1000 . . 14 1111 999585540 AAA 31JUL2008 100 2000 3000 -1000 . . 15 1111 999595540 D1D 31AUG2008 200 1000 2000 -1000 200 15 16 1111 999587540 LEP 30SEP2008 500 1000 2000 -1000 . . 17 1111 999587540 LEP 31OCT2008 500 1000 2000 -1000 . . 18 1111 999585540 LEP 30NOV2008 500 1000 2000 -1000 . . 19 1112 999505548 D2A 30JUN2007 500 1000 2000 -1000 500 1 20 1112 999505548 AAA 31JUL2007 400 1000 2000 -1000 . . 21 1112 999505544 D1A 31AUG2007 500 1000 2000 -1000 500 21 22 1112 999505547 D2A 30SEP2007 500 1000 2000 -1000 500 22 23 1112 999505540 D1D 31OCT2007 500 1000 2000 -1000 500 23 24 1112 999505544 D2D 30NOV2007 500 1000 2000 -1000 500 24 25 1112 999505547 D3D 31DEC2007 700 1000 2000 -1000 700 25 26 1112 999505540 D4D 31JAN2008 500 1000 2000 -1000 500 26 27 1112 999505544 D5D 28FEB2008 500 1000 2000 -1000 500 27 28 1112 999505547 D6D 31MAR2008 500 1000 2000 -1000 500 28 29 1112 999505540 LEP 30APR2008 500 1000 2000 -1000 . . 30 1112 999505540 LEP 31MAY2008 800 1000 2000 -1000 . . 31 1112 999505540 LEP 30JUN2008 500 1000 2000 -1000 . . 32 1112 999505540 LEP 31JUL2008 500 1000 2000 -1000 . . 33 1112 999505540 LEP 31AUG2008 500 1000 2000 -1000 . . 34 1112 999505540 LEP 31OCT2008 900 1000 2000 -1000 . . 35 1112 999505540 LEP 30NOV2008 500 1000 2000 -1000 . . what i want to create one more variable net_sum: 1-sum of net_charges of delinquency sum(3,4,5) and subtract the first default_balance of that group from total sum. subsequently the sum of sum(8,9,10,11,12) and subtract the first default_balance of that group from total sum.

pankak · ‎05-07-2015

Hi It is the same output: 111 9586 aaa 30jun2007 111 9586 aaa 31jul2007 111 9586 d1a 31aug2007 111 9999 lep 30sep2007 111 9586 lep 30sep2007 111 9999 lep 31Oct2007 111 9586 lep 31Oct2007-delete this row 111 9999 lep 30Nov2007 111 9586 lep 30Nov2007-delete this row 112 9587 d1a 30jun2007 112 9587 aaa 31jul2007 112 9587 d2a 31aug2007 112 9587 d1d 30sep2007 112 9991 lep 31Oct2007 112 9587 lep 31Oct2007 112 9991 lep 30Nov2007 112 9587 lep 30Nov2007-delete this row 112 9991 lep 31Dec2007 112 9587 lep 31Dec2007-delete this row... So i want to delete these particular row and keep first occurance of dates where it goes into lep two time and rest only one time. output: 111 9586 aaa 30jun2007 111 9586 aaa 31jul2007 111 9586 d1a 31aug2007 111 9999 lep 30sep2007 111 9586 lep 30sep2007 111 9999 lep 31Oct2007 111 9999 lep 30Nov2007 112 9587 d1a 30jun2007 112 9587 aaa 31jul2007 112 9587 d2a 31aug2007 112 9587 d1d 30sep2007 112 9991 lep 31Oct2007 112 9587 lep 31Oct2007 112 9991 lep 30Nov2007 112 9991 lep 31Dec2007

pankak · ‎05-07-2015

I have a dataset in the following format with millions of observation. data test; infile datalines; input id_acc acc_no status info_date; datalines; 111 9586 aaa 30jun2007 111 9586 aaa 31jul2007 111 9586 d1a 31aug2007 111 9999 lep 30sep2007 111 9586 lep 30sep2007 111 9999 lep 31Oct2007 111 9586 lep 31Oct2007 111 9999 lep 30Nov2007 111 9586 lep 30Nov2007 112 9587 d1a 30jun2007 112 9587 aaa 31jul2007 112 9587 d2a 31aug2007 112 9587 d1d 30sep2007 112 9991 lep 31Oct2007 112 9587 lep 31Oct2007 112 9991 lep 30Nov2007 112 9587 lep 30Nov2007 112 9991 lep 31Dec2007 112 9587 lep 31Dec2007 I want the output as mentioned below. Only i want to keep the first two info_date when the card goes into lep and rest only one dates of lep. output: 111 9586 aaa 30jun2007 111 9586 aaa 31jul2007 111 9586 d1a 31aug2007 111 9999 lep 30sep2007 111 9586 lep 30sep2007 111 9999 lep 31Oct2007 111 9999 lep 30Nov2007 112 9587 d1a 30jun2007 112 9587 aaa 31jul2007 112 9587 d2a 31aug2007 112 9587 d1d 30sep2007 112 9991 lep 31Oct2007 112 9587 lep 31Oct2007 112 9991 lep 30Nov2007 112 9991 lep 31Dec2007

pankak · ‎05-06-2015

data have; infile datalines; input id_acc acc_no status_code $5. info_date; format info_date date9.; datalines; 1111 999585548 AAA 30Jun2007 1111 999585548 AAA 31Jul2007 1111 999585544 D1A 31Aug2007 1111 999585547 D2A 30Sep2007 1111 999585540 D1D 31Oct2007 1111 999585544 AAA 30Nov2007 1111 999585547 AAA 31Dec2007 1111 999585540 D1D 31Jan2008 1111 999585544 D2D 28Feb2008 1111 999585547 D3D 31Mar2008 1111 999585540 D4D 30Apr2008 1111 999585540 D5D 31May2008 1111 999585540 AAA 30Jun2008 1111 999585540 AAA 31Jul2008 1111 999595540 D1D 31Aug2008 1111 999587540 LEP 30Sep2008 1111 999587540 LEP 31Oct2008 1111 999585540 LEP 30Nov2008 1112 999505548 AAA 30Jun2007 1112 999505548 AAA 31Jul2007 1112 999505544 D1A 31Aug2007 1112 999505547 D2A 30Sep2007 1112 999505540 D1D 31Oct2007 1112 999505544 D2D 30Nov2007 1112 999505547 D3D 31Dec2007 1112 999505540 D4D 31Jan2008 1112 999505544 D5D 28Feb2008 1112 999505547 D6D 31Mar2008 1112 999505540 LEP 30Apr2008 1112 999505540 LEP 31May2008 1112 999505540 LEP 30Jun2008 1112 999505540 LEP 31Jul2008 1112 999505540 LEP 31Aug2008 1112 999505540 LEP 31Oct2008 1112 999505540 LEP 30Nov2008 1113 990005548 D1D 30Jun2007 1113 995005548 D2D 31Jul2007 1113 995050544 D3D 31Aug2007 1113 999500547 D4D 30Sep2007 1113 999500540 AAA 31Oct2007 1113 999500544 D1A 30Nov2007 1113 999580547 D2A 31Dec2007 1113 999580540 AAA 31Jan2008 1113 999580544 D1A 28Feb2008 1113 999580547 D2A 31Mar2008 1113 999580540 AAA 30Apr2008 1113 999580540 D1D 31May2008 1113 999585540 D2D 30Jun2008 1113 999585540 D3D 31Jul2008 1113 999585540 LEP 31Aug2008 1113 999585540 LEP 30Sep2008 1113 999585540 LEP 31Oct2008 1113 999585540 LEP 30Nov2008 ; run; proc print; run; /*I have transosed this data set in the following format:*/ id_acc 30Jun2007 --- 30Nov2008 1111 AAA--------------LEP 2222 AAA--------------LEP 3333 D1D--------------LEP NOW WHAT I WANT THE OUTPUT IN THE FOLLOWING FORMAT: how many instances the one id_acc remains in D1A to D1D,D2D TO D5D,D1D TO D1D (and so on) AND FINAL in LEP. OUTPUT BELOW: id_acc 30Jun2007 --- 30Nov2008 D1_START D1_END D2_START D2_END D3_START D3_END ......dnstart ...dnend lEP_START_END 1111 AAA--------------LEP 31Aug2007 31Oct2007 31jan2008 31may2008 31Aug2008 31Aug2008 30Sep2008 2222 AAA--------------LEP 31Aug2007 31Mar2008 30Apr2008 3333 D1D--------------LEP 30Jun2007 30Sep2007 30Nov2007 31Dec2007 28Feb2008 31Mar2008 31May2008 31Jul2008 31Aug2008

pankak · ‎05-05-2015

Hi Mark, Thanks for Help..I guess it might help me..

pankak · ‎05-05-2015

Hi Mark, I have around 5L id_acc and it is impossible to put condition for all. Thanks for your help.

pankak · ‎05-05-2015

Hi Mark, Below is the same question AS INITIAL WAS CONFUSING..SORRY FOR TAT: id_acc month1 month2 month3 month4 month5 month6 month7 month8 month9 month10: 111 D1D D2D AAA AAA D1A D2A AAA D1A D2A LEP 222 AAA D1D D2D D3D AAA AAA D1D D2D LEP LEP 333 D1D D2D D3D D4D D5D D6D D7D LEP LEP LEP Now I want the output in the below and only flag mentioned in last. id_acc month1 ---- month10 d1_start d1_end d2_start d2_end d3_start d3_end 111 month1 month2 month5 month6 month8 month9 222 month2 month4 month7 month8 ----- ---- 333 month1 month7 ---- ---- --- ---- Basically the month1 month2 are information dates for unique month and i need to calculate the amount beween different instances. The d1_start d1_end d2_start d2_end may go to multiple times(like dn_start dn_end ) till 93 month.

pankak · ‎05-04-2015

Hi Mark, for AAA we don't have to worry about it.. We have to find only those informatin date instances for each id where it encounters D and end in D or LEP.or aaa to lep eg. for id_acc 1111: id_acc account_status information_date start_flag1 end_flag1 start_flag_n end_flag_n; 1111 D1A 31Aug2007 31Aug2007 31Oct2007 31Jan2008 31May2008 For other id_acc the flag may be on more than 2 and it can be n. only three things to consider are: 1-when it starts in D and end in D series(it can go in subsequent D series and end in D series for same or different id_acc) 2-when it starts in D and end in L series.(it is fixed as it will not go out of L series after that) 3-when it starts in AAA and end in L series.(it is fixed as it will not go out of L series after that Hope it is clear now? Thanks for Help.

pankak · ‎05-04-2015

I have a data set below: data have: set test; id_acc account_number account_status information_date ; 1111 999585548 AAA 30Jun2007 1111 999585548 AAA 31July2007 1111 999585544 D1A 31Aug2007 1111 999585547 D2A 30Sep2007 1111 999585540 D1D 31Oct2007 1111 999585544 AAA 30Nov2007 1111 999585547 AAA 31Dec2007 1111 999585540 D1D 31Jan2008 1111 999585544 D2D 28Feb2008 1111 999585547 D3D 31Mar2008 1111 999585540 D4D 30Apr2008 1111 999585540 D5D 31May2008 1111 999585540 AAA 30Jun2008 1111 999585540 AAA 31Jul2008 1111 999595540 D1D 31Aug2008 1111 999587540 LEP 31Oct2008 1111 999585540 LEP 30Nov2008 1112 999505548 AAA 30Jun2007 1112 999505548 AAA 31July2007 1112 999505544 D1A 31Aug2007 1112 999505547 D2A 30Sep2007 1112 999505540 D1D 31Oct2007 1112 999505544 AAA 30Nov2007 1112 999505547 AAA 31Dec2007 1112 999505540 D1D 31Jan2008 1112 999505544 D2D 28Feb2008 1112 999505547 D3D 31Mar2008 1112 999505540 LEP 30Apr2008 1112 999505540 LEP 31May2008 1112 999505540 LEP 30Jun2008 1112 999505540 LEP 31Jul2008 1112 999505540 LEP 31Aug2008 1112 999505540 LEP 31Oct2008 1112 999505540 LEP 30Nov2008 1113 990005548 AAA 30Jun2007 1113 995005548 AAA 31July2007 1113 995050544 D1A 31Aug2007 1113 999500547 D2A 30Sep2007 1113 999500540 AAA 31Oct2007 1113 999500544 D1A 30Nov2007 1113 999580547 AAA 31Dec2007 1113 999580540 AAA 31Jan2008 1113 999580544 D1A 28Feb2008 1113 999580547 D2A 31Mar2008 1113 999580540 AAA 30Apr2008 1113 999580540 D2D 31May2008 1113 999585540 D4D 30Jun2008 1113 999585540 D5D 31Jul2008 1113 999585540 AAA 31Aug2008 1113 999585540 AAA 31Oct2008 1113 999585540 LEP 30Nov2008 1113 999585540 LEP 31DEC2008 I WANT THE OUTPUT AS MENTIONED BELOW: i want to calculate different spam of account status and flag their information date in the flag variable: Also the span may increase and depends upon the status of id_acc.(ignore the account number). When we fine LEP i.e L1_start then we have to keep as it is..no change. id_acc account_status information_date (d1_start d1_end) (d2_start d2_end) (d3_start d3_end) (d4_start d4_end) (L1_start_end) (a_start L_end) 1111 D1A 31Aug2007 (31Aug2007-31Oct2007) (31Jan2008-31May2008) (31Aug2008-31Aug2008) --- 31Aug2008 --- ---- 1112 D1A 31Aug2007 (31Aug2007-31Oct2007) (31Jan2008-31Mar2008) --- --- 30Apr2008 --- -- - 1113 D1A 31Aug2007 (31Aug2007-30Sep2007) (30Nov2007-30Nov2007) (28Feb2008-31Mar2008) (31May2008-31Jul2008) (31Oct2008 30Nov2008)

pankak · ‎05-03-2015

I have a transposed dataset in the following manner: id_acc info0 info1 info2 info3 info4 info5 info6 info7 info8 info9 info10 info11 info12 info13 info14 info15 info16 info17 info18 info19 info20 info21 111 AAA AAA AAA D1A D2A D3A AAA AAA AAA AAA AAA D1A D2A D3A LEP LWP LEP LWP LEP LWP LEP LEP 222 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 223 AAA AAA AAA D1A D2A AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA D1A D2A D3A ISP LEP 224 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 225 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 226 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 227 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 228 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 229 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 231 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 232 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 233 D1A D2A AAA D1A AAA AAA D1A D2A D1D D2D D3D D4D D5A D6D AAA AAA AAA ISP LEP LWP LEP LEP 234 D1A D2A AAA D1A AAA AAA D1A D2A D1D AAA AAA AAA AAA AAA AAA AAA ISP LEP LWP LEP LEP ISP Now what kind of flag i need is mentioned as follows: 1. when it was in (D1A or D1D ) and not in other info to (D3A or D6D) as (dstart and dend).value will be 1. 2 when it was in (D1A or D1D )and not in other info to (LEP or ISP orLWP) as (dstart and Lend) value will be 1. 3.when it was in AAA and not in other info to (ISP,LEPor LWP) as (astart and lend) and value will be 1 There might be more scenarios but i have to focus on three one. There are multiple unique id and more info apart from that. So please show me some global method so that i can apply on whole dataset. Thanks, Pankaj

pankak · ‎04-29-2015

Thank you all..I will try these methods and let see if we are good to go

pankak · ‎04-29-2015

Hi All, I want to do it through do loop or arrays.. I have so many variables like nfo ,ifo1 ...info200 and so on Please help like that only if possible..

pankak · ‎04-28-2015

i want to find only aaa from data set.. id info0 info1 info2 info3 info4 info5 info6 11 aaa aaa aaa aaa aaa aaa aaa 12 aaa aaa aaa aaa aaa aaa aaa 13 bb bb aaa bb aaa aaa aaa 14 bb bb aaa bb aaa aaa aaa 15 bb aa aaa bb aaa aaa aaa only contains data a: 11 aaa aaa aaa aaa aaa aaa aaa 12 aaa aaa aaa aaa aaa aaa aaa data b: 13 bb bb aaa bb aaa aaa aaa 14 bb bb aaa bb aaa aaa aaa 15 bb aa aaa bb aaa aaa aaa

pankak · ‎04-18-2015

i have a credit card data which i have transposed in the following format.The values shows the status of that account in that period of time. aaa- active account authorise d1-d4- delinquent lep,lwp,lrp,isp- legal below is the sample. data check; infile datalines; input acc_id sta_dt1 $6. sta_dt2 $6. sta_dt3 $6. sta_dt4 $6. sta_dt5 $6. sta_dt6 $6. sta_dt7 $6. sta_dt8 $6. sta_dt9 $6. sta_dt10 $6. sta_dt11 $6. sta_dt12 $6. sta_dt13 $6. sta_dt14 $6. sta_dt15 $6.; datalines; 1111 aaa aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa d1 aaa 1112 d1 aaa aaa d1 aaa d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1113 aaa aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1114 aaa aaa aaa d1 d2 d3 d4 aaa aaa d1 d2 d3 aaa aaa d1 1115 aaa aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1116 d1 aaa aaa aaa d1 d2 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1117 aaa aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1118 lep lep lwp lwp lwp lwp lwp lwp lwp lwp lwp lrp lrp isp isp 1119 aaa aaa aaa d1 d2 d3 aaa d1 aaa d1 d2 d3 aaa aaa aaa 1122 d1 aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1123 aaa aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1124 d1 aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1118 d1 aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 aaa aaa aaa aaa 1119 aaa aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1122 d1 aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1123 aaa aaa aaa d1 d2 d3 aaa d1 aaa d1 d2 d3 aaa aaa aaa 1124 d1 aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa d1 1118 d1 aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1119 aaa aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1122 d1 aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1123 aaa aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 aaa aaa aaa 1124 d1 aaa aaa d1 d2 d3 aaa aaa aaa d1 d2 d3 d4 aaa aaa run; 1=what i want is to flag those account when their status are changed from ['(d1-d4)']to ['aaa']and ['aaa' ] to '(d1-d4)' and ['aaa'or '(d1-d4)'] to (lep,or lrp,or isp ) 2=want the cycle_counts as how many times it changes in 7 years of times(here it is 15 month.) as i will apply the code. 1.['(d1-d4)']to ['aaa'] 2.['aaa' ] to '(d1-d4)' 3.['aaa'or '(d1-d4)'] to (lep,or lrp,or isp ). 4.no changes as it may be in aaa or (lep or lrp or isp).

Online Status	Offline
Date Last Visited	‎09-19-2015 04:37 PM

Need Help in summarising data by commulating total

Hi Team,I need help o solving below senario

Re: Hi All,Please help me in solving the below scenario

Hi All,Please help me in solving the below scenario

I need help on this

Re: Hi All Please some ways to solve this scenario?

Re: Hi All Please some ways to solve this scenario?

Re: Hi All Please some ways to solve this scenario?

Re: Hi All Please some ways to solve this scenario?

Hi All Please some ways to solve this scenario?

Re: IF ONE VARIBLE HAVE A DIFFRENT DATE FORMAT

Need Help in summarising data by commulating total

Hi Team,I need help o solving below senario

Re: Hi All,Please help me in solving the below scenario

Hi All,Please help me in solving the below scenario

I need help on this

Re: Hi All Please some ways to solve this scenario?

Re: Hi All Please some ways to solve this scenario?

Re: Hi All Please some ways to solve this scenario?

Re: Hi All Please some ways to solve this scenario?

Hi All Please some ways to solve this scenario?

Hi All ..Can anyone show me as how to make flag in the following datas...

Re: Please do some help on this,,...

Re: Please do some help on this,,...

Please do some help on this,,...

Need suggestion and help.