- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 09-17-2020 10:36 AM
(1031 views)
How do I label in a practical way a bunch of vars that have the same prefix and need the same label.
Structure of database:
id col1 col2 col3 col4 col5...…...col72
I want all col vars to be called "Supercalifragilisticexpialidocious";
Is there a very to do this very easily?
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
A macro could do this. But, what is the value of having 72 variables having the same label? Why put in the effort, what do you gain?
--
Paige Miller
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
any other way?
I am not too good with macros.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@K_S wrote:
any other way?
I am not too good with macros.
Maybe there's a method using PROC TRANSPOSE, but I will leave that to others. The only other way I know of is to type in the labels for all 72 variables.
--
Paige Miller
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hello @K_S,
Use the ATTRIB statement in PROC DATASETS:
proc datasets lib=your_libref nolist; modify your_dataset; attrib col: label='your label'; quit;