topic How to delete values that have "_U" in the end in SAS Programming

How to delete values that have "_U" in the end

Abhi301812 — Wed, 17 Jan 2018 08:13:00 GMT

I want to delete values/rows which are appended with "_U" in the end.

Re: How to delete values that have "_U" in the end

PeterClemmensen — Wed, 17 Jan 2018 08:17:45 GMT

data have;
string="SomeString_U";output;
string="SomeString";output;
string="Some_UString";output;
run;

data want;
	set have;
	where substrn(string,max(1,length(string)-1),2) ne "_U";
run;

Re: How to delete values that have "_U" in the end

Abhi301812 — Wed, 17 Jan 2018 08:19:02 GMT

Thanks, this was helpful

Re: How to delete values that have "_U" in the end

PeterClemmensen — Wed, 17 Jan 2018 08:19:33 GMT

Anytime, glad to help 🙂

Re: How to delete values that have "_U" in the end

BrunoMueller — Wed, 17 Jan 2018 08:22:47 GMT

Please provide some sample data in the form of a DATA Step

See this post on how to convert your SAS data set into a DATA Step program that creates this data
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Re: How to delete values that have "_U" in the end

RW9 — Wed, 17 Jan 2018 09:10:44 GMT

Or for succinctness:

data have;
string="SomeString_U";output;
string="SomeString";output;
string="Some_UString";output;
run;

data want;
  set have;
  where index(string,"_U");
run;

As a tip @PeterClemmensen, could you use spaces rather than tabs to indent, as tabs get shown differently in different editors