cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Augusto
‎03-12-2024
  • 89 Posts
  • 2 Likes Given
  • 1 Solutions
  • 4 Likes Received
About
SAS is a wonderful Tool.

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

by Obsidian | Level 7 in SAS Procedures
‎06-26-2019 12:16 PM
‎06-26-2019 12:16 PM
ow... sorry it was a mistake, please consider 2% for varejo also. ... View more

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

by Obsidian | Level 7 in SAS Procedures
‎06-26-2019 11:27 AM
‎06-26-2019 11:27 AM
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 ... View more

CALCULATE THE NEXT RESULT WITH THE PREVIOUS ONE - WITH TRICK

by Obsidian | Level 7 in SAS Procedures
‎06-26-2019 10:05 AM
‎06-26-2019 10:05 AM
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. ... View more

CALCULATE THE NEXT RESULT USING THE PREVIOUS ONE - WITH TRICK

by Obsidian | Level 7 in SAS Programming
‎06-26-2019 09:40 AM
‎06-26-2019 09:40 AM
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. ... View more

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

by Obsidian | Level 7 in New SAS User
‎06-25-2019 07:19 PM
‎06-25-2019 07:19 PM
 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 ... View more

Re: Using the previous result line to calcute the next

by Obsidian | Level 7 in SAS Programming
‎06-24-2019 12:30 PM
‎06-24-2019 12:30 PM
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); ... View more

Using the previous result line to calcute the next

by Obsidian | Level 7 in SAS Programming
‎06-24-2019 12:08 PM
‎06-24-2019 12:08 PM
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   ... View more

interation (previous line)

by Obsidian | Level 7 in SAS Procedures
‎06-15-2018 12:46 PM
‎06-15-2018 12:46 PM
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 ... View more

inverse transpose

by Obsidian | Level 7 in SAS Procedures
‎11-04-2015 07:40 AM
‎11-04-2015 07:40 AM
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    ... View more

replicate value (easy question)

by Obsidian | Level 7 in SAS Procedures
‎10-21-2015 01:07 PM
‎10-21-2015 01:07 PM
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 ... View more

Re: HELP WITH IMPORTING EXCEL FILE

by Obsidian | Level 7 in SAS Procedures
‎10-21-2015 11:40 AM
‎10-21-2015 11:40 AM
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.       ... View more

Re: HELP WITH IMPORTING EXCEL FILE

by Obsidian | Level 7 in SAS Procedures
‎10-21-2015 11:03 AM
‎10-21-2015 11:03 AM
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;     ... View more

Re: HELP WITH IMPORTING EXCEL FILE

by Obsidian | Level 7 in SAS Procedures
‎10-21-2015 10:39 AM
‎10-21-2015 10:39 AM
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. ... View more

Re: HELP WITH IMPORTING EXCEL FILE

by Obsidian | Level 7 in SAS Procedures
‎10-21-2015 09:56 AM
‎10-21-2015 09:56 AM
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.. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-12-2024 06:27 PM
Likes given to
View All
Likes from
View All
Quick links