topic Re: Information Map - Advanced Filter in SAS Programming

Information Map - Advanced Filter

wrosario — Thu, 13 Feb 2014 12:05:15 GMT

I am needing to create an advanced filter while the information map, the filter would be a prompt for an initial period least 365 days, you have any suggestions?

Re: Information Map - Advanced Filter

Madelyn_SAS — Thu, 13 Feb 2014 15:25:52 GMT

Can you provide more detail about your goal?

Re: Information Map - Advanced Filter

wrosario — Thu, 13 Feb 2014 15:50:19 GMT

I am creating a filter within the information map that you can bring me the last 12 months of a certain amount, but to know the last 12 months the user will have to enter a month, then the only way I'll figure out who are the last 12 months.

Prompt: Fev - 2014

Result Report

Month Profit

Fev-14 15

Jan-14 10

Dez-13 28

Nov-13 30

Out-13 15

Set-13 30

Ago-13 20

Jul-13 20

Jun-13 20

May-13 20

Apr-13 20

Mar-13 20

Tks for all

Re: Information Map - Advanced Filter

RainB — Fri, 14 Feb 2014 09:58:26 GMT

Hi,

The solution little bit depends how the date data item is used in your information map.

What I tried and maybe helps you is this(I used dummy data for testing).

data library.test_data;

input mon date9. value;

datalines;

01Feb2014 15

01Jan2014 10

01Dec2013 28

01Nov2013 30

01Oct2013 15

01Sep2013 30

01Aug2013 20

01Jul2013 20

01Jun2013 20

01May2013 20

01Apr2013 20

01Mar2013 20

;

Then in the information map studio I defined mon data item as "Date" type and used format EURDFMY and called it DataItem1.

Next I created filter that looks like this:

And when I test this filter, I get this selection:

and results are here:

Kind Regards,

Rain

Re: Information Map - Advanced Filter

wrosario — Fri, 14 Feb 2014 16:14:03 GMT

Rain,

The problem is that the second date (to) not being in accordance with the first choice, it is always based on the current date minus the number of months in crate side.

Example:

From Date: Dez 14

To Date: N Months ago (Feb 14, Jan 14, Dez 14, Nov 14, Oct 14 , Sep 14 )

right would

From Date: Dez 14

To Date: N Months ago (Dez 14, Nov 14, Oct 14 , Sep 14, Ago 14 )

Tks

Re: Information Map - Advanced Filter

RainB — Mon, 17 Feb 2014 09:05:58 GMT

wrosario wrote:

Rain,

The problem is that the second date (to) not being in accordance with the first choice, it is always based on the current date minus the number of months in crate side.

Example:

From Date: Dez 14

To Date: N Months ago (Feb 14, Jan 14, Dez 14, Nov 14, Oct 14 , Sep 14 )

right would

From Date: Dez 14

To Date: N Months ago (Dez 14, Nov 14, Oct 14 , Sep 14, Ago 14 )

Tks

Hi again,

Your requirement is something that I am not sure can be achieved- dynamic calculation. Or maybe someone else with more knowledge can help you out.

Rain