Hello, I have below (SpecialServices) column in SAS dataset, I would like to extract string next to "name" particularly and create column for each values: Example, SpecialService1, SpecialService2 etc,. SAS Program: data Cln_SpecialService (drop= _i); set Sub_Str_Qualification; length SpecialServices1-SpecialServices20 $306; array SpecialServices(20) $; do _i = 1 to dim(SpecialServices); SpecialServices[_i] = scan(SpecialService,_i,','); end; run; Raw Data: - 'id' 'CXX2', 'name' 'Multimedikation' , 'id' 'CXXB', 'name' 'Asthma / COPD' , 'id' 'CXX9', 'name' 'Diabetes Typ II' , 'id' 'CXX8', 'name' 'Hautsscreening' , 'id' 'CXX7', 'name' 'KHK' - 'id' 'CXX9', 'name' 'Diabetes Typ II' , 'id' 'CXX8', 'name' 'Hautkrebsscreening' , 'id' 'CXX7', 'name' 'KHK' - 'id' 'CXX2', 'name' 'Multimedikation' , 'id' 'CXXB', 'name' 'Asthma / COPD' , 'id' 'CXX9', 'name' 'Diabetes Typ II' , 'id' 'CXX8', 'name' 'Hautsscreening' , 'id' 'CXX7', 'name' 'KHK' - 'id' 'CXXB', 'name' 'Asthma / COPD' , 'id' 'CXX9', 'name' 'Diabetes Typ II' , 'id' 'CXX7', 'name' 'KHK' - 'id' 'CXXB', 'name' 'Asthma / COPD' , 'id' 'CXX9', 'name' 'Diabetes Typ II' , 'id' 'CXX7', 'name' 'KHK' - 'id' 'CA2B', 'name' 'Asthma / COPD' , 'id' 'CXX9', 'name' 'Diabetes Typ II' , 'id' 'CXX8', 'name' 'Hautsscreening' , 'id' 'CXX7', 'name' 'KHK' 'id' 'CX39', 'name' 'Diabetes Typ II' , 'id' 'CXX3', 'name' 'Psychotherapie, tiefenpsychologisch - Einzelth. - Erw.' , 'id' 'CXXE', 'name' 'Verhaltenstherapie - Einzelth. - Erw.' Desired Result: SpecialService1, SpecialService2, SpecialService3, SpecialService4, SpecialService5 'Multimedikation' | 'Asthma / COPD' | 'Diabetes Typ II' | 'Hautsscreening' | 'KHK' 'Diabetes Typ II' | 'Hautkrebsscreening' | 'KHK'
... View more