SAS CHARACTER FUNCTIONS - 6 | INDEX & FIND FUNCTIONS IN SAS | FINDING A WORD/CHARACTER IN A CHAR VAR
Vložit
- čas přidán 11. 09. 2024
- 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:
Facebook ► / learnerea
Download the excel files for practice data:
GitHub ► github.com/LEA... - Věda a technologie
You made me learning SAS so easy, for everything I come here only,
And left from here with a 😊 smile.
GREAT EXPLANATION SIR THANK YOU SO MUCH
Thanks and welcome
one of the best tutorial series. Thank you so much
Glad it was helpful!
than you for these videos. i wish i could find them earlier. :-)
even translate the whole functions of index and find like index, IndexW, indexC, find, find(i)
❤
Glad it was helpful
Thank you..very helpful..
nice
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...?
You can try nesting the find function thrice for the start postion, something like below -
exists = find(string, 'country', find(string, 'country',find(string, 'country')+1)+1);
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.
Check out the video on PERL REGULAR EXPRESSION in SAS and see if that helps you
czcams.com/video/U2gBW_sNB2o/video.html
let us know if this leaves you in doubt
X=input(lborrrrs,??best.) Or y=input(compress(lborres,'''KD"),best.)
hi sir, great work,if possible pls upload a video on nesting functions
I would recommend you post your problem statement for the nesting functions and we will solve that..
I don't think the data is available in the GitHub page
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.
You can do the nesting using 'or'
Can you show an example how to do it using or
Hi
How tondo this if have list words and all of them to find in text string.. can u please help.
store all those words in a macro variable and use do loop to check one by one.
if required further clarity, try to put your question with an example.. I'll explain it further
Is there any modifiers other than " i"
The below link has entire list of modifiers which can be used here
documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarget=n1mdh2gvd5potjn14jipysvzn4o7.htm&locale=en
@@learnerea thank you.
Your videos short and sweet very usefull 👍🏼
@@అదన్నమాట your heartiest welcome and thanks for the acknowledgement. Hope you subscribed us :)
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
assuming you have '07' and what you want is just 7 -
here you variable is character type, just converting that into numeric will solve the issue, try below -
new_var = input(youvariable, best.)
@@learnerea without converting to numberic
sir, is this TRANSACTION data on github, I couldn't find it.
Use the link given below:
github.com/LEARNEREA/Excel_Files/find/master
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.
Hi Ajay,
This is the input you have given, can you please put some sample of output which you are expecting out of this. it will make the problem statement more clear and simple for me
can you do a vide o on worst observation carry forward
i mean to say with in a group if we have any missing values i need to take lease value and carry forward to missing
@@memoriesforlife7685 It will be better if you can give some example for your problem statement that will help to understand it clearly and explain