Arthur! Thank you so much! sorry for the late reply, but im not always working on SAS, your explanation was very helpful, although i dont completely understood it, but it worked perfect! if instead of _ct+count ..i use _ct+sum ..or _ct+ any other function...would it work? What is the logic of using the operator + with a column? and i dont understand very well what do you mean with "that will only have a value of 1 when the last record from have is read " Anyway...you have been very helpful...I really appreciate ! Greetings, Milenko ... View more

slchen, Your code worked great! Thanks! But I have one more doubt. Is there a way to modify your code in order to count more than one column? I mean, becuase I have three more columns with numbers and I want to have a row in the end with the totals of each one of those columns. Can it be done? Milenko ... View more

Thank you so much Tom! I will try to do that! Greetings! Milenko ... View more

It worked perfectly! Thank you so much slchen! Greetings! Milenko ... View more

slchen, Thank you again! I tried the code and it still has problems with the C parameter: ERROR: The SUM summary function requires a numeric argument. ERROR: The following columns were not found in the contributing tables: C Could you help me with this error, please! Greetings! Milenko ... View more

Hey Tom! Thank you so much again! It is really helpful! I tried your code and it worked! But im almost there. The result that I get is this: DATA COUNT _TYPE_ _FREQ_ name DATA 1 23 DATA 2 35 DATA 3 27 DATA 4 24 DATA 5 25 DATA 6 22 DATA 7 29 - 185 0 7 Total And the result that Im looking foward is this: DATA COUNT DATA 1 23 DATA 2 35 DATA 3 27 DATA 4 24 DATA 5 25 DATA 6 22 DATA 7 29 Total 185 Is there a way to tweak your code to make it happen?  In any case you already have helped me a lot! Thank you! Greetings! Milenko ... View more

Cynthia! Thank you so much! But I dont need to do a report.  I want to create another data set, and I will keep working with it, applying functions, etc.In any case, I really appreciate your help.! Greetings! Milenko ... View more

Tom! Thank you very much! But I dont want to do a report, I want create another data set. I want to create another data set, and i will keep working with it, applying functions, etc.In any case, I really appreciate your help.! Greetings! Milenko ... View more

Hai.Kuo! Thank you very much for your answer. Im new in using SAS, so i dont understand very well the code that you are giving me. I foyu could walk me a bit, it would great! I do know what you mean with data want and data have, but the rest is not really understandable for my level of knowledge, which is pretty basic. In any case, I really appreciate for your help! Greetings! Milenko ... View more

slchen! Thank you for your answer! Im new in using SAS, and I know very little, I tried your code, and it didnt work...it says that the Ttotal, sum columns dont exist, and that the sum functions needs a numeric value. Here it is the code that Im using: data WORK.FILA_FINAL_COUNT; set WORK.query_for_query_final; run; proc sql;   insert into WORK.FILA_FINAL_COUNT   select Ttotal as data,sum(C) as count from WORK.query_for_query_final; quit; It would be great if you could tell me what Im doing worng. Greetings, and thanks again! Milenko ... View more