https://communities.sas.com/t5/SAS-Data-Management/Infomap-Studion-and-distinct-rows/m-p/32075#M251 Thats the way. It works perfekt.<BR /> Thank You. Thu, 17 Mar 2011 13:40:19 GMT AndersBergquist 2011-03-17T13:40:19Z https://communities.sas.com/t5/SAS-Data-Management/Infomap-Studion-and-distinct-rows/m-p/32073#M249 I am trying to build an infomap. I have two tables, one with monthly data and one calender with everyday and corresponding month, quarter, year and some other carasteristicts.<BR /> <BR /> I join the months to be able to aggregate on quarters and years.<BR /> <BR /> The problem is the join will be perform on each day, which make the total aggregation about 30 times highter on yearly basis. <BR /> <BR /> My question, is there a way to make the calenderfile only input one month, like distinct rows in sql? Thu, 17 Mar 2011 12:11:40 GMT https://communities.sas.com/t5/SAS-Data-Management/Infomap-Studion-and-distinct-rows/m-p/32073#M249 AndersBergquist 2011-03-17T12:11:40Z https://communities.sas.com/t5/SAS-Data-Management/Infomap-Studion-and-distinct-rows/m-p/32074#M250 Is your month a SAS date column or a value describing the month number ?<BR /> <BR /> My guess is that you should join by a SAS date column containing i.e. the last day of the month. This way your data will not be 30 timer higher.<BR /> <BR /> Make a new column containing the date of the last day in the month - instead of your currently column that contains the month number - you will get the month from your calender table. Thu, 17 Mar 2011 12:55:22 GMT https://communities.sas.com/t5/SAS-Data-Management/Infomap-Studion-and-distinct-rows/m-p/32074#M250 GertNissen 2011-03-17T12:55:22Z https://communities.sas.com/t5/SAS-Data-Management/Infomap-Studion-and-distinct-rows/m-p/32075#M251 Thats the way. It works perfekt.<BR /> Thank You. Thu, 17 Mar 2011 13:40:19 GMT https://communities.sas.com/t5/SAS-Data-Management/Infomap-Studion-and-distinct-rows/m-p/32075#M251 AndersBergquist 2011-03-17T13:40:19Z