Get the name of each column

[SASdevAnneMarie]

Hello Experts,

I wonderring if there is some function that permits us to read the name of column (from first to last).

[JosvanderVelden]

Can you explain with a small example with a 'have' dataset example and 'want' dataset example?
Is it something like this?:
Have:
ID var1 var2
J01 1 1
Want:
ID var1 var2
J01 var1 var2
?????

[SASdevAnneMarie]

Thank you for your message,
I added the image of "want" dataset.

[ballardw]

Note to any interested readers: OP changed the "want" appearance from having all values in a single column the name of the variable to something mixing them after I posted this partial possible solution to the original "want". Without any rules.

If a variable is numeric you cannot place text like a variable name as values in that variable. To hold text the variable must be character. If your variable is character it must have a length long enough to hold the name.

You can create a format that will show different text for a value though.

Example:

Data have;
    input somevariable;
datalines;
1
;

Proc format;
value somevariable
1='somevariable'
;

proc print data=have;
   format somevariable somevariable. ;
run;

You would need one format for each variable.

[PaigeMiller]

I feel compelled to ask the obvious questions:

• What is the point of having a data set with ALL values equal to 1?
• What is the point of doing work to create the final data set? What is the benefit? What would be the next step after you do the creation of this final data set?

[ballardw · Accepted solution]

---

@SASdevAnneMarie wrote:

Hello Experts,

I wonderring if there is some function that permits us to read the name of column (from first to last).

I would like to replace the "1" in each column by the name of the column, the ID in my data is CD_produit.

I would like to have the data like that (for example for J009)

Thank you for your help !

---

Proc transpose will create a _name_ variable for each variable on the VAR statement of the procedure call.

I am not going to retype stuff from pictures especially since we can't even tell exactly what one or more of your variable names are because the pictures truncate the names.

Proc transpose data=yourdataset out=transposed;

   by <your grouping variables>;

   var <list all those numeric variables>;

run;

There will be one or more COL variables holding the numeric values. If you don't want those drop them afterwards.

The data set will need to be sorted by the grouping variables before the Proc transpose.

[Ksharp]

data _null_;
 set sashelp.class;
 length _name_ $ 40;
 do until(_name_=' ');
  call vnext(_name_);
  put _name_=;
 end;
 stop;
run;