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

inquistive — Wed, 19 Jan 2022 18:56:42 GMT

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.

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

Reeza — Wed, 19 Jan 2022 18:59:06 GMT

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.

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

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

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