HElP me to drop "– from drom dataset
I am using SAS 9.4, data came from 9.4UTF
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;
I tried this way but doesnt work
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?
data look likes your example
no error and warning in code part , thats pinnacle issue
@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.
ASCII or UTF
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.