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

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

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
  • 832 views
  • 0 likes
  • 3 in conversation