PROC SQL in SAS | PROC SQL All in One | A Complete Guide to Proc SQL in SAS

Поделиться
HTML-код
  • Опубликовано: 20 янв 2025

Комментарии • 103

  • @neetekkumar1475
    @neetekkumar1475 Год назад +6

    Kudos to the instructor. All other SAS tutorials are so confusing and boring but this one is really good!!!

  • @beingfijian1855
    @beingfijian1855 3 года назад +7

    This has been the most comprehensive as well as of short duration video. I have learned so so much. Thank you!

  • @skedwardboby9653
    @skedwardboby9653 3 года назад +1

    The best of what I have watched about SQL in the simplest fashion so far. Thank you

  • @hemantjoon
    @hemantjoon 3 месяца назад

    Wonderful and comprehensive tutorial. Thank you for all your efforts

  • @kevyndex
    @kevyndex 3 года назад +3

    just what I needed. Thank you. Much love

  • @yaobini6997
    @yaobini6997 Год назад +1

    Wow, great job, I am understanding sas now, thank you.

  • @deepakkumaar9665
    @deepakkumaar9665 3 года назад +1

    YOU METHOD IS SO CREATIVE SIR, THANKS

  • @AnhTran-yn9me
    @AnhTran-yn9me Год назад

    Very easy to follow and much helpful! Thanks!

  • @amareshkattamuri4235
    @amareshkattamuri4235 2 года назад +2

    IN JOINS WHEN THERE ARE COMMON OBSERVATIONS OF MORE THAN 1 IN ON VARIABLES WE WILL GET THE CARTESIAN PRODUCT.
    HOW TO HANDLE THAT SITUATION

    • @learnerea
      @learnerea  2 года назад +1

      If have this in the column you are using as key to join the tables, if so then either-
      >> please remove the duplicates first and then join
      >> Concatenate that column with any other one which is common in both and doesn't have duplicates, that will create unique values and then you can use the same as key var. to join further

    • @amareshkattamuri4235
      @amareshkattamuri4235 2 года назад +2

      @@learnerea YEAH TQ

  • @sreehitha13
    @sreehitha13 3 года назад +1

    Thnku very much sir for giving good info .. really I learnt a lot.. keep make videos sir

  • @carolinatriangle683
    @carolinatriangle683 2 года назад +1

    Great video👍,very very helpful! I’ve learn a lot from this tutorial. Thanks! 🌹🌹

  • @preethikam3963
    @preethikam3963 2 года назад +1

    Thanks for the wonderful content video in proc SQL. Kudos to your efforts taken.

  • @malikabaddam3590
    @malikabaddam3590 4 года назад +1

    Awesome effort sir.... your teaching explanation is too good

  • @mandrasrinivasulu9267
    @mandrasrinivasulu9267 2 года назад +1

    thanks, its nice nice video for proc sql

  • @ajithyadav6176
    @ajithyadav6176 3 года назад +2

    Do you have any video about PROC ARRAYS and PROC SURVEYSELECT?

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

      Hi Ajith,
      We have the video for Arrays which you can watch using below link and for SURVEYSELECT we will make the one soon. Happy Learning -
      ruclips.net/video/3j-UKFrv3tc/видео.html

  • @deependrasingh2700
    @deependrasingh2700 2 года назад +1

    Very well explained 👍👍👍👍

  • @manzur7177
    @manzur7177 2 года назад +1

    Such a great video! I l learned a lot within a short time.

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

      Glad it was helpful!

  • @MohammadIrfan-ke7vq
    @MohammadIrfan-ke7vq 2 года назад +1

    very well explained..thanks a lot

  • @nicolask9869
    @nicolask9869 3 года назад +1

    Very good explainer, good pedagogy.

    • @learnerea
      @learnerea  3 года назад +1

      I'm glad you liked it 😊

  • @princessaayu4271
    @princessaayu4271 3 года назад +1

    Great job 👏 ..thank you..

  • @tejuB2006
    @tejuB2006 5 месяцев назад +1

    Thank you so much for clear explanation. One question , Is Proc SQL included in the syllabus of base SAS specialist exam?

  • @aaiyshaunnisa7454
    @aaiyshaunnisa7454 2 года назад +1

    Thank you very much, it a very informative video.

  • @shayemoore
    @shayemoore 2 года назад +1

    Very nice job!

  • @beingfijian1855
    @beingfijian1855 3 года назад +1

    excellent video.

  • @CelebrationKings
    @CelebrationKings 2 года назад +1

    Where are the links your taking about in video?

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

      Not sure what link you are exactly looking for. In the description section, the github link for all the excel files is given, same mentioned here againg -
      github.com/LEARNEREA/Excel_Files
      at the below github link, you can find all of the SAS Scripts and Data used -
      github.com/LEARNEREA/SAS
      From below, you can download many of the datasets stored in excel -
      github.com/LEARNEREA/Excel_Files
      let me know in case of any further suggestions needed

  • @beingfijian1855
    @beingfijian1855 3 года назад +2

    Do you have different types of logic and answers I can use to run and learn? Please! either with Cars or any data set.

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

      check out our newly uploaded videos like - calculating the rolling average... you will get the logical ideas...

  • @shenwaskijeff3388
    @shenwaskijeff3388 3 года назад +1

    Big thanks for the tutoring!

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

      Hope this was helpful to you in someway

  • @prashanthjaila3412
    @prashanthjaila3412 2 года назад +2

    Bro, will u please INSERT INTO , ALTER, UPDATE also in PROC SQL , aren't they important in realtime as a SAS Coder.

  • @RandomClutch64
    @RandomClutch64 2 года назад

    This was fantastic. Thank you very much.

    • @learnerea
      @learnerea  2 года назад +1

      Thankyou for your kind words, happy learning

  • @reetashit2407
    @reetashit2407 Год назад

    Could you pls tell I am using Sum function to get the amount of gross amount for previous month..but I got double amount on same..

    • @learnerea
      @learnerea  Год назад

      can you check your group by statement.. better you put your code here

  • @sidharth_mohanty
    @sidharth_mohanty Год назад +1

    Amazing video

  • @somcana
    @somcana 3 года назад +1

    You are genius

  • @RajuRaju-cq2ps
    @RajuRaju-cq2ps 3 месяца назад

    Nice explanation ❤

  • @danayoung4460
    @danayoung4460 2 года назад +1

    great video, thank you so much! Have a question, in sql, we could use LIMIT to select top n observations or rows for a certain column, let's say select top 5 records with math score in each grade, how we get this with sas sql? or we can use this car data, to select top 5 most expensive cars in each car type? In sql, you can use group by type order by msrp, then limit 5, but sas proc sql doesn't have LIMIT function, how we do it in SAS proc sql?

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

      you can use the option "outobs" but that will give you n number of records on overall level and not by each of the group
      if you are interested in doing that using data step then what you can do is -
      first - sort the data by car type and msrp in descending order
      second - create a counter variable by car type (to learn this you can check out the video - ruclips.net/video/8FDkHul0TL0/видео.html )
      third - filter for the rows where counter variable is

  • @adityabatra7783
    @adityabatra7783 3 года назад +1

    Plz uploaded some thing about in clinical trials

  • @happypotato9644
    @happypotato9644 2 года назад +1

    Can you make example, on what kind of occasion we use full join?

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

      Maybe, an exhaustive list of all the customers from customer table and trans table for a given month

    • @happypotato9644
      @happypotato9644 2 года назад +1

      @@learnerea well,very rare ,but thanks

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

      @@happypotato9644 yeah that's true, not used oftenly

  • @Manibhai_567
    @Manibhai_567 2 года назад +1

    pls tell the how to remove the duplicate in proc sql

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

      try using, select distinct

  • @AlexSmith-tr9hc
    @AlexSmith-tr9hc 3 года назад +1

    Nice video with one item noted: when the output changes at 31:24, we observe a category value of "toddler" that shows up with no prior code to tag the age category as "toddler". All we had before this was either "kid", "teenage" or "young", based on age. Where is the code to tag "toddler"? Oops.

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

      Alex thanks for highlighting this, we are definitely going to be careful about such mismatches however here the category 'Kids' can be considered as toddler. To note this has nothing to do real life toddler age 😊

  • @victoriavijayaraj3787
    @victoriavijayaraj3787 2 года назад +1

    Thank you very much

  • @ivyt8658
    @ivyt8658 3 года назад +1

    Thanks for your video! it's very helpful! i went to the link and try to download file. could you advise me where can i find the excel file for cars?

    • @kamireddypriyanka6677
      @kamireddypriyanka6677 3 года назад +1

      You can find cars dataset in sashelp library

    • @kamireddypriyanka6677
      @kamireddypriyanka6677 3 года назад +1

      That is not an excel file, we cannot read excel file in sas, only sas dataset with extension sas.7bdat can only be accessed on sas interface

  • @ПетяПетрушин-ж6ь
    @ПетяПетрушин-ж6ь 3 года назад +1

    Thanks man

  • @patel1111101
    @patel1111101 10 месяцев назад +1

    is this content helpful for clinical SAS ?

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

      Yes it will help

  • @anushapalaneni2065
    @anushapalaneni2065 10 месяцев назад +1

    Can you please tell Group by and order by difference

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

      Order by is to sort your data either in ascending or descending order while group by is for aggregation of the data with a calculation

  • @durgadevikudupudi2098
    @durgadevikudupudi2098 3 года назад +1

    Thank you 🙏

  • @sreejapesala6117
    @sreejapesala6117 2 года назад

    How to define sex variable as f = female and m= male in proc SQL program what is the code for that

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

      case when sex = "f" then "female" else "male" end as sex_new_var
      you can check out below for detailed explanations -
      ruclips.net/video/5v-wtE6dJNU/видео.html

  • @futon.m.alkhaldi6135
    @futon.m.alkhaldi6135 11 месяцев назад

    So helpful

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

      Glad it was helpful!

  • @rajeshnaidu172
    @rajeshnaidu172 4 года назад +1

    Thanks for your videos sir.It helped me a lot.Cant we use IF condition instead of WHERE in proc SQL sir...

    • @learnerea
      @learnerea  4 года назад +3

      Hi Rajesh,
      In PROC SQL one can use where clause and having and not the if statement.

    • @InsideAnkitasUniverse
      @InsideAnkitasUniverse 3 года назад +2

      'If' condition cannot be used in Procedure i.e. 'Proc' step.

    • @kamireddypriyanka6677
      @kamireddypriyanka6677 3 года назад +1

      IF then else are used only in data step

    • @gopithammaboina1670
      @gopithammaboina1670 2 года назад

      @@InsideAnkitasUniverse we can use if condition in one procedure i.e proc report with compute statement

  • @adityabatra8894
    @adityabatra8894 2 года назад +2

    Please start sdtm videos and tutorial

    • @learnerea
      @learnerea  2 года назад +1

      will try and do it soon

  • @adityabatra8894
    @adityabatra8894 2 года назад +1

    Please create a series of table listing figure

  • @SumanKumar-pe7fq
    @SumanKumar-pe7fq 4 года назад

    How to find Commulative Sum Or Running total Through Proc SQL ?

    • @learnerea
      @learnerea  4 года назад +1

      Hi Suman,
      There are certain limitations with Proc SQL as well as with Data Step and that is where we use either of them as an alternate. Therefore you can use data step to calculate the cumulative sum

  • @subhanikurra3988
    @subhanikurra3988 3 года назад

    can you explain how to find second highest value in proc sql

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

      for that you can try to create counter using first. in data step

  • @rakeshpawar13
    @rakeshpawar13 3 года назад

    thank you

  • @garnikharutyunyan7908
    @garnikharutyunyan7908 3 года назад +1

    amboxj hay azge qo heta, shat enq qez sirum u misht hetevum enq qez

  • @ashokdevendra8978
    @ashokdevendra8978 4 года назад +1

    super
    macros please

    • @learnerea
      @learnerea  4 года назад +2

      Hi Ashok,
      Here comes what you have been waiting for long:
      ruclips.net/video/i4hu1b9r_Qw/видео.html

    • @ashokdevendra8978
      @ashokdevendra8978 4 года назад

      @@learnerea Thank you bro

  • @muralidirisala4618
    @muralidirisala4618 11 месяцев назад

    You teached full join out put wrong

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

      We can discuss the descripancy, please feel free to share it in detail