topic Re: empty column with only two character in SAS Programming

empty column with only two character

harrylui — Thu, 05 Mar 2020 06:38:42 GMT

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

Church

company

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

thanks in advance

harry

ed_sas_member — Thu, 05 Mar 2020 06:57:19 GMT

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 — Thu, 05 Mar 2020 06:55:14 GMT

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 — Thu, 05 Mar 2020 06:58:53 GMT

thank you all