proc sql

Manojahuja1418 — Mon, 06 May 2019 16:08:28 GMT

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

Re: proc sql

PGStats — Mon, 06 May 2019 17:40:26 GMT

Proper syntax would be:

proc sql;
create table want as
select 
    amtspent,
    count(distinct custid) as uniqueCustomers
from grv
group by amtspent;
quit;

(untested)

topic proc sql in SAS Studio

proc sql

Re: proc sql