topic Search inquire in two columns? in SAS Programming

Search inquire in two columns?

ybz12003 — Thu, 01 Sep 2022 13:48:00 GMT

Hello,

I would like to raise a flag when the texts in 'Description' column are the same and the 'Class' are different. The final result should be at the rows, 1&3&4&5. Thanks.

data dataIN;
   infile datalines dsd;
   input Class : $50. Department  : $100. Description  : $100.;
   datalines;
	ICU,RESPIRATORY THERAPY, VENT OSCILLATOR CIRCUIT
	ICU,R&C/NURS UNIT, ROOM & CARE, PEDS ICU
	PF, EMERGENCY DEPT, VENT OSCILLATOR CIRCUIT
	Room, R&C/NURS UNIT, ED VISIT III
	Supply, EMERGENCY DEPT, ED VISIT III
;

Re: Search inquire in two columns?

PeterClemmensen — Thu, 01 Sep 2022 13:51:00 GMT

I don't understand this. Can you show us your desired result?

Re: Search inquire in two columns?

ybz12003 — Thu, 01 Sep 2022 14:44:58 GMT

I got an email back from Ksharp. His code is working. However, I could not find his message here. Thanks.

proc sql;
create table want as
select * from dataIN
 group by Description
  having count(distinct Class) >1 ;
quit;

Re: Search inquire in two columns?

PaigeMiller — Fri, 02 Sep 2022 11:11:41 GMT

Please test your code to provide data, and make sure it is working properly before you create your message. Your code to provide data does not work.

Re: Search inquire in two columns?

FreelanceReinh — Fri, 02 Sep 2022 14:00:52 GMT

Good catch, @PaigeMiller. I assume that @ybz12003's user interface (like the traditional Display Manager interface that I'm using) reads tabs as spaces so that the unwanted leading tab character in each data line went unnoticed.