SAS: How to Remove Commas from String

The easiest way to remove commas from a string in SAS is to use the TRANSLATE function, which converts every occurrence of one character to another character.

You can use the following basic syntax to do so:

data new_data;
    set original_data;
    string_var = compress(translate(string_var,"",','));
run;

This particular example removes every comma from each string in the string_var variable in a dataset.

The following example shows how to use this syntax in practice.

Example: Remove Commas from String in SAS

Suppose we have the following dataset in SAS that contains information about various basketball teams:

/*create dataset*/
data my_data;
    input team $ points;
    datalines;
,Mavs, 113
Pacers 95
,Ca,vs 120
Lakers 114
Heat 123
King,s 119
Raptors 105
,Hawks 95
Ma,gic 103
Spu,,rs 119
;
run;

/*view dataset*/
proc print data=my_data;

Notice that several of the strings in the team column contain commas in various places.

We can use the following syntax to remove all commas from the strings in the team column:

/*create new dataset where commas are removed from each string in team column*/
data new_data;
    set my_data;
    team = compress(translate(team,"",','));
run;

/*view new dataset*/
proc print data=new_data;