topic Re: How can I get the below result with following data in SAS Programming

How can I get the below result with following data

Vimal1010 — Fri, 18 Aug 2023 12:25:11 GMT

Please help me to get the below output from the input data using SAS datastep or proc sql:

Input Data:

ID	Value
1	ABC
1	Others
1	Others
2	Others
2	Others
3	ABC
3	ABC
3	ABC
4	ABC
4	Others
5	Others

Output:

ID	Value
1	Hybrid
2	Others
3	ABC
4	Hybrid
5	Others

Re: How can I get the below result with following data

mkeintz — Fri, 18 Aug 2023 12:56:24 GMT

I have a good idea of how you might do this, but you have not specified the rule you wish to use to generate the displayed output from the sample input.

Please state the rule you want to apply - which of course is the first step in generating appropriate SAS code.

Re: How can I get the below result with following data

Vimal1010 — Fri, 18 Aug 2023 13:01:55 GMT

So basically, if common value is there related to an ID then that value should be there with distinct ID in output table, similarly if different values are there for an ID then in output Hybrid should be published with that distinct ID.

Re: How can I get the below result with following data

Kurt_Bremser — Fri, 18 Aug 2023 13:04:58 GMT

data want;
do until (last.id);
  set have;
  by id;
  if value ne lag(value) and not first.id then flag = 1;
end;
if flag then value = "Hybrid";
drop flag;
run;

Re: How can I get the below result with following data

mkeintz — Fri, 18 Aug 2023 13:17:28 GMT

@Vimal1010 wrote:

So basically, if common value is there related to an ID then that value should be there with distinct ID in output table, similarly if different values are there for an ID then in output Hybrid should be published with that distinct ID.

Thank you. I think this code does what you want:

data want (drop=_:);
  set have;
  by id value notsorted;
  if first.id then _nvalue=1;
  else if first.value then _nvalue+1;
  if last.id;
  if _nvalue>1 then value='Hybrid';
run;

Re: How can I get the below result with following data

Vimal1010 — Fri, 18 Aug 2023 13:29:45 GMT

Thank you!