How to remove commas in variables (NEW TO SAS!) 1

[croy666]

Hi all,

I have just started with SAS (as my data was getting to big for Excel).

I have a large amount of data and I need to remove any commas from said data.

The data is basicaly names and adresses etc. so have fields called 1st Name, Surname, Title, House No. etc. etc.

In Excel I would have just used find and replace, however I'm struggerling to see an 'easy' option in SAS, I have tried messing around with scan but am not finding a way forward.

If anyone can assist or point me in the direction of a helpful resource (I have 'The little SAS book') I would be extramly grateful

many thanks

 

[shenniko]

Hi,

You could use TranWrd to remove them.

e.g

TranWrd(trim(Left(Variable_Name)), ","," ")

Basically it searches the variable for a commer and replaces it with whatever you want.. (in this case a space)

Robbie