1. use COUNTC() function. 2. use the variable prefix as the array name. Hope it helps. L.L. proc sql; select max(countc(TrainingTopic,';'))+1 into: max_ct from ...; quit; data ... ; ... array Topic(&max_ct) $100 ; ...
... View more
* Nice ! ; * My minor edits: * 1. no PRoc sort needed. ; * 2. use ID statement ; proc transpose data=have out=want (drop=_name_) prefix=var; by var notsorted; id i; var svar; run;
... View more
![SASGF 2020 [Virtual] Attendee](/html/@A53A708409112314CE528E074D4C8C1F/badge_icons/badge_sasgf20_attendee.png "SASGF 2020 [Virtual] Attendee"){kind=icon}
