SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Infomap Studion and distinct rows

Posts: 44

Infomap Studion and distinct rows

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.

I join the months to be able to aggregate on quarters and years.

The problem is the join will be perform on each day, which make the total aggregation about 30 times highter on yearly basis.

My question, is there a way to make the calenderfile only input one month, like distinct rows in sql?
SAS Employee
Posts: 160

Re: Infomap Studion and distinct rows

Is your month a SAS date column or a value describing the month number ?

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.

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.
Posts: 44

Re: Infomap Studion and distinct rows

Thats the way. It works perfekt.
Thank You.
Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation