topic Re: Drop characters from dataset in SAS Programming

Drop characters from dataset

Vahe_Mar — Tue, 12 Dec 2017 11:05:47 GMT

HElP me to drop "â€“ from drom dataset

I am using SAS 9.4, data came from 9.4UTF

PeterClemmensen — Tue, 12 Dec 2017 11:18:37 GMT

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 — Tue, 12 Dec 2017 11:25:10 GMT

I tried this way but doesnt work

Vahe_Mar — Tue, 12 Dec 2017 11:25:53 GMT

ASCII or UTF

PeterClemmensen — Tue, 12 Dec 2017 11:26:21 GMT

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 — Tue, 12 Dec 2017 11:27:51 GMT

data look likes your example

no error and warning in code part , thats pinnacle issue

Kurt_Bremser — Tue, 12 Dec 2017 11:45:58 GMT

@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-data-AKA-generate/ta-p/258712), 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.