Drop characters from dataset

[Vahe_Mar]

 HElP me to drop    "–  from drom dataset

I am using SAS 9.4, data came from 9.4UTF 

[PeterClemmensen]

You have to provide more information than that to be sure to get a proper answer. 

I can only guess that you have some character variable for which you want to get rid of the characters â and €?

If so use Compress Function like this

data test;
	charvar="helloâthere€you";
	newVar=compress(charvar, 'â€');
run;

[Vahe_Mar]

I tried this way but doesnt work

[PeterClemmensen]

Then you have to provide more information:

- What does your data look like?

- What does your code look like?

- What Errors appear in the log?

[Vahe_Mar]

data look likes your example

no error and warning in code part , thats pinnacle issue

[Kurt_Bremser]

---

@Vahe_Mar wrote:

I tried this way but doesnt work

---

???

data test;
	charvar="helloâthere€you";
	newVar=compress(charvar, 'â€');
run;

proc print data=test noobs;
run;

Result:

    charvar           newVar

helloâthere€you    hellothereyou

Works.

If it "does not work" for you, post your code (if you use a dataset, post that dataset in a data step, use the macro from https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...), post the log, and post the result (just as I did). Follow the advice in https://communities.sas.com/t5/help/faqpage/faq-category-id/posting?nobounce to post code; use the {i} icon to post logs or list data.

[Vahe_Mar]

ASCII or UTF