Problem in creating a character variable

[AlG]

Dear all,

I am in the process of matching two dataset which include a series of firms. The name of the same firm differs across the two datasets. For example, the equivalent of  "Bombay Sapphire Gin" from the first dataset is "Bombay Sapphire" in the second dataset. So I want to create a column in the first dataset which would include the name of the same firm in the second dataset. Below is my (partial) code. when I run this though, the new column includes only the first 10 characters of what I want. This means that whereas it returns "Aeromexico" correctly, instead of returning "Bombay Sapphire", it returns "Bombay Sap". The same thing happens to all of the names that are more than 10 characters. Can you please help me with this? Thanks in advance!

Data Test6;
    set work.Test5;
    If name= "Aeromexico" then MergeName= "Aeromexico";
    Else if name= "Bombay Sapphire Gin" then MergeName= "Bombay Sapphire";
Run;

[yabwon · Accepted solution]

Data Test6;
    set work.Test5;
LENGTH MergeName $ 30;
    If name= "Aeromexico" then MergeName= "Aeromexico";
    Else if name= "Bombay Sapphire Gin" then MergeName= "Bombay Sapphire";
Run;

Here is the documentation link:

https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=p1hgqgmxm3dpqcn1d4w5za5qbz0d.htm&doc...

Bart 

[Kurt_Bremser]

See Maxim 47.