empty column with only two character

[harrylui]

good day,

is there a way to empty a column with only two character?

i want to eliminate the row only store two character

for  example

Location

AB  

Church

company

cc

bb

dd

want to empty the string AB,cc,bb,dd to nothing 

thanks in advance

harry

[ed_sas_member · Accepted solution]

Hi @harrylui
You can use a length() function in a IF condition in a data step:

Data want;
Set have;
If length(strip(location))=2 then location ='';
Run;

[andreas_lds]

The function lengthn returns the number of chars ignoring blanks at the end and returning 0, if the variable is empty/missing:

data want;
  set have;

  if lengthn(Location) = 2 then Location = " ";
run;

[harrylui]

thank you all