Hi,
proc sql;
create table final as
select a,
count(a) as COUNT
from l
group by a;
quit;
data ds;
set l;
by a b;
keep a count;
retain count 0;
if first.a=1 then count=1;
else count=sum(count,1);
if last.a=1 then output;
run;
Thanks,
srinath
Could you PLEASE post your code properly, like this:
data l;
input a b;
cards;
1 1
2 2
2 3
3 .
3 .
3 .
3 .
;
run;
It's not rocket science, really.
Please state if the code above is what you intended.
Assuming "sure...." means yes, that's how I intended to post my code.
data l;
input a b;
cards;
1 1
2 2
2 3
3 .
3 .
3 .
3 .
;
run;
proc sql;
create table want as
select a, b, count(*) as cnt
from l
group by a,b
;
quit;
I have data set need to count column b values how many times it repeated in column a data l; input a b; cards; 1 1 2 2 2 3 3 . 3 . 3 . 3 . run; output : a b 1 1 2 2 4 3
@rajeshalwayswel wrote:
I have data set need to count column b values how many times it repeated in column a data l; input a b; cards; 1 1 2 2 2 3 3 . 3 . 3 . 3 . run; output : a b 1 1 2 2 4 3
Try this:
proc sql;
create table want as
select count(*) as a, a as b
from l
group by a;
quit;
Hi,
proc sql;
create table final as
select a,
count(a) as COUNT
from l
group by a;
quit;
data ds;
set l;
by a b;
keep a count;
retain count 0;
if first.a=1 then count=1;
else count=sum(count,1);
if last.a=1 then output;
run;
Thanks,
srinath
data have;
input a b;
cards;
1 1
2 2
2 3
3 .
3 .
3 .
3 .
run;
proc sql;
create table want as
select a,count(a) as b
from have
where a in (select b from have)
group by a;
quit;
Thanks everyone.... From next time I'll post questions in proper way... Sorry for the inconvenience.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.