Remove Commas 1

[noway320]

Can anyone help me? I stuck in removing commas from my sas dataset. Well, I wants to generate .csv file from my sas dataset but due to some commas are already existed in original dataset; it generates extra variable.

Thanks in advance.

 

[klaz2002]

You can remove the commas by using the compress() function or you can 'wrap' your values with quotes.
ex 1

yourvar = compress(yourvar,',');

ex 2

yourvar = '"'||trim(yourvar)||'"';

I hope that this helps you.

klaz

 

[noway320]

Hey klaz,
thanks for helping, but I could not able to find the whole syntax for compress statement. Actually I am very new for this SAS programming. If possible to you then can you please send me whole syntax.... like Data "data name"...

Thanks again

 

[klaz2002]

You need to know the variable name of the offending character string. In my example above I named that variable 'yourvar'. You need to place the compress() function in your datastep code.
ex

data yourdatasetname;
  set yourdssourcename;

  *** WILL REMOVE COMMAS FROM VARIABLE VALUE ***;
  yourvar = compress(yourvar,',');
run;

Klaz

 

[noway320]

It works, awesome!! Many many thanks for your help.
Thanks again.