I have dataset like this: Data Facility; infile datalines delimiter='|'; input FacilityName $ FacilityAddress $ FacilityServices $; datalines; Skybuilding1|123 Main St|Cardiology Skybuilding1|123 Main St|Oncology Skybuilding2|124 Main St|Primary Care Skybuilding2|124 Main St|Primary Care Meadowsbuilding3|125 Main St|Radiology Meadowsbuilding4|177 Fake St|Dermatology ; I want to convert that dataset to a new one where if FacilityName and FacilityAddress are duplicated but the value in FacilityServices is different, then take the two values in FacilityServices and concatenate them into one observation. For example observations 1 and 2 would be reduced to one observation with the FacilityServices variable concatenated with a comma in between: Skybuilding1|123 Main St|Cardiology,Oncology
... View more