https://communities.sas.com/t5/SAS-Programming/Help-with-returning-one-row-per-id-by-collapsing-corrected/m-p/617943#M181168 <P>I have a data like this, attached.&nbsp; I would like to have a row per id that includes&nbsp; unduplicated info from other rows for all var in one row.</P><P>Desired table is something like this:</P><TABLE><TBODY><TR><TD>ID</TD><TD>ThroatPain</TD><TD>Dysuria</TD><TD>GenitalDischarge</TD><TD>RectalPain</TD><TD>AbdominalPain</TD><TD>Treatment</TD><TD>TreatmentRx</TD><TD>TreatmentRxOther</TD><TD>TreatmentRx2</TD><TD>TOC</TD><TD>SexAtBirth</TD></TR><TR><TD>773233</TD><TD>No</TD><TD>Yes</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>7/6/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>783394</TD><TD>No</TD><TD>No</TD><TD>No</TD><TD>Unknown</TD><TD>No</TD><TD>8/17/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>785878</TD><TD>No</TD><TD>No</TD><TD>No</TD><TD>Unknown</TD><TD>Yes</TD><TD>8/1/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>&nbsp;</TD><TD>Female</TD></TR><TR><TD>976906</TD><TD>No</TD><TD>No</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>11/27/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>976916</TD><TD>No</TD><TD>No</TD><TD>No</TD><TD>Unknown</TD><TD>No</TD><TD>11/29/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>&nbsp;</TD><TD>Female</TD></TR><TR><TD>979830</TD><TD>No</TD><TD>No</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>11/29/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>&nbsp;</TD><TD>Female</TD></TR><TR><TD>005182</TD><TD>No</TD><TD>Yes</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>12/12/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>005185</TD><TD>No</TD><TD>No</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>12/12/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>010768</TD><TD>No</TD><TD>No</TD><TD>No</TD><TD>Unknown</TD><TD>No</TD><TD>12/19/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>013588</TD><TD>No</TD><TD>Yes</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>12/15/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>&nbsp;</TD><TD>Male</TD></TR></TBODY></TABLE> Thu, 16 Jan 2020 21:49:12 GMT Dhana18 2020-01-16T21:49:12Z https://communities.sas.com/t5/SAS-Programming/Help-with-returning-one-row-per-id-by-collapsing-corrected/m-p/617943#M181168 <P>I have a data like this, attached.&nbsp; I would like to have a row per id that includes&nbsp; unduplicated info from other rows for all var in one row.</P><P>Desired table is something like this:</P><TABLE><TBODY><TR><TD>ID</TD><TD>ThroatPain</TD><TD>Dysuria</TD><TD>GenitalDischarge</TD><TD>RectalPain</TD><TD>AbdominalPain</TD><TD>Treatment</TD><TD>TreatmentRx</TD><TD>TreatmentRxOther</TD><TD>TreatmentRx2</TD><TD>TOC</TD><TD>SexAtBirth</TD></TR><TR><TD>773233</TD><TD>No</TD><TD>Yes</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>7/6/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>783394</TD><TD>No</TD><TD>No</TD><TD>No</TD><TD>Unknown</TD><TD>No</TD><TD>8/17/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>785878</TD><TD>No</TD><TD>No</TD><TD>No</TD><TD>Unknown</TD><TD>Yes</TD><TD>8/1/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>&nbsp;</TD><TD>Female</TD></TR><TR><TD>976906</TD><TD>No</TD><TD>No</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>11/27/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>976916</TD><TD>No</TD><TD>No</TD><TD>No</TD><TD>Unknown</TD><TD>No</TD><TD>11/29/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>&nbsp;</TD><TD>Female</TD></TR><TR><TD>979830</TD><TD>No</TD><TD>No</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>11/29/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>&nbsp;</TD><TD>Female</TD></TR><TR><TD>005182</TD><TD>No</TD><TD>Yes</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>12/12/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>005185</TD><TD>No</TD><TD>No</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>12/12/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>010768</TD><TD>No</TD><TD>No</TD><TD>No</TD><TD>Unknown</TD><TD>No</TD><TD>12/19/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>Yes</TD><TD>Male</TD></TR><TR><TD>013588</TD><TD>No</TD><TD>Yes</TD><TD>Yes</TD><TD>Unknown</TD><TD>No</TD><TD>12/15/2017</TD><TD>Ceftriaxone (Rocephin) 250 mg</TD><TD>&nbsp;</TD><TD>Azithromycin (Zithromax) 1 gm</TD><TD>&nbsp;</TD><TD>Male</TD></TR></TBODY></TABLE> Thu, 16 Jan 2020 21:49:12 GMT https://communities.sas.com/t5/SAS-Programming/Help-with-returning-one-row-per-id-by-collapsing-corrected/m-p/617943#M181168 Dhana18 2020-01-16T21:49:12Z https://communities.sas.com/t5/SAS-Programming/Help-with-returning-one-row-per-id-by-collapsing-corrected/m-p/617957#M181179 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/212762">@Dhana18</a>&nbsp;wrote:<BR /> <P>I have a data like this, attached.&nbsp; I would like to have a row per id that includes&nbsp; unduplicated info from other rows for all var in one row.</P> </BLOCKQUOTE> <P>&nbsp;</P> <P>No data was attached.&nbsp; Could you please provide a sample of the initial data in the body of your request, <EM><STRONG>in the form of a SAS data step</STRONG></EM>?&nbsp; Help us help you.</P> <P>&nbsp;</P> Thu, 16 Jan 2020 22:44:12 GMT https://communities.sas.com/t5/SAS-Programming/Help-with-returning-one-row-per-id-by-collapsing-corrected/m-p/617957#M181179 mkeintz 2020-01-16T22:44:12Z