i am using proc sql to join and want to use a condition something like this which was used in datastep.
if mapsubmitted="Y" and (cats(substr(term,1,1),substr(term,length(term)))="()" or term="*") then do;
_rc=_values_.add();
end;
i am using the below
proc sql;
create table _values_ as
select distinct b.table,b.column,b.origin,b.originwhere,b.algorithm
from vcol a right join source_columns b
on a.origin=b.origin
where substr(b.term,length(b.term))="()";
quit;
i used where substr(b.term,length(b.term))="()";
In this i want to take values in term which are enclosed in "()" or which has "*".
values in term are below. i want to take only terms which are enclosed in () and which has *.
(MMSE)
|
can any one help me on this.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: