About Augusto

Augusto · ‎06-26-2019

ow... sorry it was a mistake, please consider 2% for varejo also.

Augusto · ‎06-26-2019

Reeza, please use the attrition field to decrease. retain acc_whithout_attrition attrition_to_new_segment; if safra eq 1 then acc_whithout_attrition = qt_account_initital - (qt_account_initital * attrition); else acc_whithout_attrition = acc_whithout_attrition - (acc_whithout_attrition * attrition); for the attrition_to_new_segment, please consider: qt_account_initital - acc_whithout_attrition; The TRICK is that what is decreased from the AFFLUENT line, needs to be added to the Varejo

Augusto · ‎06-26-2019

Hi, Please someone can solve this issue ? Its need to calculate the next result using the previous one. HAVE segment month safra qt_account_initial attrition varejo 30/06/2019 1 100 2,00% varejo 31/07/2019 2 100 2,00% varejo 31/08/2019 3 100 2,00% affluent 30/06/2019 1 80 0,00% affluent 31/07/2019 2 80 0,00% affluent 31/08/2019 3 80 0,00% WANT segment month safra qt_account_initial attrition new_qt_account acc_whithout_attrition attrition_to_new_segment varejo 30/06/2019 1 100 2,00% 98,00 98,00 2,00 varejo 31/07/2019 2 100 2,00% 96,04 96,04 3,96 varejo 31/08/2019 3 100 2,00% 94,12 94,12 5,88 affluent 30/06/2019 1 80 0,00% 82,00 82,00 0,00 affluent 31/07/2019 2 80 0,00% 85,96 82,00 0,00 affluent 31/08/2019 3 80 0,00% 91,84 82,00 0,00 The TRICK is : THE attrition_to_new_segment result needs to be added to the AFFLUENT Segment line before the its calculation. Please, use SAFRA EQ 1 for the condition to the first iteration. I could get the calculation using the retain, but could not solve the trick.

Augusto · ‎06-26-2019

Hi, Please someone can solve this issue ? Its need to calculate the next result using the previous one. HAVE segment month safra qt_account_initial attrition varejo 30/06/2019 1 100 2,00% varejo 31/07/2019 2 100 2,00% varejo 31/08/2019 3 100 2,00% affluent 30/06/2019 1 80 0,00% affluent 31/07/2019 2 80 0,00% affluent 31/08/2019 3 80 0,00% WANT segment month safra qt_account_initial attrition new_qt_account acc_whithout_attrition attrition_to_new_segment varejo 30/06/2019 1 100 2,00% 98,00 98,00 2,00 varejo 31/07/2019 2 100 2,00% 96,04 96,04 3,96 varejo 31/08/2019 3 100 2,00% 94,12 94,12 5,88 affluent 30/06/2019 1 80 0,00% 82,00 82,00 0,00 affluent 31/07/2019 2 80 0,00% 85,96 82,00 0,00 affluent 31/08/2019 3 80 0,00% 91,84 82,00 0,00 The TRICK is : THE attrition_to_new_segment result needs to be added to the AFFLUENT Segment line before the its calculation. Please, use SAFRA EQ 1 for the condition to the first iteration. I could get the calculation using the retain, but could not solve the trick.

Augusto · ‎06-25-2019

Any Help ?

Augusto · ‎06-25-2019

Hello, I wroted a question that was solved and i'm very grateful for this. (Using the previous result line to calcute the next) Now, I still in problem with a new calculating. I have to calculate a result using the previous result. HAVE: segment month safra qt_account_initial attrition_a attrition_b perc_affluent varejo 30/06/2019 1 100 2,00% 2,00% 10,00% varejo 31/07/2019 2 100 2,00% 2,00% 10,00% varejo 31/08/2019 3 100 2,00% 2,00% 10,00% affluent 30/06/2019 1 80 2,00% 2,00% 0,00% affluent 31/07/2019 2 80 2,00% 2,00% 0,00% affluent 31/08/2019 3 80 2,00% 2,00% 0,00% WANT: segment month safra qt_account_initial attrition_a attrition_b perc_affluent new_acc_initial acc_whitout_attrition_a acc_whitout_attrition_b acc_whitout_affluent qt_add_affluent varejo 30/06/2019 1 100 2,00% 2,00% 10,00% 100,00 98,00 96,04 86,44 9,60 varejo 31/07/2019 2 100 2,00% 2,00% 10,00% 86,44 84,71 83,01 74,71 8,30 varejo 31/08/2019 3 100 2,00% 2,00% 10,00% 74,71 73,22 71,75 64,58 7,18 affluent 30/06/2019 1 80 2,00% 2,00% 0,00% 89,60 87,81 86,06 86,06 0,00 affluent 31/07/2019 2 80 2,00% 2,00% 0,00% 94,36 92,47 90,62 90,62 0,00 affluent 31/08/2019 3 80 2,00% 2,00% 0,00% 97,80 95,84 93,92 93,92 0,00 TO CALCULATE THE NEW COLUMNS: new_acc_initial acc_whitout_attrition_a acc_whitout_attrition_b acc_whitout_affluent qt_add_affluent Condition for the first iteration : IF SAFRA EQ 1 THEN new_acc_initial = qt_account_initial; NOTE: The trick is to add the qt_add_affluent result when its filled into the affluent segment line

Augusto · ‎06-24-2019

Hi.. sorry, i forgot a condition. If safra eq 1 then account_whitout_attrition = account - (account * attrition); Else account_whitout_attrition = (previous result) - (account * attrition);

Augusto · ‎06-24-2019

