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

[@rajutelagareddi2036]

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

[@learnerea]

Thank you so much 😀

[@meghajain4544]

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

[@learnerea]

Glad you liked it 👏

[@ajaykushwaha4233]

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

[@musicophile4342]

Thank you sir.. Good explanation 👍

[@arorajaonah8830]

God bless you man ❤

[@ajaykushwaha-je6mw]

Salute you Sir.

[@narendervatsavai3662]

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

[@learnerea]

Thanks and welcome

[@nd4763]

Great explanation. Thanks a lot

[@learnerea]

Glad you liked it 👏

[@syedabushra4662]

Nicely explained

[@learnerea]

Thank you

[@TheYi1985]

Fantastic !

[@learnerea]

Glad you like it!

[@Dreamgardener747]

Thank you so much!!

[@learnerea]

Glad it helped!

[@yuanzhou3249]

where is this "trans" dataset? Thanks!

[@roshan6503]

Can we use proc rank to create counter?

[@rohitwalopkar6953]

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

[@learnerea]

While you are summarising

[@rusdianto268]

Can we do this in proc sql?

[@learnerea]

You can use row number partition by in SQL and not in Proc SQL

[@mrinmoydas2351]

How to get last 2 trxn details of each Customer_name?

[@learnerea]

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

[@chinthamahesh4561]

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]

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]

@@learnerea thank you sir, its working

[@rajutelagareddi2036]

@@learnerea sir what & do here

[@sureshnarayasamy89]

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

[@ashutoshlatoriya7363]

Sir when I am practicing this the count variable is not getting created Why is it ??

[@learnerea]

Please put your syntax here so that we could review that