DATA Step, Macro, Functions and more

Drop characters from dataset

Reply
Contributor
Posts: 38

Drop characters from dataset

[ Edited ]

 HElP me to drop    "–  from drom dataset

I am using SAS 9.4, data came from 9.4UTF 

PROC Star
Posts: 1,215

Re: Drop characters from dataset

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;

 

 

Contributor
Posts: 38

Re: Drop characters from dataset

I tried this way but doesnt work

 

PROC Star
Posts: 1,215

Re: Drop characters from dataset

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?

Contributor
Posts: 38

Re: Drop characters from dataset

data look likes your example

no error and warning in code part , thats pinnacle issue

 

Super User
Posts: 9,922

Re: Drop characters from dataset


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 38

Re: Drop characters from dataset

ASCII or UTF

Ask a Question
Discussion stats
  • 6 replies
  • 116 views
  • 0 likes
  • 3 in conversation