First.Variable and Last.Variable in SAS | First. and Last. Processing in PDV

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

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

50% 1

This video provides a comprehensive explanation of First.Variable and Last.Variable including the PDV processing. after watching this video you will be able to:
► Create an incremental counter based on the value of by variable
► Explain the First.Variable and Last.Variable processing in PDV
► Subset/Fetch the Nth observation from a dataset
► Calculate cumulative sum for each value in by variable
► Calculate subtotal/total for by variable
#Learnerea
#SASTraining #SASTutorial #SASCourse #SASTutorialForBeginners #SAS #SASforBeginners
#SASProgramming #SASTProgrammingForBeginners #SASProgrammingTutorial
Contacts:
Facebook ► / learnerea
Download the excel files for practice data
GitHub ► github.com/LEA...

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

4 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

great brother........... i have no words to appreciate your explanation

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

Thank you so much 😀

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

Hey you have explained very easily. U have used good approach. To the point and relevant. Fantastic way

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

Glad you liked it 👏

@musicophile4342 Год назад

Thank you sir.. Good explanation 👍

@arorajaonah8830 Год назад

God bless you man ❤

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

Great explanation. Thanks a lot

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

Glad you liked it 👏

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

Super explanation sir.........

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

Thanks and welcome

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

Salute you Sir.

@Dreamgardener747 Год назад

Thank you so much!!

@learnerea Год назад

Glad it helped!

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

Such a great video, why don’t you create video on SDTM and on AdAM.

@TheYi1985 10 месяцев назад

Fantastic !

@learnerea 10 месяцев назад

Glad you like it!

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

Nicely explained

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

Thank you

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

where is this "trans" dataset? Thanks!

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

Can we use proc rank to create counter?

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

Can we use functions like mean , sum in after then statement?

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

While you are summarising

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

How to get last 2 trxn details of each Customer_name?

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

First sort the data in descending order and then use the same technique to create counter variable and the pick those where counter

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

Hi sir, I have a doubt, can u tell me how to read? Data a; Input name$ salary age; Datalines; mani 2300 24 Anil 2500 45 Maheshmani 3000 28 Mahesh chintha 4200 30 ; Run;

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

Hi Chintha, Interesting. Just use some extra space to separate the values as in the last observation you want to keep first and last name in one variable which have one space in between them. and use an ampersand in the Input statement with name variable. see below e.g. - Data a; Input name & $20. salary age; Datalines; mani 2300 24 Anil 2500 45 Maheshmani 3000 28 Mahesh chintha 4200 30 ; Run;

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

@@learnerea thank you sir, its working

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

@@learnerea sir what & do here

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

@@rajutelagareddi2036, Normally char values read only 8 characters long by default , sometime the values of the char exceeds 8 , so we use the char length like positionally $1-20 or in length $20. but these won't work properly if there is a space in the variable value . in our case can't be read properly with $1-20 or in length $20. because it won't take spaces . so , if you put '&' in the beginning like & $20. This means it will considers space even two or more spaces . even if your values is , & $20 this will work ..