Output where subject does not have any MHTYPE = "Medical History"

[tsureshinvites]

Need to to out the subjects that have not MHTYPE = "Medical History"

Source Data:

Source Data
Subject	InstanceName	MHTYPE
1036190	Screening	SURGICAL HISTORY
1036192	Screening	VACCINE HISTORY
1036192	Screening	MEDICAL HISTORY
1036192	Screening	SURGICAL HISTORY
1036193	Screening	VACCINE HISTORY
1036193	Screening	MEDICAL HISTORY
1036193	Screening	SURGICAL HISTORY
1036196	Screening	VACCINE HISTORY
1036196	Screening	MEDICAL HISTORY
1036196	Screening	SURGICAL HISTORY
1036197	Screening	SURGICAL HISTORY
1036197	Screening	VACCINE HISTORY

Expected output:

Expected output
1036190	Screening	SURGICAL HISTORY
1036197	Screening	SURGICAL HISTORY
1036197	Screening	VACCINE HISTORY

[maguiremq · Accepted solution]

data have;
infile datalines delimiter = ",";
input Subject :$8. InstanceName :$10. MHTYPE :$25.;
datalines;
1036190,Screening,SURGICAL HISTORY
1036192,Screening,VACCINE HISTORY
1036192,Screening,MEDICAL HISTORY
1036192,Screening,SURGICAL HISTORY
1036193,Screening,VACCINE HISTORY
1036193,Screening,MEDICAL HISTORY
1036193,Screening,SURGICAL HISTORY
1036196,Screening,VACCINE HISTORY
1036196,Screening,MEDICAL HISTORY
1036196,Screening,SURGICAL HISTORY
1036197,Screening,SURGICAL HISTORY
1036197,Screening,VACCINE HISTORY
;
run;

proc sql;
	create table 	want as
		select
					*
		from
					have
		where
					subject not in	(
										select
													 subject
										from
													have
										where
													mhtype = "MEDICAL HISTORY"
									);
quit;

Subject InstanceName MHTYPE 
1036190 Screening SURGICAL HISTORY 
1036197 Screening SURGICAL HISTORY 
1036197 Screening VACCINE HISTORY 

[tsureshinvites]

Thanks a lot, it works fine, Program is simple but effective. You support is really appreciated.