I am having an issue where I am getting duplicate line output. I am pretty sure it is how I have my case statements situated, but I cannot seem to find a solution for this.
proc sql;
create table work.test as
select distinct
ID,
Name,
CASE
when Active in ('Y') then 'YES'
else 'NO'
end as Active_Flag,
CASE
when IDENTIFIED in ('Y') then count(distinct Flags)
else 0
end as IDENTIFIED_Count,
CASE
when ONLINE in ('Y') then count(distinct Flags)
else 0
end as ONLINE_Count,
count(distinct GOAL) as Goal_Count
I would think that this would give me 2 lines of output. Which would be something like this.
ID Name Active_Flag IDENTIFIED_Count ONLINE_Count Goal_Count
1 Test_Account Y 12 42 53
1 Test_Account N 12 42 53
What I am getting is something like this
ID Name Active_Flag IDENTIFIED_Count ONLINE_Count Goal_Count
1 Test_Account Y 12 0 0
1 Test_Account Y 12 42 0
1 Test_Account Y 12 0 53
1 Test_Account Y 12 42 53
1 Test_Account N 12 0 0
1 Test_Account N 12 42 0
1 Test_Account N 12 0 53
1 Test_Account N 12 42 53
... View more