BookmarkSubscribeRSS Feed
sateh
Obsidian | Level 7


I have a table with the following structure

sateh_0-1669653988511.png


I need to store in a new column the names of columns where in their records is 1, here is an example of what I want to do, the names of the columns can be separated with , when I store it in that new variable called list as seen in the image highlighted in yellow

sateh_1-1669654125050.png

 

2 REPLIES 2
PaigeMiller
Diamond | Level 26

This is a very difficult arrangement of data to work with, and should be avoided in most cases.

 

What would you do with this new variable once you have it?

--
Paige Miller
PeterClemmensen
Tourmaline | Level 20

I do not recommend this.

 

data want;
   set have;
   array r ACCESO_ADMIN_JUSTICIA -- SEGURIDAD_SOCIAL;
   length listado $200;
   
   do over r;
      if r = 1 then listado = catx(',', listado, vname(r));
   end;
   
run;

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 792 views
  • 0 likes
  • 3 in conversation