topic Output where subject does not have any MHTYPE = &quot;Medical History&quot; in SAS Programming https://communities.sas.com/t5/SAS-Programming/Output-where-subject-does-not-have-any-MHTYPE-quot-Medical/m-p/792497#M253924 <P>Need to to out the subjects that have not&nbsp;MHTYPE = "Medical History"</P><P>Source Data:</P><TABLE><TBODY><TR><TD>Source Data</TD></TR><TR><TD>Subject</TD><TD>InstanceName</TD><TD>MHTYPE</TD></TR><TR><TD>1036190</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036192</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR><TR><TD>1036192</TD><TD>Screening</TD><TD>MEDICAL HISTORY</TD></TR><TR><TD>1036192</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036193</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR><TR><TD>1036193</TD><TD>Screening</TD><TD>MEDICAL HISTORY</TD></TR><TR><TD>1036193</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036196</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR><TR><TD>1036196</TD><TD>Screening</TD><TD>MEDICAL HISTORY</TD></TR><TR><TD>1036196</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036197</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036197</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected output:</P><TABLE><TBODY><TR><TD>Expected output</TD></TR><TR><TD>1036190</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036197</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036197</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR></TBODY></TABLE> Wed, 26 Jan 2022 15:04:37 GMT tsureshinvites 2022-01-26T15:04:37Z Output where subject does not have any MHTYPE = "Medical History" https://communities.sas.com/t5/SAS-Programming/Output-where-subject-does-not-have-any-MHTYPE-quot-Medical/m-p/792497#M253924 <P>Need to to out the subjects that have not&nbsp;MHTYPE = "Medical History"</P><P>Source Data:</P><TABLE><TBODY><TR><TD>Source Data</TD></TR><TR><TD>Subject</TD><TD>InstanceName</TD><TD>MHTYPE</TD></TR><TR><TD>1036190</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036192</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR><TR><TD>1036192</TD><TD>Screening</TD><TD>MEDICAL HISTORY</TD></TR><TR><TD>1036192</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036193</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR><TR><TD>1036193</TD><TD>Screening</TD><TD>MEDICAL HISTORY</TD></TR><TR><TD>1036193</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036196</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR><TR><TD>1036196</TD><TD>Screening</TD><TD>MEDICAL HISTORY</TD></TR><TR><TD>1036196</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036197</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036197</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected output:</P><TABLE><TBODY><TR><TD>Expected output</TD></TR><TR><TD>1036190</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036197</TD><TD>Screening</TD><TD>SURGICAL HISTORY</TD></TR><TR><TD>1036197</TD><TD>Screening</TD><TD>VACCINE HISTORY</TD></TR></TBODY></TABLE> Wed, 26 Jan 2022 15:04:37 GMT https://communities.sas.com/t5/SAS-Programming/Output-where-subject-does-not-have-any-MHTYPE-quot-Medical/m-p/792497#M253924 tsureshinvites 2022-01-26T15:04:37Z Re: Output where subject does not have any MHTYPE = "Medical History" https://communities.sas.com/t5/SAS-Programming/Output-where-subject-does-not-have-any-MHTYPE-quot-Medical/m-p/792525#M253939 <PRE><CODE class=" language-sas">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; </CODE></PRE> <PRE>Subject InstanceName MHTYPE 1036190 Screening SURGICAL HISTORY 1036197 Screening SURGICAL HISTORY 1036197 Screening VACCINE HISTORY </PRE> Wed, 26 Jan 2022 16:26:00 GMT https://communities.sas.com/t5/SAS-Programming/Output-where-subject-does-not-have-any-MHTYPE-quot-Medical/m-p/792525#M253939 maguiremq 2022-01-26T16:26:00Z Re: Output where subject does not have any MHTYPE = "Medical History" https://communities.sas.com/t5/SAS-Programming/Output-where-subject-does-not-have-any-MHTYPE-quot-Medical/m-p/792531#M253941 <P>Thanks a lot, it works fine, Program is simple but effective. You support is really appreciated.</P> Wed, 26 Jan 2022 16:38:22 GMT https://communities.sas.com/t5/SAS-Programming/Output-where-subject-does-not-have-any-MHTYPE-quot-Medical/m-p/792531#M253941 tsureshinvites 2022-01-26T16:38:22Z