Hi everyone,   I'm creating a new column on a step DATA SET that I'm working on that intends to have the content of a column that already exists, but actually what SAS is making is to return the name of those columns that already exists. But to supply my needs in my proccess I need to make the SAS unsderstand that I really want are the contents. The image below show the result that I'm having:     Here's the code that I'm using:   DATA TABELA_HISTORICA_2; SET TABELA_HISTORICA; SEGM_PJ_P12M = "SEGM_PJ_"||PUT(YEAR(INTNX('MONTH',FECHAPER_STRT,12,'E')),z4.)||PUT(MONTH(INTNX('MONTH',FECHAPER_STRT,12,'E')),Z2.);   RUN;   And below are the results that I'm expecting to have:   Does anyone know any change that I'd do on the code that I provided to reach the expected results ?   Thanks in advance.     ... View more

Hi everyone, I'm working with informations about customers along 136 months. What I'm working on is an specific information about those customers that express a situation that can from a month to another. With this data in hands I'm building a report to specify the duration (in months) of each situation.   For example, concatenating all these situation for an hypothetic customer we would have:   customer_historic='00000666668888888888880000000000000000777777777777777777770000000006666666'   At first I could say that on the first five months the situation was 0 and lasted for 5 months. And since the 6th month the situation began to be 6, and it lasted for 5 months as well. And then, from the 11th month it started to be 8, and it lasted for 8 months .....     But, using formulas, I just can identify the beginning of this sequence, which could be done using:   FIRST_NUMB_SEQUENCE = INDEX(customer_historic,'0'); Which the result would be FIRST_NUMB_SEQUENCE = '1'.   Does anyone know a way to identify when, along the sequence, the digit starts to be different from 6 ? Is possible to do that using INDEX function ?   Or an alternative way.   Thanks in advance.     ... View more

Hi all,   I have one ID column and twelve others columns that have monthly information of profit before taxes, which i will call here as PBT. My aim is to create twelve new columns with the year to date information of PBT, which means ((cumulated information up to intended date)/(number of months up to intended date))*12, all this in on single file. I already did this in different files using ARRAY through the code below within a MACRO statement:   DATA CUM_PBT_&MONTH. (DROP=i); SET PBT_2018; FORMAT PBT_YTD_&MONTH. COMMA19.2; ARRAY PBT[*] '201801'n-"&MONTH."n; DO i=1 to 12; PBT_YTD_&MES.=(SUM(of '201801'n-"&MES."n)/DIM(BAI))*12; END; RUN;   How could I provide this code to have all these columns in a same file ?   To illustrate better what I want I attached a file that i did my objective (beggining at column 'O') information using excel from the original information (from column B to M). ... View more