topic How to add a prefix to the existing labels of variables? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/How-to-add-a-prefix-to-the-existing-labels-of-variables/m-p/62521#M17776 Hi,<BR /> <BR /> 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.<BR /> <BR /> Can you guys help me with this?<BR /> <BR /> Thanks,<BR /> Raj Message was edited by: rpunekar Fri, 07 Aug 2009 19:08:47 GMT rpunekar 2009-08-07T19:08:47Z How to add a prefix to the existing labels of variables? https://communities.sas.com/t5/SAS-Procedures/How-to-add-a-prefix-to-the-existing-labels-of-variables/m-p/62521#M17776 Hi,<BR /> <BR /> 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.<BR /> <BR /> Can you guys help me with this?<BR /> <BR /> Thanks,<BR /> Raj Message was edited by: rpunekar Fri, 07 Aug 2009 19:08:47 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-add-a-prefix-to-the-existing-labels-of-variables/m-p/62521#M17776 rpunekar 2009-08-07T19:08:47Z Re: How to add a prefix to the existing labels of variables? https://communities.sas.com/t5/SAS-Procedures/How-to-add-a-prefix-to-the-existing-labels-of-variables/m-p/62522#M17777 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.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sat, 08 Aug 2009 13:37:31 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-add-a-prefix-to-the-existing-labels-of-variables/m-p/62522#M17777 sbb 2009-08-08T13:37:31Z