So.... I am having an issue trying to find a character string within another variable. The problem is that the string that I am looking to find is in another variable.
My data looks like this:
Generic Name FormalName
drugABCD drugABCDEFG
I need to look in "formal name" to find what is in "generic name".
Here is the code that I used but it is NOT working:
Dear HMom;
Please clarify for me your variable names. Your example name and the names in your code confused me. I'm assuming that you want to find out if the value in GenericName is in the variable FormalName.
1654 data have;
1655 length GenericName FormalName Gen_Name $20.;
1656 GenericName = upcase('drugABCD');
1657 FormalName = upcase('drugABCDEFG');
1658 Gen_name = scan(FormalName,1,' ');
1659 put _all_;
1660 run;
GenericName=DRUGABCD FormalName=DRUGABCDEFG Gen_Name=DRUGABCDEFG _ERROR_=0 _N_=1
NOTE: The data set WORK.HAVE has 1 observations and 3 variables.
1679
1680 data temp1;
1681 set have;
1682 x = index(FormalName,(substr(strip(gen_name),1,(length(GenericName)))));
1683 put x;
1684 run;
1
NOTE: There were 1 observations read from the data set WORK.HAVE.
NOTE: The data set WORK.TEMP1 has 1 observations and 4 variables.
I need to be sure that whatever is contained in the variable gen_name on that particular row is somewhere in prod_serv_nm
I had to add in "strip"......
THANK YOU!
did you try the find() function?
e.g.
found = find( prod_serv_nm, gen_name, 't' ) ;
the 't' directs the search to trim before hunting
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.