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

[@neetekkumar1475]

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

[@learnerea]

Glad it helped

[@beingfijian1855]

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

[@hemantjoon]

Wonderful and comprehensive tutorial. Thank you for all your efforts

[@kevyndex]

just what I needed. Thank you. Much love

[@skedwardboby9653]

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

[@learnerea]

Glad you liked it

[@yaobini6997]

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

[@learnerea]

Glad it was helpful!

[@deepakkumaar9665]

YOU METHOD IS SO CREATIVE SIR, THANKS

[@AnhTran-yn9me]

Very easy to follow and much helpful! Thanks!

[@learnerea]

Glad it was helpful!

[@amareshkattamuri4235]

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]

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]

@@learnerea YEAH TQ

[@tejuB2006]

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

[@mandrasrinivasulu9267]

thanks, its nice nice video for proc sql

[@learnerea]

Glad you like it

[@preethikam3963]

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

[@learnerea]

Glad you liked it!

[@sreehitha13]

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

[@ajithyadav6176]

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

[@learnerea]

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 - kzbin.info/www/bejne/aZuQhn58p9tmqsU

[@MohammadIrfan-ke7vq]

very well explained..thanks a lot

[@aaiyshaunnisa7454]

Thank you very much, it a very informative video.

[@learnerea]

Glad it helped you

[@gggta7169]

Where are the links your taking about in video?

[@learnerea]

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

[@malikabaddam3590]

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

[@learnerea]

So nice of you

[@beingfijian1855]

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]

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

[@prashanthjaila3412]

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

[@nicolask9869]

Very good explainer, good pedagogy.

[@learnerea]

I'm glad you liked it 😊

[@AlexSmith-tr9hc]

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]

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 😊

[@shayemoore]

Very nice job!

[@beingfijian1855]

excellent video.

[@manzur7177]

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

[@learnerea]

Glad it was helpful!

[@princessaayu4271]

Great job 👏 ..thank you..

[@happypotato9644]

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

[@learnerea]

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

[@happypotato9644]

@@learnerea well，very rare ,but thanks

[@learnerea]

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

[@deependrasingh2700]

Very well explained 👍👍👍👍

[@learnerea]

Thanks for liking

[@sidharth_mohanty]

Amazing video

[@learnerea]

Glad it was helpful

[@RajuRaju-cq2ps]

Nice explanation ❤

[@learnerea]

Keep watching!

[@adityabatra7783]

Plz uploaded some thing about in clinical trials

[@shenwaskijeff3388]

Big thanks for the tutoring!

[@learnerea]

Hope this was helpful to you in someway

[@somcana]

You are genius

[@adityabatra8894]

Please start sdtm videos and tutorial

[@learnerea]

will try and do it soon

[@carolinatriangle683]

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

[@danayoung4460]

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]

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 - kzbin.info/www/bejne/bnennHuroZWHgpI ) third - filter for the rows where counter variable is

[@ivyt8658]

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]

You can find cars dataset in sashelp library

[@kamireddypriyanka6677]

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

[@victoriavijayaraj3787]

Thank you very much

[@learnerea]

You are welcome

[@patel1111101]

is this content helpful for clinical SAS ?

[@learnerea]

Yes it will help

[@rajeshnaidu172]

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

[@learnerea]

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

[@InsideAnkitasUniverse]

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

[@kamireddypriyanka6677]

IF then else are used only in data step

[@gopithammaboina1670]

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

[@RandomClutch64]

This was fantastic. Thank you very much.

[@learnerea]

Thankyou for your kind words, happy learning

[@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]

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

[@ПетяПетрушин-ж6ь]

Thanks man

[@anushapalaneni2065]

Can you please tell Group by and order by difference

[@learnerea]

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

[@adityabatra8894]

Please create a series of table listing figure

[@learnerea]

Will do

[@Manibhai_567]

pls tell the how to remove the duplicate in proc sql

[@learnerea]

try using, select distinct

[@futon.m.alkhaldi6135]

So helpful

[@learnerea]

Glad it was helpful!

[@sreejapesala6117]

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

[@learnerea]

case when sex = "f" then "female" else "male" end as sex_new_var you can check out below for detailed explanations - kzbin.info/www/bejne/a6eQqKd7a8l9hLc

[@SumanKumar-pe7fq]

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

[@learnerea]

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

[@durgadevikudupudi2098]

Thank you 🙏

[@learnerea]

Glad you liked it

[@subhanikurra3988]

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

[@learnerea]

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

[@rakeshpawar13]

thank you

[@garnikharutyunyan7908]

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

[@ashokdevendra8978]

super macros please

[@learnerea]

Hi Ashok, Here comes what you have been waiting for long: kzbin.info/www/bejne/n2XLpmSYbteSh9k

[@ashokdevendra8978]

@@learnerea Thank you bro

[@muralidirisala4618]

You teached full join out put wrong

[@learnerea]

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