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

Подписаться 18 тыс.

Просмотров 17 тыс.

50% 1

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...

Опубликовано:

7 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 38

@maneeshrathod3208 2 года назад

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

@KIRANSONAWANE-fd4hr 4 месяца назад

GREAT EXPLANATION SIR THANK YOU SO MUCH

@learnerea 28 дней назад

Thanks and welcome

@maqboolthoufeeqt 2 года назад

one of the best tutorial series. Thank you so much

@learnerea 2 года назад

Glad it was helpful!

@neerajrcit 2 года назад

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

@_rawat.rohit_ 3 года назад

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

@lifeisdrama511 3 года назад

Thank you..very helpful..

@SanviSree-ti8ve Год назад

❤

@learnerea Год назад

Glad it was helpful

@subbuandra8195 3 года назад

nice

@ashok55pharmacy Год назад

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

@learnerea Год назад

I would recommend you post your problem statement for the nesting functions and we will solve that..

@rameshgaurappa6143 Год назад

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...?

@learnerea Год назад

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);

@ajaykushwaha-je6mw 3 года назад

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.

@learnerea 3 года назад

Check out the video on PERL REGULAR EXPRESSION in SAS and see if that helps you ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-U2gBW_sNB2o.html let us know if this leaves you in doubt

@dandusathish4222 3 года назад

X=input(lborrrrs,??best.) Or y=input(compress(lborres,'''KD"),best.)

@amnaaaa2580 3 года назад

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.

@learnerea 3 года назад

You can do the nesting using 'or'

@gunjanbhasin5546 2 года назад

Can you show an example how to do it using or

@subuddhiba Год назад

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

@learnerea Год назад

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

@siddharthmishra6502 3 года назад

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

@user-et6kz8uq9i 3 года назад

Is there any modifiers other than " i"

@learnerea 3 года назад

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

@user-et6kz8uq9i 3 года назад

@@learnerea thank you. Your videos short and sweet very usefull 👍🏼

@learnerea 3 года назад

@@user-et6kz8uq9i your heartiest welcome and thanks for the acknowledgement. Hope you subscribed us :)

@memoriesforlife7685 3 года назад

can you do a vide o on worst observation carry forward

@memoriesforlife7685 3 года назад

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

@learnerea 3 года назад

@@memoriesforlife7685 It will be better if you can give some example for your problem statement that will help to understand it clearly and explain

@deepakkumaar9665 3 года назад

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

@learnerea 3 года назад

Use the link given below: github.com/LEARNEREA/Excel_Files/find/master

@ajaykushwaha-je6mw 2 года назад

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.

@learnerea 2 года назад

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

@surajpatil2151 Год назад

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

@learnerea Год назад

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.)

@surajpatil2151 Год назад

@@learnerea without converting to numberic