topic Re: How to find a string within another string and then grab the value of from another variable in SAS Programming

How to find a string within another string and then grab the value of from another variable

GN0001 — Mon, 28 Feb 2022 03:33:07 GMT

data find;
input diseaseName $160. code $45.;
datalines;
cervical cancer 123.z
HepA 9970
;
run;

Hello team,

I want to find a string within another string, if it is found, then grab the correspondent values from another variable.

For example, if value of cervical if found in cervical cancer, then grap the character 123.z.

Any help is greatly appreciated.

Regards,

blue & blue

Re: How to find a string within another string and then grab the value of from another variable

japelin — Mon, 28 Feb 2022 04:09:57 GMT

First of all, the data step you presented does not work correctly, please correct it to the correct one.

If you want to find a string, you can use the find function.

  if(find(diseaseName,'cervical','I'))then newcode=code;

Re: How to find a string within another string and then grab the value of from another variable

GN0001 — Mon, 28 Feb 2022 04:29:21 GMT

Hello team,

This doesn't bring the value from other variable when we find one string within another string.

Regards,

blue&blue

Re: How to find a string within another string and then grab the value of from another variable

japelin — Mon, 28 Feb 2022 04:33:33 GMT

First of all, can you tell me exactly what kind of data you want to derive from what kind of data?
Not inaccurate data steps.

Re: How to find a string within another string and then grab the value of from another variable

andreas_lds — Mon, 28 Feb 2022 07:51:00 GMT

Please explain what "grab the correspondent values from another variable" actually means by showing the expected output.

Re: How to find a string within another string and then grab the value of from another variable

ballardw — Mon, 28 Feb 2022 16:04:42 GMT

When posting code to illustrate data you should run the code before posting it.

When I run your data step this is my log:

1    data find;
2    input diseaseName $160. code $45.;
3    datalines;

NOTE: LOST CARD.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--
6          ;
diseaseName=HepA 9970 code=  _ERROR_=1 _N_=1
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.

What has happened is that you are unconditionally attempting to read 160 characters into the first variable which is longer than the data line you provide. If you must include example data with spaces in the values it is a good idea to use delimited text to simplify coding and correctly read the spaces.

data find;
infile datalines dlm=',' ;
input diseaseName :$160. code :$45.;
datalines;
cervical cancer,123.z
HepA, 9970
;

Re: How to find a string within another string and then grab the value of from another variable

GN0001 — Tue, 01 Mar 2022 01:47:06 GMT

Hello Tom,

I couldn't understand anything of this:

"What has happened is that you are unconditionally attempting to read 160 characters into the first variable which is longer than the data line you provide. If you must include example data with spaces in the values it is a good idea to use delimited text to simplify coding and correctly read the spaces."

Obviously, I want my first variable to have more space if I need it so, I can provide max lenght.

f you must include example data with spaces in the values it is a good idea to use delimited text to simplify coding and correctly read the spaces."

Are you saying to put my text in single quotes if the content of a variable has space?

Regards,

BlueBlue

Re: How to find a string within another string and then grab the value of from another variable

GN0001 — Tue, 01 Mar 2022 01:53:15 GMT

Hello team,

It means variable A from first dataset looks at the field A second dataset and brings a value from anther field.

For Example:

If cervical cancer from table A is found in string of column A of second dataset (cervical cancer screening), then bring the code which exists in a different column in second dataset in the result of the query.

cervical cancer is a substring of cervical cancer screening, then bring code that is in the observation of cervical cancer screening, but in a different column.

Hope this makes sense.

Regards,

blue blue