Excluding values with a special character (eg name* ) at the end in proc sql or SAS Data Step

[inquistive]

Hi Experts,
I have columns in a large database which have values like:
Column-        Values available
name    -        name, name*
sid        -          id*, id
score   -      good, good*

How do I fetch the values without the asterisk(*) at the end in proc sql or data step?
I just need name/id/good values( eg; not name*/id*/score*)

~~~

proc sql;
create table fetch as
select name from A where name ...(???)
;quit;

I appreciate your help on this.

Thank you.

[Reeza · Accepted solution]

WHERE findc(name, '*') = 0

FINDC()
https://documentation.sas.com/doc/en/pgmsascdc/v_022/lefunctionsref/n1mdh2gvd5potjn14jipysvzn4o7.htm

---

@inquistive wrote:

Hi Experts,
I have columns in a large database which have values like:
Column-        Values available
name    -        name, name*
sid        -          id*, id
score   -      good, good*

How do I fetch the values without the asterisk(*) at the end in proc sql or data step?
I just need name/id/good values( eg; not name*/id*/score*)

~~~

proc sql;
create table fetch as
select name from A where name ...(???)
quit;

I appreciate your help on this.

Thank you.

---