Hi folks, Probably a common problem, and I'm just blanking on a solution that doesn't require 5,040 lines of code... I have seven variables, of which any number of them can be populated or missing. In any combination. And I'd like to concatenate them into a single variables that displays the populated values as a list separated by commas. But obviously I don't want extraneous commas, so I only want the new variable to include non-missing values. Any thoughts on how to do this? Original data: Obs Barrier1 Barrier2 Barrier3 Barrier4 Barrier5 Barrier6 Barrier7 1 Child Funding Title IV-E 2 Funding Courts Team 3 Policy Team Other 4 Child Courts 5 Funding Policy 6 Child Courts Title IV-E Other Desired new variable: Obs Barriers 1 Child, Funding, Title IV-E 2 Funding, Courts, Team 3 Policy, Team, Other 4 Child, Courts 5 Funding, Policy 6 Child, Courts, Title IV-E, Other
... View more