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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.