Thanks!   It works correctly, I have an additional problem. If I have more than one ID and the price is 0 in the first observation it puts the last price of the previous ID. How can I do this?   I need to have:   ID date price price2 a1 04Apr2016 9 9 a1 05Apr2016 0 9 a1 06Apr2016 0 9 a1 07Apr2016 0 9 a1 08Apr2016 8 8 a2 04Apr2016 0 0 a2 05Apr2016 0 0 a2 06Apr2016 7 7 a2 07Apr2016 0 7 a2 08Apr2016 0 7 ... View more

Thanks.    It works correctly for the first zero, if the variable have more than one zero, then the lag will be zero and I need it to be the last available price. As the following example, that the price is 8 for april 5 and as the next days don´t have prices I use that price.    id date price price_2 a1 05/04/2015 8 8 a1 06/04/2015 0 8 a1 07/04/2015 0 8 a2 08/04/2015 0 8 ... View more

Thank you very much! Is working now. Thanks! ... View more

Thank you very much Chris. I want to do a montecarlo simulation. Is there an alternative method. Thanks Paula ... View more

I  can use SAS code. I need to join to tables, the columns in table 1 changes all the time and I need to get always all the columns from table 1 and the ones from table to that are not in table 1. PROC SQL;    CREATE TABLE WORK.xxx(label="QUERY_FOR_CONTABILIDAD") AS    SELECT t1.xxx1,           t1.xxx2,    t1.xxx3,           t2.xxx11,    t2.xxx4                FROM WORK.QUERY_FOR_CONTABILIDAD_0001 t1            INNER JOIN WORK.COPIA_DE_LISTADO_DE_CUENTAS_CONT t2 ON (t1.Cuenta_contable = t2.CUENTA);     QUIT; The idea es I hope this more clear. Thanks! ... View more

Thank you very much. I tried. The problema when using PROC SQL is that I in table 2 I only have the values with 999999 in table 1. And when doing this I need to have al the variables in table 2. Another question, can I do this with more tan 2 tables? For instance take 3 variables from table 2, 5 from table 3, ... Thanks!! ... View more

Thank you very much. I have in the table1 25 variables in 6 of them I have the value 999999, in those cases I need to replace in the new table those values with the ones in table 2. I was not able to attach the tables. Have I explained better what I need? In your example "IDNO" is the name of the table? ... View more

Hi Naveen, Thanks for you reply. I need to merge two data sets. The merge is between 2 tables and I need to take the values ​​of Table 2 in case in Table 1 have in those places a specific value and in the rest of the cases take the values of Table 1. Do you understand? Thank you very much Maria ... View more