check if string contain substring. - SAS Support Communities
Dec 19, 2025 · Hello I want to check if string contain substring. I do it with Find function. What is the reason that example 1 is working 100% but example 2 is not working well? 30000 exist in …
More elegant way to extract a substring between two delimiters
Jun 12, 2025 · I am trying to extract a substring from a field that has up to 2000 characters. I need to capture whatever is between "Destination(s):" and "." The following works, but is there a …
Solved: substring from the right - SAS Support Communities
Apr 2, 2014 · Solved: Hi, is there a quick way to substring from the right but skip a few digits. If I have 2345001 I want to get 2345 .. I want to only remove
Solved: Splitting a text using substr - SAS Support Communities
Dec 7, 2013 · SAS Procedures Help using Base SAS procedures Home Programming SAS Procedures Splitting a text using substr Options Bookmark Subscribe RSS Feed All forum …
Solved: How to extract characters before a special ... - SAS …
Apr 4, 2019 · Help using Base SAS procedures Home Programming SAS Procedures How to extract characters before a special character from a string var...
Solved: Find and replace a substring - SAS Support Communities
Oct 4, 2017 · I have this problem: some values in VAR1 (see example) have special characters ( À Á Â Ã Ä ). I want to find these special characters in a string and replace it with the correct …
Solved: Extracting words from a string after a specific character
Feb 6, 2019 · Hi, I have a variable called "comment" that contains a string of words that are separated by '~' example: comment text text text text ~ text text text text text text text ~ text …
Proc SQL Substring of a numeric variable - SAS Communities
Nov 13, 2014 · DATA Step, Macro, Functions and more Home Programming Programming Proc SQL Substring of a numeric variable Bookmark Subscribe RSS Feed All forum topics Previous …
using substring in proc sql - SAS Support Communities
Jun 26, 2014 · I'm tring to substring a character field (eg. 00000000012345678912) in proc sql and and need to convert it to numeric. I only need the 1234567891 from the field (position 10 …
Check if a list of substrings is in a string - SAS Communities
Sep 7, 2021 · Hi everyone. I'm new to SAS and I'm trying to solve the following problem. I have a number of company names (>1000). And I have a number of "approved" companies (around …