topic Re: Calculated Items with WHERE conditions in New SAS User

Calculated Items with WHERE conditions

Eitan123 — Mon, 10 May 2021 07:33:09 GMT

Hey, I'm a bit new to SAS.
One of my SAS users asked me to create a calculated item which could be used for campaigns in Customer Intelligence Studio in order to define certain populations.

The item can be translated to the following MS SQL querry:

select count(*)
from X
where 1=1
and DATE > getdate() - 30 * 6
and TYPE = 'A'

In other words, we need the amount of records of type A of the last half of the year.

I've managed to create an item that counts all records of table X, but:

1) I don't know how to include my WHERE conditions.

2) I don't know how to define the item as FLOAT (it will be a numerator of another item for percentage calculations).

Note:

a) The item must be created in Information Maps, not Customer Intelligence Studio.

b) I've been asked by the user to create a single item to be used in Customer Intelligence studio.

Re: Calculated Items with WHERE conditions

yabwon — Mon, 10 May 2021 08:50:18 GMT

About 1), try this:

data X;
  do I = 1 to 365;
    date = today() - I;
    do type = "A", "B";
      output;
    end;
  end;
run;


proc sql;
select count(*)
from X
where DATE > (today() - 30 * 6)
 and TYPE = 'A'
;
run;

About 2), it is already a "float" since SAS doesn't distinguish numeric types, they all are just "numbers".

Re: Calculated Items with WHERE conditions

Eitan123 — Mon, 10 May 2021 10:26:32 GMT

Hey yabwon,

about 1): where do I write this code? within the expression of the item in information maps?