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);
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
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
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 th-cam.com/video/U2gBW_sNB2o/w-d-xo.html let us know if this leaves you in doubt
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.)
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
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!
even translate the whole functions of index and find like index, IndexW, indexC, find, find(i)
than you for these videos. i wish i could find them earlier. :-)
❤
Glad it was helpful
Thank you..very helpful..
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);
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..
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 :)
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
I don't think the data is available in the GitHub page
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
th-cam.com/video/U2gBW_sNB2o/w-d-xo.html
let us know if this leaves you in doubt
X=input(lborrrrs,??best.) Or y=input(compress(lborres,'''KD"),best.)
sir, is this TRANSACTION data on github, I couldn't find it.
Use the link given below:
github.com/LEARNEREA/Excel_Files/find/master
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
nice
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