Hi, I have a big problem trying to find a solution for a requirement... I've come to think that it's not possible to do. I have 2 tables showing almost the same information. One is institucional info and another client info (I've attached bot of them in excel format because I had to change some confidential info). Well, my problem is: The idea is compare is some clients are copying institutional behavior... how? I have to check if any client from opsmesclient has made at least half of same operations of any institution from opsmesinst. Each register is a operation. For example, for institution 00117138 I have to find if any client have made at least half of same operations (id column). 00117138 has 39 operations, has any client 20 same operations??? . If there is a coincidence I have to made a flag to identify them or create a table with the coincidence or any way to identify them. I hope you could help me because I have no idea how to do this comparison. Thank very much. ... View more

Hi, I want to create a variable to count the number of values greater than 0 and another one for values less than 0. This is my code, but it is not working for the first register of the category. data work.cb_dc6; set work.cb_dc5; by block; if (dif>=0) then posi+1; if (dif<0) then nega+1; if first.block then posi=0 and nega=0; run; Look register #1 CRETEXT1, column posi should begin with 1 no 0. Same problem with register 10 ALICORC1, register 10 for nega column should be 1: any idea? Thanks in advance! ... View more

Hi, I'm concatenating 5 variables in only one string variable that has a lenght of 40-50 characters, but SAS displays only the 2 first variables. How could I do to see all the lenght? This is my code: data work.cf_vcv2; set work.cf_vcv1; cross=cats(tiporden,isin,tim,dat,precioneg); run; the output only show tiporden and isin concatenated.:smileyconfused: ... View more