BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
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; Required output : a b 1 1 2 2 4 3
1 ACCEPTED SOLUTION

Accepted Solutions
srinath3111
Quartz | Level 8

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

View solution in original post

8 REPLIES 8
Kurt_Bremser
Super User

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.

Patrick
Opal | Level 21

@rajeshalwayswel

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;
rajeshalwayswel
Pyrite | Level 9
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
Kurt_Bremser
Super User

@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;
srinath3111
Quartz | Level 8

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

novinosrin
Tourmaline | Level 20
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;
rajeshalwayswel
Pyrite | Level 9

Thanks everyone.... From next time I'll post questions in proper way... Sorry for the inconvenience.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 8 replies
  • 955 views
  • 3 likes
  • 5 in conversation