Thanks your answer i will see that.   Sorry to question but the columns don't are organize by date. Variable is a format date and after tabulate function pass to numeric.    Thank you very much your help   EDIT: Could be done if my date has this format yearmonth, like 201701, 201702, 201703  ... View more

Very good.    It is possible to convert report to a sas7bdat? Or via excel and after convert to sas7bdat? ... View more

The main idea is create a table with a statistics monthly.   This data is an example. The real life is different and not many zeros will appear in that statistic.   Ok a little bit different i can modify to:   - How to create a table automatic with columns Month/Year? For example for 4 ou 5 years sequentially based on today date to past dates?.   - After that creation i can update the values in that month/year  for each name, because with freq function give me the values.   It is a good idea?   @RW9 Thanks your answer ... View more

Yes this is a solution. I try and put all my import in same data. It is not my goal but was a very good solution. Now i had to separate the data to have data independentaly.   Thank you all very much   Regards, Aleixo ... View more

Thanks your code, i like your code. I try it with some errors that i have to study. ... View more

I did that with filevar and statement SET to bring filenames to datasetp but the result was good for only 2 lines(2 observations) because that Set Work.INFORMATION had only 2 lines that was 2 files path. Do you see?     ... View more

Yes but call execute is in a datastep with set on FilesInFolder.   Where you call execute? Datastep in a datastep? I think is a wrong idea.     ... View more

Is better independently.   I try to put in a do while with no result, and try another way.   Good idea is to put in a datastep with the last name of the folder, like A or B. I have been difficulties to understand loop in SAS. Ina do while loop is easy but in a datastep not.     ... View more

when i change to datetime23. SAS put milliseconds to 000. And Now how i can put my variable milliseconds into the variable datetime23.?   data data_completa; set data; time_want=dhms(DATEPART(Datetime), HOUR(Datetime), MINUTE(Datetime), date(Datetime)); time_char=cats(put(time_want, datetime23.),':',Milliseconds); format time_want datetime16. run; But now i have a char with 18OCT17:15:13:02:100 and SAS does not admit a format datetime23.3 to time_char. The idea is time_char a variable type datetime23.3 or in this case datetime20.3 for example -> 30OCT17:04:20:03:100   Regards, Aleixo ... View more

WoW, It's amazing what you have done. So simple what you do, i am delighted. Worked very well.   I will try to understand how it really works the code and the loop. Thank you so much   Regards, Aleixo   ... View more

thank you ballardw.   I thought also about where statement but i had problems with repeated observations, like in Name repeated and like in ON Pr repeated with same name.     ... View more

Ok. Thank you all answers, seriously. I think the solutions are not what i want. I will be more specific: My data in a dataset that i have to try the code   data work.dados(label='Dados'); infile datalines dsd truncover; input Time:32. Name:$8. Tp:$1. Age:$3. Type:$2.; datalines4; 107,Joyce,B,OFF,Dj 110,Joyce,B,OFF,Dj 202,Jane,C,OFF,Dj 304,Alice,A,ON,Pr 476,Alice,A,OFF,Dj 546,Barbara,D,OFF,Dj 628,Carol,F,OFF,Dj 756,Mary,G,ON,Pr 858,Mary,F,ON,Pr 929,Mary,G,OFF,Dj 949,Thomas,I,ON,Pr 989,Thomas,I,OFF,Dj 1002,Jane,C,ON,Pr 1006,Jane,C,ON,Pr 1010,Jane,Z,ON,Pr 1100,Jane,C,OFF,Dj 1235,Thomas,A,ON,Pr 1240,Thomas,I,ON,Pr 1304,Thomas,I,OFF,Dj ;;;; The idea is calculate time difference between same "Name" with same "Tp" and OFF Dj  -> ON Pr (first in time(older), not second in time(newer)).   Attention Thomas has two calculations. And for example Joyce don't have correspond ON Pr in the table, so not need to calculate difference. Or for example Carol is only one observation, no need to calculate difference.   I can not use the names because could be hundreds of them xD. That why i try to do two do while statements to find all names needed. I know that It is very difficult to be efficient to do this.   Want 107,Joyce,B,OFF,Dj,0 110,Joyce,B,OFF,Dj,0 202,Jane,C,OFF,Dj,0 304,Alice,A,ON,Pr,0 476,Alice,A,OFF,Dj,172 546,Barbara,D,OFF,Dj,0 628,Carol,F,OFF,Dj,0 756,Mary,G,ON,Pr,0 858,Mary,F,ON,Pr,0 929,Mary,G,OFF,Dj,173 949,Thomas,I,ON,Pr,0 989,Thomas,I,OFF,Dj,40 1002,Jane,C,ON,Pr,0 1006,Jane,C,ON,Pr,0 1010,Jane,Z,ON,Pr,0 1100,Jane,C,OFF,Dj,98 1235,Thomas,A,ON,Pr,0 1240,Thomas,I,ON,Pr,0 1304,Thomas,I,OFF,Dj,64 If i understand how to code this work i will be happy and will improve my programming skills to a next level.   Sorry my last posts but to study programming we have to do work step by step, simple to complicated to achieve our final goal.   Regards, Aleixo ... View more