topic Re: I need to count particular one and next all to another counts is can be done in any single step? in SAS Programming

I need to count particular one and next all to another counts is can be done in any single step?

rajeshalwayswel — Fri, 31 Aug 2018 10:08:40 GMT

 data have;
  input a $;
  cards;
  car
  bus
  jeep
  aeroplane
  maruti
run;

want:

 a    count
car   1
bus    1
other  3

Re: I need to count particular one and next all to another counts is can be done in any single step?

RW9 — Fri, 31 Aug 2018 10:26:38 GMT

proc sql;
  create table want as
  select  a,
          count(*) as count
  from    (select case when a not in ("car","bus") then "other" else a end as a from have)
  group by a;
quit;

But this is the same as simply categorising your data beforehand into the required output:

data have;
  length a $20;
  input a $;
  if a not in ("car","bus") then a="other";
cards;
car
bus
jeep
aeroplane
maruti
;
run;

Re: I need to count particular one and next all to another counts is can be done in any single step?

rajeshalwayswel — Fri, 31 Aug 2018 11:36:43 GMT

I have more then 10 records is any other way to do. Thanks for the response.

Re: I need to count particular one and next all to another counts is can be done in any single step?

andreas_lds — Fri, 31 Aug 2018 11:46:01 GMT

@rajeshalwayswel wrote:

I have more then 10 records is any other way to do. Thanks for the response.

Why is the number of records a problem?

Re: I need to count particular one and next all to another counts is can be done in any single step?

rajeshalwayswel — Fri, 31 Aug 2018 11:51:09 GMT

if a not in ("car","bus") then a="other";

if I use this step so I need to mention all the rest of them in the operators.

Re: I need to count particular one and next all to another counts is can be done in any single step?

andreas_lds — Fri, 31 Aug 2018 12:06:00 GMT

@rajeshalwayswel wrote:
if a not in ("car","bus") then a="other";
if I use this step so I need to mention all the rest of them in the operators.

So, after having a second look at the data you posted, you need to count the observations beginning with the third one, right?

Try:

data want;
   set have end=jobDone;

   retain count;

   if _n_ < 3 then do;
      count = 1;
      output;
      count = 0;
   end;
   else do;
      count = count + 1;
   end;

   if jobDone then do;
      a = 'other';
      output;
   end;
run;

Re: I need to count particular one and next all to another counts is can be done in any single step?

RW9 — Fri, 31 Aug 2018 13:01:34 GMT

Please post test data which describes your problem, I can only work with what you provide.

Re: I need to count particular one and next all to another counts is can be done in any single step?

Ksharp — Fri, 31 Aug 2018 13:33:02 GMT

data have;
  input a $;
  cards;
  car
  bus
  jeep
  aeroplane
  maruti
run;

proc format ;
value $fmt
 'car'='car'
 'bus'='bus'
 other='other';
run;

proc freq data=have;
table a /out=want;
format a $fmt.;
run;