My name is Jelly and I am a Data Science Teacher, SAS Foundation Instructor, and traveler. I love SAS Programming for data reporting, data cleaning, data manipulation, modeling, and more! This channel is meant for beginners getting started with SAS Programming and/or data analytics/science. Let's learn SAS together and add another tool to our toolbelt.
On top of SAS I enjoy teaching Python, Tableau, and SQL. These videos will be throughout as well for those looking to increase their coding knowledge and could benefit from beginner level tutorials. In the near future I will be adding playlist around data analytics, data science, machine learning, and artificial intelligence! If there is a programming topic you would like to see me do a video on please drop it in the comments. Outside of doing this channel I have a Podcast that discusses important data topics: www.youtube.com/@AllAboutDataPodcast/videos
Hi Jelly, thank you! This 30 day SQL challenge lessons are very useful. I am learning SAS this is very useful and I am planning to take base sas certification. If possible can you make 30 day challenge for base SAS certification?
8:00 my experience with PostGre and SQL Server is that you cannot use the newly created alias in the WHERE or HAVING of the same Select statement. I guess SQL Lite is different in that respect.
I made a mistake when creating my table and used File_Id instead of Film_id. Please How do i Update/ Correct that without creating a duplicate table. Thanks Keep up the good work God Bless
For now (since we have not learned updating tables) just rename ID back to File_Id and then Film_Id to ID using a select statement. Or the easiest way for now is to close out of SQLite and reopen it. And correct your code to have the right column and rerun it
My kids have been bugging me to take them to see Inside Out 2... might just have to take them to the drive in this weekend. lol. Awesome 30 day challenge, keep it up!
Hello. l am using SQLite 3.4.4 on a Windows machine and l am unable to create a new database. There is no 'green button' to create new database file. If l just click ok its giving back an error code. Do you have any workaround?
7:42 This is so true, when I first learned SQL 10 years ago I was always baffled why I was selecting fields from various tables without having yet specified the tables. The order of the syntax seemed backwards to me. Eventually it just became natural for me and I haven't thought about it in years until you just mentioned it in the video.
I still watch your SAS videos. Right now I’m studying Tableau html css PBI etc. I will always be back to watch your videos. You really are one of if not THE BEST. Especially with SAS I had such a great time feeling like I was finally getting it! 😂 This is just me scrolling through. Lol. Thank you Jelly! I will definitely check out your SQL lessons for a refresher!!! ✌🏼🙌🏼🙏📚🤓
I attempted : git push -u main Terminal shows : fatal: 'main' does not appear to be a git repository fatal: Could not read from remote repository. Please make sure you have the correct access rights and the repository exists. Looking back I don't see what I did wrong
@@learningwithjelly it is a personal access token. I'm thinking I should delete this token and perhaps recreate it. I know that I have repo and everything under repo checked off to make it work. Thank-you for responding to me by the way!
Check your log. All the hash statements need to be in a data step. The statement below outside the data step all errors out. you probably meant to comment that section out. there is a syntax error in the data step it should be _N_ rather than N. Good explanation though. declare hiter myiter; myiter = new hiter('h'); if N = 1 then do; length key $5; declare hash myhash(dataset:"work.x"); declare hiter myiter('myhash'); myhash.defineKey('key'); myhash.defineDone(); end;
SAS stands for statistical analytics software. It is a programming language that many government, Healthcare, and finance companies use to do their data analytics, modeling etc. I have a video 1 on this channel that explains how to get started using it for FREE and learning the programming language.
How grateful I am for this essentials we should know for using SAS! Thank you so much for creating this clip. It made me full understanding because I’ve been using the program without learning before (I try to decode what the senior wrote it 😂)
It is built into SAS. So once you create a SAS OnDemand Account for Free online. The SAS datasets are on there in the sashelp library. View video 1 on my channel. Thank you.
The only mandatory clause in a select statement is the select clause. You don't have to have a from clause. This is useful in circumstances such as defining a row to be inserted into a table.