Help using Base SAS procedures

How to add a prefix to the existing labels of variables?

Reply
N/A
Posts: 1

How to add a prefix to the existing labels of variables?

Hi,

I am merging two data sets for my project and would like to add prefixes to the labels of variables from each data set. For example, if I am merging data sets A and B, I want to add a prefix A to the labels of variables obtained from data set A and a prefix B to the labels of variables obtained from data set B. I do not want to change the variable names, but just add prefixes to their labels.

Can you guys help me with this?

Thanks,
Raj Message was edited by: rpunekar
Super Contributor
Super Contributor
Posts: 3,174

Re: How to add a prefix to the existing labels of variables?

Use the VLABEL function in a DATA step to retrieve the current variable label (assigning it to a temporary SAS variable), and use PUT to generate new LABEL statements with the desired new/merged variable label value out to a temp file. Then %include that temp file to re-define the variable labels.

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 1 reply
  • 153 views
  • 0 likes
  • 2 in conversation