Hi Team,
I need a help in sas problem statement. I have a data set which I have attached in attachment below in which I have two question-
1, in attached file I have divide the amtspent into three categories- below 100, 100-200 and above 200 .
2. I want to count the number of unique customers in each group(using select case when)
I have tried below code but unable to find the solution-
proc sql;
create table want as
select custid
case
when amtspent = "below 100" then count(distinct custid)
when amtspent = "100-200" then count(distinct custid)
when amtspent = "above 200" then count(distinct custid)
else count(distinct custid)
end as "unique customer"
from grv
group by amtspent
quit;
run;
Please help