SAS CHARACTER FUNCTIONS - 6 | INDEX & FIND FUNCTIONS IN SAS | FINDING A WORD/CHARACTER IN A CHAR VAR

This video helps you understand HOW TO FIND AND FILTER ALL THOSE OBSERVATIONS, OUT OF MILLIONS OF OBSERVATIONS, WHICH CONTAINS A PARTICULAR STRING OR WORD OR CHARACTER Using INDEX or FIND FUNCTIONS.

This is strongly recommended to watch the full video however if you are interested in learning only one function i.e. either INDEX or FIND then you can jump to that using the below mentioned time frame:

01:28 - HOW TO USE INDEX FUNCTION IN SAS | SAS INDEX FUNCTION | HOW TO SEARCH FOR A PARTICULAR WORD OR CHARACTER USING INDEX FUNCTION | HOW TO FIND AND FILTER ALL THOSE TRANSACTIONS WHICH CONTAINS A PARTICULAR WORD

07:18 - HOW TO DO THE CONDITIONAL SEARCH FOR A PARTICULAR WORD OR CHARACTER IN A CHARACTER VARIABLE | HOW TO USE THE FIND FUNCTION IN SAS | USING MODIFIERS IN FIND FUNCTIONS IN SAS

#Learnerea
#SASTraining #SASTutorial #SASCourse #SASTutorialForBeginners #SAS #SASforBeginners
#SASProgramming #SASTProgrammingForBeginners #SASProgrammingTutorial

Contacts:

Download the excel files for practice data:

[maneeshrathod]

You made me learning SAS so easy, for everything I come here only,
And left from here with a 😊 smile.

[KIRANSONAWANE-fdhr]

GREAT EXPLANATION SIR THANK YOU SO MUCH

[maqboolthoufeeqt]

one of the best tutorial series. Thank you so much

[_rawat.rohit_]

even translate the whole functions of index and find like index, IndexW, indexC, find, find(i)

[neerajrcit]

than you for these videos. i wish i could find them earlier. :-)

[rameshgaurappa]

Hai sir... Its a nice vedio... and can you explain if the word country repeated 3rd time( or next something) again in statement. how can i know the position of word country(3rd ( or next something)) by program...?

[ashokpharmacy]

hi sir, great work, if possible pls upload a video on nesting functions

[ajaykushwaha-jemw]

Suppose we have below value.
LBORRES

positive
14.3
neg
negative
10
45
123.2
do we have any function which separate numeric value from character and put in different variable ? Kindly help.

[amnaaaa]

Thank you very useful video.
but what if we have more than one thing we want to search for. e.g not just ".com" but other words as well.

[subuddhiba]

Hi
How tondo this if have list words and all of them to find in text string.. can u please help.

[ajaykushwaha-jemw]

Hi Sir,
Thank you for this video.
lets consider a string
123345-46-789-56
12-23456-32-4356-765
234-4-4567-43
My requirement is to scan variable and if find second hyphen or as requirement then take all value from beginning to second hyphen and sore in a new variable. How can i achieve it.

[siddharthmishra]

I don't think the data is available in the GitHub page

[అదన్నమాట]

Is there any modifiers other than " i"

[surajpatil]

if i have numbers in variable 22, 33, 07, 06, 05 and i want remove 0 from last second position can you suggest me code

[memoriesforlife]

can you do a vide o on worst observation carry forward

[deepakkumaar]

sir, is this TRANSACTION data on github, I couldn't find it.