Hello, I need an help. I have to calculated a result using the previous result. HAVE: month_base segment safra account attrition 31/01/2019 4k 1 54,00 2% 28/02/2019 4k 2 54,00 2% 31/03/2019 4k 3 54,00 2% 30/04/2019 4k 4 53,00 3% 31/01/2019 Affluent 1 75,00 2% 28/02/2019 Affluent 2 75,00 2% 31/03/2019 Affluent 3 75,00 2% 30/04/2019 Affluent 4 75,00 4% WANT: To create a new column called account_without_attrition: This is calculated by the previous result : month_base segment safra account attrition account_without_attrition 31/01/2019 4k 1 54,00 2% 52,92 28/02/2019 4k 2 54,00 2% 51,84 31/03/2019 4k 3 54,00 2% 50,76 30/04/2019 4k 4 53,00 3% 49,17 31/01/2019 Affluent 1 75,00 2% 47,67 28/02/2019 Affluent 2 75,00 2% 46,17 31/03/2019 Affluent 3 75,00 2% 44,67 30/04/2019 Affluent 4 75,00 4% 41,67

Augusto · ‎06-15-2018

Hello, I need to create a data set like that bellow. where variable "a" need to be the value of the previous value of the variable "c" and so on. b = a * anual/12; safra a b c anual 1 45.483.247.875 0 45.483.247.875 2,97% 2 45.483.247.875 112.571.038 45.370.676.837 2,97% 3 45.370.676.837 112.292.425 45.258.384.411 2,97% 4 45.258.384.411 112.014.501 45.146.369.910 2,97% 5 45.146.369.910 111.737.266 45.034.632.644 2,97% Thanks

Augusto · ‎11-04-2015

Hello Guys, Can someone write a code to get the folIowing result (TABLE WANT) ? Its a kind inverse transpose that we are used to do. This is the table that i have. data have; input group $ fields $ jan commax5.2 feb commax5.2 marc commax5.2; datalines; food cheap 1,22 1,55 2,38 food expens 3,02 3,33 4,38 food averag 2,12 2,42 3,23 drink cheap 1,42 1,25 1,38 drink expens 5,04 4,31 5,01 drink averag 3,26 2,42 3,21 ; run; This is the result that i need. data want; input group $ calc $ month $ value commax5.2; datalines; food cheap jan 1,22 food cheap feb 1,55 food cheap marc 2,38 food expens jan 3,02 food expens feb 3,33 food expens marc 4,38 food averag jan 2,12 food averag feb 2,42 food averag marc 3,23 drink cheap jan 1,42 drink cheap feb 1,25 drink cheap marc 1,38 drink expens jan 5,04 drink expens feb 4,31 drink expens marc 5,01 drink averag jan 3,26 drink averag feb 2,42 drink averag marc 3,21 ; run; I apprecciate any help for that. Thanks

Augusto · ‎10-21-2015

i need to replicate the value of the previos line (_n_ - 1) to line (_n_), could anyone code it. ex. data have ; input n field $; cards ; 1 y12 2 . 3 . 4 b98 5 . 6 . 7 . ; run ; data want; set have; n field 1 y12 2 y12 3 h12 4 b98 5 b98 6 b98 7 b98 run; please, consider that this table (have) cannot be ordered Thanks

Augusto · ‎10-21-2015

The exercise was to import the excel file by proc import and create the columns asked using the best way, but the most important was to replicate the value of the Destino column. I took a look at the documentation, but sorry, i still not solve the problem.. would you mind coding it? The Descritpion column has values for the first ocurrence only until the next different ocurrence (like in excel pivot table) I need to replicate the value of the id (previous) until the next ocurrence.

Augusto · ‎10-21-2015

TO SUM UP THE ISSUE: DATA HAVE; Contrapartida Destino CR Historico Conta: 81703 - DESP . . 12E43 . 133 INTEGR 12E43 . 133 INTEGR 12E43 . 133 INTEGR Conta: 817035 - DESP2 . . 12E44 . 134 INTEGR 12E44 . 134 INTEGR 12E44 . 134 INTEGR ... run; ----- i Need to replicate the value of the Destino column until the next ocurrence DATA WANT; Contrapartida Destino CR Historico 12E43 81703 - DESP 133 INTEGR 12E43 81703 - DESP 133 INTEGR 12E43 81703 - DESP 133 INTEGR 12E44 817035 - DESP2 134 INTEGR 12E44 817035 - DESP2 134 INTEGR 12E44 817035 - DESP2 134 INTEGR .. run;

Augusto · ‎10-21-2015

Hi RW9, thanks for participating, I took a look at the post you mentioned, but its not the same issue i have. The issue is not the proc import. The trick is to create the table that is needed with the such informat infile. I need a help to create it.

Augusto · ‎10-21-2015

Hi PaigeMiller, thanks for your response. In fact, i would like a help with this proc import code... if you can write de code, i ll be grateful..

Re: CALCULATE THE NEXT RESULT WITH THE PREVIOUS ONE - WITH TRICK

Re: CALCULATE THE NEXT RESULT WITH THE PREVIOUS ONE - WITH TRICK

CALCULATE THE NEXT RESULT WITH THE PREVIOUS ONE - WITH TRICK

CALCULATE THE NEXT RESULT USING THE PREVIOUS ONE - WITH TRICK

Re: Using the previous result line to calcute the next - QUESTION 2

Using the previous result line to calcute the next - QUESTION 2

Re: Using the previous result line to calcute the next

Using the previous result line to calcute the next

interation (previous line)

inverse transpose

replicate value (easy question)

Re: HELP WITH IMPORTING EXCEL FILE

Re: HELP WITH IMPORTING EXCEL FILE

Re: HELP WITH IMPORTING EXCEL FILE

Re: HELP WITH IMPORTING EXCEL FILE