Learning with Jelly
Learning with Jelly
  • 126
  • 307 895
SET Operators in SQL: SQL 30 Day Challenge Day 18
Learn set operators like union, union all, except, and intersect in SQL. Similar to joins except you are combining two queries into one result set. Just be familiar with set operators.
-----------------------------------------------------------------
Download SQLite Studio Here: sqlitestudio.pl/
Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/
Link to Topic List: docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7wUQI8OrNM7vBA0/edit?usp=sharing
Link to Facebook Support Group: groups/767988395118964/
Link to my Data Etsy Shop (support me to keep making content): jellysgeekygoods.etsy.com
Buy me a coffee to show support: buymeacoffee.com/learningwithjelly
#sql #sqltutorial #sqlforbeginners
zhlédnutí: 0

Video

Practice JOINS in SQL: SQL 30 Day Challenge Day 1715:14Practice JOINS in SQL: SQL 30 Day Challenge Day 17
Practice JOINS in SQL: SQL 30 Day Challenge Day 17
zhlédnutí 19Před 2 hodinami
Day 17 we are going to practice joins with 3 questions to get more hands on practice with inner joins, joining two tables in SQL, and joining three tables in SQL. Practice, practice, practice your SQL joins. Video Questions: /* Question 1: Retrieve the names of all tracks along with each track’s genre name */ /* Question 2: Retrieve the names of ALL tracks from the album “Let There Be Rock” */ ...
Subqueries in SQL: SQL 30 Day Challenge Day 1621:58Subqueries in SQL: SQL 30 Day Challenge Day 16
Subqueries in SQL: SQL 30 Day Challenge Day 16
zhlédnutí 60Před 4 hodinami
Learn about subqueries in SQL. Subqueries can be in the SELECT, FROM, or WHERE clauses. Common Table Expressions can limit the use of subqueries. Video Practice Problem: /* Return customer/id for all customers whose total invoice amount is greater than the avg invoice amt for all customers */ Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sql...
JOINS in SQL Part Two: SQL 30 Day Challenge Day 1522:22JOINS in SQL Part Two: SQL 30 Day Challenge Day 15
JOINS in SQL Part Two: SQL 30 Day Challenge Day 15
zhlédnutí 70Před 9 hodinami
Day 15 is about full outer joins, self joins, union all, and joining three or more tables in SQL. Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7wUQI8OrNM7vBA0/edit?usp=sharing Link to Facebook Support Group: groups/76798839511896...
Intro to JOINS in SQL: SQL 30 Day Challenge Day 1421:14Intro to JOINS in SQL: SQL 30 Day Challenge Day 14
Intro to JOINS in SQL: SQL 30 Day Challenge Day 14
zhlédnutí 103Před 14 hodinami
Learn Inner Joins, Left Joins, and Right Joins in SQL. Remember right joins can be written as left joins. Practice joining tables and look at ERD (entity relationship diagrams) to help you out! Questions: /* 1) give a list of customers who have matching invoices. Return customerID, InvoiceID, InvoiceDate */ /* 2) return all tracks regardless if they a part of an album or not return AlbumName, T...
SECOND MINI PROJECT IN SQL: SQL 30 Day Challenge Day 1315:51SECOND MINI PROJECT IN SQL: SQL 30 Day Challenge Day 13
SECOND MINI PROJECT IN SQL: SQL 30 Day Challenge Day 13
zhlédnutí 133Před 16 hodinami
Day 13 is practicing your SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT clauses as well as aggregations in SQL. Case Study Comment: /* Identify Most Popular Genres Within those genres, find albums with the most tracks these albums can play for a good length of the party just in case the DJ needs a break Filter out tracks that are less than 3 minutes long (180,000 ms) too short to dance...
GROUP BY and HAVING CLAUSE IN SQL: SQL 30 Day Challenge Day 1211:15GROUP BY and HAVING CLAUSE IN SQL: SQL 30 Day Challenge Day 12
GROUP BY and HAVING CLAUSE IN SQL: SQL 30 Day Challenge Day 12
zhlédnutí 57Před 19 hodinami
Day 12 is about grouping data and filter data based on these groups in SQL. Learn the GROUP BY and HAVING clauses to get statistical summaries of your data by groups and to filter data based on a grouping variable. Video Questions: /* return the total amount each customer has spent on invoices in total */ /* return the total amount each customer has spent on invoices only if the customer has sp...
Aggregate Functions in SQL: SQL 30 Day Challenge Day 119:35Aggregate Functions in SQL: SQL 30 Day Challenge Day 11
Aggregate Functions in SQL: SQL 30 Day Challenge Day 11
zhlédnutí 128Před 21 hodinou
Learn how to use the COUNT(*), SUM(), AVG() aggregate functions and more in SQL. Aggregate functions are good for exploratory data analysis and can even be used with the GROUP BY clause to get summary statistics for groups. Code Questions: /* 1) get the total invoice amount for california */ /* 2) get the count of invoices from NY */ /* 3) get the count of invoices broken out by State new conce...
UPDATE, DELETE FROM, ALTER TABLE SQL Commands: SQL 30 Day Challenge Day 1016:22UPDATE, DELETE FROM, ALTER TABLE SQL Commands: SQL 30 Day Challenge Day 10
UPDATE, DELETE FROM, ALTER TABLE SQL Commands: SQL 30 Day Challenge Day 10
zhlédnutí 74Před dnem
Day 10 is about making changes to existing tables in a database. Many times we make mistakes, get new data processes, or need to make improvements; therefore, knowing how to update tables in SQL is vital. The UPDATE statement will allow you to update values in a table, the DELETE FROM statement will delete rows based on a condition, the ALTER table statement will let you modify the table on the...
ORDER BY Clause in SQL: SQL 30 Day Challenge Day 912:33ORDER BY Clause in SQL: SQL 30 Day Challenge Day 9
ORDER BY Clause in SQL: SQL 30 Day Challenge Day 9
zhlédnutí 74Před dnem
Day 9 is about ordering our data (result set). You can order data in ascending order (like LastName), or descending order (like most recent purchase dates). This is beneficial when looking at the top and bottom of data to really explore the data (more on this later). /*Sort the invoices table to get the most recent purchase dates listed first */ /*Sort the invoices table by highest total then t...
WHERE Clause in SQL: SQL 30 Day Challenge Day 818:52WHERE Clause in SQL: SQL 30 Day Challenge Day 8
WHERE Clause in SQL: SQL 30 Day Challenge Day 8
zhlédnutí 109Před dnem
Day 8 learn how to filter tables within a database using SQL. Filter based on one condition, or two or more conditions. Learn logical operators such as AND, OR, NOT and comparison operators (greater than, less than, etc.) to filter data. Use the IN keyword to pass a list of values in the WHERE clause and the LIKE operator to match text patterns (similar to regular expressions). Video Questions:...
Mini SQL Project for Creating Tables: SQL 30 Day Challenge Day 715:47Mini SQL Project for Creating Tables: SQL 30 Day Challenge Day 7
Mini SQL Project for Creating Tables: SQL 30 Day Challenge Day 7
zhlédnutí 129Před 14 dny
Day 7 we are creating a table about Disney Pixar Films and using SQL to query it. Learn how to create a table in sql, insert data, and query the table to return the data, get unique values, and rename columns. Also understand data types and constraints when creating tables for SQL databases. Project Steps: STEP 1: Create a table called pixar_films with these columns: film_id (Num & PK-AI), film...
SELECT Clause in SQL: SQL 30 Day Challenge Day 614:36SELECT Clause in SQL: SQL 30 Day Challenge Day 6
SELECT Clause in SQL: SQL 30 Day Challenge Day 6
zhlédnutí 91Před 14 dny
Day 6 is all about selecting columns from tables, selecting unique (distinct) values from within columns to explore our data, and renaming columns using aliases. Learn SELECT *, SELECT DISTINCT, and the keyword 'AS' to query tables in SQL. Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.c...
Creating Tables in SQL: SQL 30 Day Challenge Day 512:58Creating Tables in SQL: SQL 30 Day Challenge Day 5
Creating Tables in SQL: SQL 30 Day Challenge Day 5
zhlédnutí 159Před 14 dny
Day 5 is about creating your own database and data table in SQLite Studio. Learn the CREATE TABLE and INSERT INTO SQL statements. Remember that each column you add to your table needs a data type and can have an optional constraint assigned to it. Have fun creating your own SQL tables Code in Video: create table mytest.black_actresses ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, birthdate TEXT...
Using and Exploring SQL Databases: SQL 30 Day Challenge Day 420:19Using and Exploring SQL Databases: SQL 30 Day Challenge Day 4
Using and Exploring SQL Databases: SQL 30 Day Challenge Day 4
zhlédnutí 190Před 14 dny
Day 4 is all about knowing the types of databases, what a database schema is, rules/constraints of databases, column data types, entity relationship diagrams (ERDs), and more! It is important to know and understand database terminology to troubleshoot down the road and for interviews! Know the difference between primary and foreign keys as well. Download SQLite Studio Here: sqlitestudio.pl/ Dow...
Intro to SQL Syntax: SQL 30 Day Challenge Day 317:56Intro to SQL Syntax: SQL 30 Day Challenge Day 3
Intro to SQL Syntax: SQL 30 Day Challenge Day 3
zhlédnutí 248Před 14 dny
Intro to SQL Syntax: SQL 30 Day Challenge Day 3
Download SQLite Studio: SQL 30 Day Challenge Day 212:35Download SQLite Studio: SQL 30 Day Challenge Day 2
Download SQLite Studio: SQL 30 Day Challenge Day 2
zhlédnutí 251Před 14 dny
Download SQLite Studio: SQL 30 Day Challenge Day 2
Intro to SQL: SQL 30 Day Challenge Day 111:20Intro to SQL: SQL 30 Day Challenge Day 1
Intro to SQL: SQL 30 Day Challenge Day 1
zhlédnutí 634Před 21 dnem
Intro to SQL: SQL 30 Day Challenge Day 1
SAS PROC SQL CRASH COURSE - JOINS (Part 3): SQL for Beginners13:41SAS PROC SQL CRASH COURSE - JOINS (Part 3): SQL for Beginners
SAS PROC SQL CRASH COURSE - JOINS (Part 3): SQL for Beginners
zhlédnutí 328Před 4 měsíci
SAS PROC SQL CRASH COURSE - JOINS (Part 3): SQL for Beginners
SAS PROC SQL CRASH COURSE (Part 2): SQL for Beginners19:50SAS PROC SQL CRASH COURSE (Part 2): SQL for Beginners
SAS PROC SQL CRASH COURSE (Part 2): SQL for Beginners
zhlédnutí 378Před 4 měsíci
SAS PROC SQL CRASH COURSE (Part 2): SQL for Beginners
SAS PROC SQL CRASH COURSE (PART 1): SQL for Beginners25:56SAS PROC SQL CRASH COURSE (PART 1): SQL for Beginners
SAS PROC SQL CRASH COURSE (PART 1): SQL for Beginners
zhlédnutí 757Před 5 měsíci
SAS PROC SQL CRASH COURSE (PART 1): SQL for Beginners
Confidence Intervals in SAS: SAS for Beginners (Lesson 34)17:04Confidence Intervals in SAS: SAS for Beginners (Lesson 34)
Confidence Intervals in SAS: SAS for Beginners (Lesson 34)
zhlédnutí 322Před 5 měsíci
Confidence Intervals in SAS: SAS for Beginners (Lesson 34)
SAS PROC Step Crash Course: Intro to the PROC step in SAS25:17SAS PROC Step Crash Course: Intro to the PROC step in SAS
SAS PROC Step Crash Course: Intro to the PROC step in SAS
zhlédnutí 625Před 6 měsíci
SAS PROC Step Crash Course: Intro to the PROC step in SAS
SAS DATA STEP Crash Course: Learn SAS in Under an Hour!55:42SAS DATA STEP Crash Course: Learn SAS in Under an Hour!
SAS DATA STEP Crash Course: Learn SAS in Under an Hour!
zhlédnutí 2,3KPřed 7 měsíci
SAS DATA STEP Crash Course: Learn SAS in Under an Hour!
Data Analyst for Beginners Lesson 3.10 - For Loops & List Comprehensions in Python5:18Data Analyst for Beginners Lesson 3.10 - For Loops & List Comprehensions in Python
Data Analyst for Beginners Lesson 3.10 - For Loops & List Comprehensions in Python
zhlédnutí 108Před 8 měsíci
Data Analyst for Beginners Lesson 3.10 - For Loops & List Comprehensions in Python
Data Analyst for Beginners Lesson 3.9 - List Comprehensions & Conditional Statements in Python5:22Data Analyst for Beginners Lesson 3.9 - List Comprehensions & Conditional Statements in Python
Data Analyst for Beginners Lesson 3.9 - List Comprehensions & Conditional Statements in Python
zhlédnutí 41Před 8 měsíci
Data Analyst for Beginners Lesson 3.9 - List Comprehensions & Conditional Statements in Python
Data Analyst for Beginners Lesson 3.8 - Intro to List Comprehensions in Python5:13Data Analyst for Beginners Lesson 3.8 - Intro to List Comprehensions in Python
Data Analyst for Beginners Lesson 3.8 - Intro to List Comprehensions in Python
zhlédnutí 33Před 8 měsíci
Data Analyst for Beginners Lesson 3.8 - Intro to List Comprehensions in Python
Data Analyst for Beginners Lesson 3.7 - List Methods in Python5:08Data Analyst for Beginners Lesson 3.7 - List Methods in Python
Data Analyst for Beginners Lesson 3.7 - List Methods in Python
zhlédnutí 34Před 8 měsíci
Data Analyst for Beginners Lesson 3.7 - List Methods in Python
Data Analyst for Beginners Lesson 3.6 - Concatenating Lists in Python5:33Data Analyst for Beginners Lesson 3.6 - Concatenating Lists in Python
Data Analyst for Beginners Lesson 3.6 - Concatenating Lists in Python
zhlédnutí 33Před 8 měsíci
Data Analyst for Beginners Lesson 3.6 - Concatenating Lists in Python
Data Analyst for Beginners Lesson 3.5 - Indexing Lists in Python4:55Data Analyst for Beginners Lesson 3.5 - Indexing Lists in Python
Data Analyst for Beginners Lesson 3.5 - Indexing Lists in Python
zhlédnutí 46Před 8 měsíci
Data Analyst for Beginners Lesson 3.5 - Indexing Lists in Python

Komentáře

  • @developbit
    @developbit Před 6 hodinami

    Thanks for more practice on this.

  • @developbit
    @developbit Před dnem

    I really need to go back and practice, this one was a little tough for me.

    • @learningwithjelly
      @learningwithjelly Před dnem

      Practice link in the topic list document plus Day 17 will be more Practice since 14 and 15 was a beast

  • @developbit
    @developbit Před 4 dny

    I was unsuccessful in using the c.CustomerID, I used the following which still works: select customers.CustomerId, invoices.InvoiceId, invoices.InvoiceDate from customers join invoices On customers.CustomerId = invoices.InvoiceId

  • @tablesidewithfirebride7927
    @tablesidewithfirebride7927 Před 5 dny

    Hello! I was trying to create a data base for the exercise, my file didn't have a green plus sign to make my own. I only have the folder, my status bar says that it cant add the data base. How can I resolve this to follow along with your tutoring?

    • @learningwithjelly
      @learningwithjelly Před 4 dny

      Click on the folder you see, and when the next screen pops up, type the name "mytest" in the "File name" field and click select. The database should appear then.

  • @awotundeoluwatosin7427
    @awotundeoluwatosin7427 Před 5 dny

    Doing Great Jelly

  • @ngaybepavel6362
    @ngaybepavel6362 Před 6 dny

    The "milliseconds" attribute is not an aggregated field. Does using it with a "WHERE" clause make a difference in this case?

    • @learningwithjelly
      @learningwithjelly Před 4 dny

      Not sure what your question is exactly. If you put a condition in the where clause it will filter the table. It can filter using a column or an aggregation it will still work

  • @developbit
    @developbit Před 6 dny

    I need to practice more on the having clause😄

  • @anuradhavaradha2257
    @anuradhavaradha2257 Před 7 dny

    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?

    • @learningwithjelly
      @learningwithjelly Před 7 dny

      If it is popular I can put that on the list :) glad things are helpful!

  • @malcorub
    @malcorub Před 7 dny

    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.

    • @learningwithjelly
      @learningwithjelly Před 7 dny

      Yes could be a difference based on the SQL tool different dialect...thanks for sharing your experience

  • @staceyh.5759
    @staceyh.5759 Před 9 dny

    Hi Learning with Jelly, do you offer SAS Viya training?

    • @learningwithjelly
      @learningwithjelly Před 8 dny

      Not currently. I can put it on the request list :)

    • @staceyh.5759
      @staceyh.5759 Před 8 dny

      @@learningwithjelly I would love that. Thank you!

  • @developbit
    @developbit Před 9 dny

    the only other aggregate functions I saw were min and max

  • @patricklewis7981
    @patricklewis7981 Před 9 dny

    Great video, nice refresher lesson hadn't done macros in a while.

  • @developbit
    @developbit Před 9 dny

    Great video

  • @awotundeoluwatosin7427
    @awotundeoluwatosin7427 Před 9 dny

    Great job on Day 10, code warrior, you've done and dusted with flair Thanks Jelly

  • @michokoto
    @michokoto Před 9 dny

    Love the Etsy merch! What's the LinkedIn link?

    • @learningwithjelly
      @learningwithjelly Před 9 dny

      Thank you! And here is the Linkedin: www.linkedin.com/in/angelicaspratley?

  • @developbit
    @developbit Před 11 dny

    This really helps a lot as I am looking at the database at my job to do more queries like this

    • @learningwithjelly
      @learningwithjelly Před 11 dny

      So happy it is helpful and applicable we will learn more and more stay tuned

  • @developbit
    @developbit Před 11 dny

    Thank you so much for adding practice, this has helped a lot

  • @awotundeoluwatosin7427
    @awotundeoluwatosin7427 Před 11 dny

    Thanks Jelly, You are doing great. #Day 9

    • @learningwithjelly
      @learningwithjelly Před 11 dny

      Happy you are keeping up with the challenge! Let's keep going

  • @ngaybepavel6362
    @ngaybepavel6362 Před 12 dny

    Is it necessary to enclose the alias in quotes, or is it a convention with SQLite?

  • @awotundeoluwatosin7427
    @awotundeoluwatosin7427 Před 12 dny

    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

    • @learningwithjelly
      @learningwithjelly Před 12 dny

      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

  • @PhillyDog
    @PhillyDog Před 13 dny

    Great content

  • @malcorub
    @malcorub Před 13 dny

    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!

    • @learningwithjelly
      @learningwithjelly Před 13 dny

      Go see it!!!! Lol and thank you for participating in the challenge

  • @PhillyDog
    @PhillyDog Před 13 dny

    Great content

  • @PhillyDog
    @PhillyDog Před 13 dny

    Great content

  • @SaraEliBeth90
    @SaraEliBeth90 Před 14 dny

    Is there any reason you did auto increment versus identity and selecting the number and increment value?

    • @learningwithjelly
      @learningwithjelly Před 14 dny

      Nope multiple ways to do it just chose auto increment for simplicity for beginners here

  • @natashaplatt6919
    @natashaplatt6919 Před 15 dny

    This was such a great video! Thank you Jelly!

  • @tinotendanmufudza3747
    @tinotendanmufudza3747 Před 16 dny

    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?

    • @learningwithjelly
      @learningwithjelly Před 16 dny

      If you have the Chinook database uploaded just add the table to that so do chinook.black_actresses for your create table and insert into command

    • @learningwithjelly
      @learningwithjelly Před 16 dny

      Try to look at the tool bar as well and see if there is a File then a add database option or a Database menu....so check the menu bar

    • @learningwithjelly
      @learningwithjelly Před 16 dny

      Try to look at the tool bar as well and see if there is a File then a add database option or a Database menu....so check the menu bar

    • @sunkanmiyusuf285
      @sunkanmiyusuf285 Před 15 dny

      i had to uninstall and install again, the green button didn't come up but clicking ok worked this time

    • @awotundeoluwatosin7427
      @awotundeoluwatosin7427 Před 13 dny

      @@sunkanmiyusuf285 I'm using Windows and i can help with that

  • @Kiki11207
    @Kiki11207 Před 17 dny

    I gotta catch up already. Loved this breakdown Thank you!!

  • @malcorub
    @malcorub Před 18 dny

    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.

    • @learningwithjelly
      @learningwithjelly Před 18 dny

      I thought the same thing haha! Glad to read your experience with this.

  • @lashawngaines9315
    @lashawngaines9315 Před 18 dny

    You are the best! I have lost count of how many videos I have watched, until yours...which perfectly explains this. Thank you!

  • @malcorub
    @malcorub Před 20 dny

    I've always wondered what NOSQL is... learned something new. 🎓. Thx Jelly.

  • @ttjiy5
    @ttjiy5 Před 20 dny

    Thank you!

  • @joannaj.9020
    @joannaj.9020 Před 20 dny

    Jelly I am your fan. Thanks for everything you are doing for us, data freaks 😘

  • @LuvLuke954
    @LuvLuke954 Před 20 dny

    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!!! ✌🏼🙌🏼🙏📚🤓

    • @learningwithjelly
      @learningwithjelly Před 20 dny

      This is soooo kind I appreciate you and the support! Glad you were scrolling through you made my day.

  • @AC-pr2si
    @AC-pr2si Před 20 dny

    Great video Jelly. I was one of your SAS students at D.Tech.You have always been a great instructor.

  • @lindsaytruax234
    @lindsaytruax234 Před 21 dnem

    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
      @learningwithjelly Před 20 dny

      This could be an SSH key issue. Do you have a personal access token on your account or SSH key setup?

    • @lindsaytruax234
      @lindsaytruax234 Před 19 dny

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

  • @mPulse-wo2ki
    @mPulse-wo2ki Před 22 dny

    Thank you 🦋

  • @mPulse-wo2ki
    @mPulse-wo2ki Před 22 dny

    What a talented teacher! Thank you so much 🦋

  • @mayalindsay101
    @mayalindsay101 Před 22 dny

    This was really good

  • @amargurung9513
    @amargurung9513 Před 23 dny

    Thank you for the awesome tutorial on SAS fundamentals.

  • @ccc-qj7mn
    @ccc-qj7mn Před měsícem

    Wondering why the graphic stopped changing with the dialog at about 7 minutes???????

  • @cf413
    @cf413 Před měsícem

    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;

  • @sakshiagarkar8277
    @sakshiagarkar8277 Před měsícem

    Perfectly explained

  • @ethiopia8415
    @ethiopia8415 Před měsícem

    Much Helpful

  • @user-ly4be2po4b
    @user-ly4be2po4b Před měsícem

    Another question is about SAS. What is SAS package? Why do we need it? How to use it? Can SAS on demand opens the SAS package? Thank you so much ❤

    • @learningwithjelly
      @learningwithjelly Před měsícem

      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.

    • @user-ly4be2po4b
      @user-ly4be2po4b Před měsícem

      @@learningwithjelly I didn't understand what SAs package is. How to use sas package. Do you have video teaching about it?

  • @user-ly4be2po4b
    @user-ly4be2po4b Před měsícem

    Tableau what?

  • @smartou11
    @smartou11 Před měsícem

    This was a great video to refresh my SAS background. Thank you for this great content.

  • @nttrn
    @nttrn Před měsícem

    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 😂)

  • @akhilnama1989
    @akhilnama1989 Před měsícem

    Will be great if you could provide the ppt you shared during the tutorial. Thanks!!

  • @andrewreinke6562
    @andrewreinke6562 Před měsícem

    This is excellent work. Thank you!!