However, the KEY from dataset 1 is contained within a longer string in a variable on dataset 2. I need to look for that key in dataset 2 by a substr/index/find type function to indicate a match. After a match ha
Notice that the function in the example finds indexes of overlapping substrings as well. main.py def find_indexes(a_string, substring): start = 0 indexes = [] while start < len(a_string): start = a_string.find(substring, start) if start == -1: return indexes indexes.append(start) ...
High-Performance SAS Coding - Third Edition 0 Likes Reply Rohit_1990 Calcite | Level 5 Hi Chris thanks for you reply. But I can use scan functio... Posted 05-16-2019 10:59 PM (2033 views) | In reply to ChrisNZ Hi Chris thanks for you reply.But I can use scan function as...
Re: Function to extract substring between two delimiters that are the same Posted 01-02-2019 09:49 PM (8173 views) | In reply to novinosrin It worked. thank you! 0 Likes Missed SAS Innovate in Orlando? Catch the best of SAS Innovate 2025 — anytime, anywhere. Strea...
It will be helpful in getting results of each type specified above in a seperate variable. I can use either coalesce function or observe such observations (Those that have more than one of those words mentioned in the target string, which I believe must be only a handful...
symputx('refcode',txt_array{i}); ERROR 72-185: The FIND function call has too many arguments. How can I fix this? Thanks 0 Likes Reply Tom Super User Re: Find a substring in a word of document Posted 08-13-2024 01:09 PM (855 views) | In reply to WenjieZhou2021 I need...
Or are you attempting to use the VARNAME function. If the later then this won't work. 0 Likes UniversitySas Quartz | Level 8 Re: Searching conditional on substring? Posted 10-19-2018 01:16 PM (1290 views) | In reply to ballardw That's correct. My input code in the original...
Would the best approach be to find the number(s) coming after 'ADDRESS' in the third word based on the space delimiter? Post code Last three or four characters and numbers from the end of the second last word, plus (using the catx function?) the last three characters and number...
Your idea is really good but because there is no consistent pattern the scan function might not work. For example, there are cases that there is no parenthesis at the end of the string. With this regex I can find the position of first match of the pattern. However this not suffi...
Please sign in and ask a new question. mglogan Obsidian | Level 7 Go to Solution Call Scan Function Error with Substring Posted 01-09-2019 01:39 PM (1521 views) Hello, I am using call scan to substring a variable to remove the last number from the string. I am receiving the ...