 Hello, and we're going live here, of course Somebody texts me just as soon as I go live and I thought I'd turn off my phone But they didn't and that's why we're going live because we want to iron things out a little bit Early before I officially open the stream. So this is Monica Wachee and Thank you if you're already shown up here But hopefully you'll show up as this live stream starts Decided to have it kind of at the last minute, but I realized I really had to get something up about sass and showing myself using the sass To show people that it's really not that hard to use sass on demand for academics and To what people's appetite for sass. Well, hello Thank you for coming You'll see I'm gaining some Agility with the software. Thank you for showing up We'll see if I get more people I'm trying to build an audience here, you know so where I am it's noon and So if you're having brunch if you're in a time zone near mine, you know Hopefully you're having a bloody Mary or maybe you're having some tea. I have some tea over here And you're enjoying your your Sunday in the Middle East. They're working today. So I don't know maybe you're productive you're in the Middle East being productive He showed up. I'm so glad you're here I'm like Daniel's biggest fan because this guy what is he doing here? He knows everything about sass But I'm gonna teach him about our seeds the exchange the exchange Hello, hello nice to see you. I was I'm glad people are showing up because oh and hello. I'm glad you showed up I'm Alexander. I'm glad you're here. Thank you. I'm glad more people are showing up because I'm hoping Excuse me. I'm hoping people can network like people who are interested in the same because data science is so big Right, so if I say sass and then you show up to this then you're interested in sass And so, you know nothing that there's anything wrong with Python But if you're like well, I came here to talk about sass and this person's talking about Python and I don't know Python, you know that way we can get like, you know It's just topical. I mean, I'm not against talking about Python, but I don't know Python So I do more listening than talking and asking questions But I know a lot about sass so I can hold the live stream on sass, right and keep you all entertained I'm so glad you're showing up. Thank you for coming and supporting my live stream and Making chat start making it interesting So I'm just kind of running this a little bit like a Like I kind of imagine this like a classroom and people are coming to the classroom Before I start their official lecture. I know like if I were more elegant, I'd find a way to put up this live stream is starting Excuse me. Oh, why it's So I'm frogging my throat. I have live stream starts and you know, like I should not do that. I should understand like You know, it's funny how Challenging some Technology things are me like I I have this colleague and I was meeting with her and she goes Monika How do you get that background and I go? What do you mean? How do I get that background? Well, it took us 10 minutes of discussion This is a physical like barrier thing and she was trying to load it computer, so I'm like, I just miss communicate with everybody, but anyway, it's surprising how Not good. I am at some technology like I tried to have an Android once as much as I you know I use are like you'd think that I'd like an open source Like cell phone, but I just couldn't get the Android and you know I'm not a big fan of the Macintosh interface the Apple interface, but I love the iPhone so go figure me out I don't know what's up with me But anyway, you know when you're when you think in terms of design You sort of think about Utility and so I think maybe the iPhone interface is just really good for a smartphone and I kind of like other interfaces for other things Like I'm kind of a minimalist so our GUI interface is really nice for me. My intern uses our studio I'm like, oh my god all these windows and handle it You know, I grew up when there was command prompt and one window and that was our But anyway, so let's see here. It's almost time to start the stream. Oh time to start the stream Okay, welcome everybody this official start Today, this is Monica. Wahee and I'm opening the stream We're gonna start today to talk about sass and I decided to hold this for two hours Hopefully we'll get some more people to show up and I can do some demonstrations because now we have sass on demand for academics Which is an online free version of sass, which is like, okay, cool. Let me use it Well, you know if you're used to using sass like actually Daniel Daniel in the chat Have you used sass on demand for academics? Hello from the chat Because I'm wondering like so Daniels here is a sass aficionado if you're used to sass You know that there's sort of two main ways sass is used One is you have a server sass implementation like you work somewhere and they've got server sass The second one is where you have PC sass and those of you who've taken my LinkedIn learning courses show I show you I'm demonstrating on PC sass well now Those of you who follow my blog know that for a little while sass Oh, so you've used it Daniel. Can you tell us put in the chat what you think of it like in any of your first impressions? So I I would use PC sass normally I think Daniel uses Server sass because he does some really like hardcore stuff where you need the server I was just kind of doing you know little things But they have you know kind of like our in our studio is kind of the same program but it's different interfaces the PC sass and And the server sass they were they're sort of different interfaces, but sort of the same kind of the same way well, then sass came out for a short time with It was called University Edition and it was free and I was really happy that they did that because I Was trying to get people to use sass and you couldn't really use it It's not like are that you just download and you can use it because it's made by a company the sass company And they would have to sell it and they just wouldn't make like cheaper free versions those of you who have used SPSS, which is a statistical program That's by IBM and you can just buy like SPSS for some hundreds of dollars Sass you couldn't do that with like PC sass in like 2006 cost about $10,000 for just like the most basic like Seat I was working at this Alzheimer's Institute and they made us pay $10,000 for base sass and sass stat if you know what I'm talking about the sass components I was like $10,000 since Alzheimer's Institute compared to our like think about that. I was like I'm downloading our I got All mad my boss is so sweet. He bought me the sass. He's like he was a sass use it because at the time I said I downloaded our we didn't have our at the time. We had s S-plus. I think our was just being invented. Let me see what Daniel says Yes, I've used sass on demand though most of the time I use sass installed on the server, right? See I was right because he does this hardcore But what's your impression Daniel for like if somebody's new if somebody knows other a Software the way, you know sass and they're going to try and adopt sass are going to try sass Do you think that they can get a good experience on sass on demand for academics? That's the new free version so for a while sass came out with this free version called University edition and You know, I'm sorry. It's confusing like that was you e and they had that for a while and I really wanted people to start using it because I had made some courses in sass and I'd gone to some conferences some data science conferences and Our users and Python user like how do we try sass? Like how do we try it? I was like, I guess you're right. How do you try it? And normally how you would try sass as you go to a college where they teach sass so the college would make a license with sass and then you could go the college bookstore remember those and pick up your Your sass version back in the day you had to install it with like CDs and stuff now You would download it and install it and you could get PC sass Well, even that was kind of a headache to install PC sass so So they started coming up with They said they had just had to come up with a solution that made it easy for people to try sass or practice their sass I hate to say this but You know just like set Microsoft been around for a long time sass has been around around for a long time and it's Had different moods and for a long time sass was very proprietary like Microsoft They did not want you you were using all sass or not Like they I would want to buy a teaching copy or something. No, no, either you're part of a sass shop or you're not Now they're doing the sass our integration stuff. They're doing that They were very late to the table on that and those and I think you'll agree with me Daniel that they were late to the table on integration and Web and stuff. I mean now they're here. They've got Viya and everything but they were very siloed They wanted you to do the sass system or not, right? And for a while they could do that I mean very long time like if you have a server sass shop It's very hard to dismantle like a lot of times people are like, oh gg plot to you know the plotting package and are and they want to use it with their sass data and Actually, it's a little hard to do because sass was not really originally meant to be shared with our you know But anyway, so for finally sass for a little while came up with sass university edition But it just wasn't adoptable. Those of you who follow my blog I put four blog posts showing you how to install it and run it like you had to install this appliance appliance and then you had to like You had to create some sort of account and then you had to run all this stuff Basically you were setting up kind of a fake mainframe Just so you could You know make a frequency table. So it really wasn't I really just couldn't get people to adopt it I was like I hope they come up with a solution for this and then um, you know Like I thought is there a way to make it less clunky and at this time I was writing my book. Those of you know who know I have a book as it was called Mastering sass programming for data warehousing. I was focusing on using sass for data warehousing because you use it for a lot of things So I just had this free version that was really kind of clunky and a few times I was running into some issues with it. So I was contacting sass and they didn't really support it So I'm like, how do you have this free thing out there? And you don't really support it? Well, what ended up happening is they took it down. It wasn't working and if you go to my blog You'll see I have a note up that's that directs you to another blog post which is now for sass ODA sass on demand for academics So now it's a lot more reasonable to connect and use it In fact, I've been really testing the limits of it recently I've been trying to put big data sets into it and you try to do regression and it's pretty it's pretty sturdy I think I think you could kind of use it, you know, I'm impressed I think sass finally got it right this time. So good job sass So today I first wanted to talk about why I think you should learn sass Why anyone should learn sass if they're new to data science if you already know sass like Daniel Yay, you know, great That's wonderful. Um, and and I guess if you already know sass why you should keep up with your sass And here's why and I kind of just alluded to it If you if if a place has set up a server a sass server shop, you know, like, um Oh hi there Nice to see you. Thank you for showing up um, if a place has set up a server sass shop like Somebody wrote to me and asked me. Um, oh, it was you Alexander. Um, what you should learn if you're in Pharmacology and I'm like I have to learn sass, right? because A lot of those, you know, if you go to a drug company, I guarantee you I've never even worked at one But I guarantee you they've got server sass, right? And they have a lot of what's called macros what macros are is automated functions That you actually build over time if you read my book, you'll see you don't just wake up one day and make a macro It's like over time you do this thing over and over and you build this function And then you make this automated function call a macro and what's nice is you know, the thing runs If you put this input in it always runs, right or whatever And so they have all these macros who are, you know, half life and pharmacovigilants and stuff like that um, so one of the big things in sass was is not just ETL like extract transform and load, you know managing the data But it's also reporting and so like especially financial places will have all these sass reports And the problem with that is sass reporting language is so complex And if anybody knows r like I I I was teasing Daniel to learn r But it's very hard to learn r if you're used to sass because sass is very self referential And r is very object oriented. It's just you have to think totally different way But in r it's so easy to do like one little thing like if you want to Just make a graph or just make a table In sass, it's it's just a much more You know it's built in like the early 70s. It's in a different environment, you know It hasn't really changed much. I mean they add on to it, but they don't really change how it runs and so Um, I first of all it's it's a miracle. It's a fantastic program But it's very complicated. It's I like to Sort of liken it to a like an iron lung a very old machine That maybe you need to keep it going or a very old like vehicle that they don't make anymore and you need to Keep the parts going and stuff and that's the way sass is and at the end of the day um It's probably better to do reporting in r these days um, but we're always limited by input output because sass is the big data engine that does io that um Inputs data and outputs data and you can control it. It's like a manual transmission. You can control it Whereas in sequel, you know, you have to rely on an optimizer and in r I recently got an error. I was just To have thousands of data. So, you know So we still need sass and we still need these sass server setups It's just that we're gonna have to move a lot of the reporting out of it We're gonna have to move a lot. Um If it's a physical server sass, you probably have to move the data into the cloud like a snowflake Um, and you probably also and then hook up sass via all of this So those of you who are listening to me out there and you know python and you know r and you're like Why would I learn sass? Well, how are we going to get all this data? How are we going to do all that? I mean, it's it's in there. So somebody's gonna have to know sass and nobody wants to learn My poor intern She doesn't want to learn sass. You know, she's so good and she learned r She learned she learned r on her own like I She's smarter than me And then she learned python on her own and then sass is like, I don't even want to do it I mean, it's fun to do regressions in sass, but that's doing regression sass is like nothing, you know um, hello everybody Feel free to start a side conversation if you anything I say sounds interesting to you But anyway, so that was the first part of our agenda is I was trying to explain to you If you're a data scientist, why might you learn sass now if you're in one of those fields like pharmacology or you know health data science um, or fintech Weather there's some places some fields Um, and remember if you go to my blog post my data science toolkit I tell you at the beginning of your data science journey It's good to pick the field first because we use different tools We prefer different tools in different fields not like you can't cross over But um and health care where the sass has been There forever and yes r and python are great But if you're going to be an epidemiologist like me you're going to end up dealing with sass So you might as well learn it you might as well just like eat your vegetables kind of and just face it You're going to have to learn sass But don't see it this way. Don't think you're going to learn sass on a weekend sass takes a long time to learn you got to practice it it's I It's nicer. I would suggest learn r and learn python because you just learn them quick But don't forget about sass keep sass in your journey somewhere keep it on the back burner at least or work on it now And then sass is a good thing to do Something in it and then forget about it and then try to do something in it again. You're like, oh my god I feel like I've never seen the spot where before But if you do that enough like do something one week forget about it do something the next week It's a surprise. I don't recognize it. Yeah, I guess I do forget about it If you handle it that way you'll start to sort of get to know sass because sass is really odd It's not like anything we would design today um, all right, so Now, um, what say you want to learn sass? I've convinced you you want to learn sass Um, I recommend three three easy steps, right? So the first step I recommend is that you Take my free online course. So let me share my screen here and show it to you so, um Okay, so here we go, uh, I'll put this link in the well, let me put it in the chat now so, um Here we go. So this is a free online course Called getting started with sass on demand for academics and I just wanted to show you what's in here Okay, now obviously you don't have to take this course. You could just go set up sass and just do it, right? But the reason why I think you should take my free course is that I think and I think Daniel will agree with me if you really understand the history of how sass was built and the design behind the language it is much easier to learn the language and It's hard because when you're young sass person Back in the 90s before they had really invented the internet It was just like folklore The only way you would learn this kind of information was from other older programmers From reading sass white papers But you know, there wasn't really Anything that explained to you this information. So I just put it all together into a little course and um So the course takes about an hour to get through it and it's um, it's just uh four um sections And what did it or I guess five? So the introduction just explains what's going to be in the course um Chapter two is a bunch of different um videos and some short presentations The presentations have screenshots annotated screenshots that just explain what sass is And then there's a little quiz to try to Help you remember just terminology and You know, which applies to all the interfaces of sass. Okay And that that's chapter two Then chapter three Is is just practical. It just explains to you how to set up Yourself and sass on demand for academics or sass ODA and get started And then chapter four is a challenge, which is just challenging you to get you set up and Going in sass ODA and then there's a conclusion and um Let me go back to my stream here and so, um So I made that course because I think it's worth it to go through All of that information Before you even bother to try to learn the code Because the code just doesn't really make a lot of sense without really understanding the backstory with sass And I learned sass in a classroom like there was a lecturer And that lecture was kind of saying some of that stuff that I have in that course But nowadays that doesn't always get passed down. So that's why I I think you should take that course Okay, and it's free. So that's my favorite thing Okay, so the steps that I recommend was one is take that course you know, if you want to learn sass and um second is That you actually learn the programming language, right? and uh, so if you take my course, you'll get set up in it and then um I you know, as I mentioned, I wrote a book Called mastering sass programming for data warehousing and that forced me to write a bunch of code for sass That runs, right? Um and put it on github. So I have all this github code So what I've been doing is you know the the um The course I just showed you I'm gonna try and make my goal is to make these 23 courses To get through all of that code to teach that code from the Book you don't have to buy the book, but it's nice if you buy the book If you want to learn how to do how to run a data warehouse I strongly encourage that book if you're thinking about management Okay, if you're not thinking about management, the book is still interesting if you just like to read books I strongly recommend it. I I think it's very um Dramatic. I think I'm a good writer, but maybe only in my own mind, right? It's got a pretty good reviews on amazon um, but anyway, so um, so the next part is Learning how to program and sass well enough so that you can do stuff, right? um, so let me just start uh demonstrate a little bit sass here. So I'm gonna um See if I know how to I can do this here. Let's see Go to the right Okay, when you um When when you start sass what happens is you go to this login screen First you have to create a free account with sass and it's not you can see I'm logged in here and actually You won't be able to see this um I can put the link for you afterwards I'll put the link in the um, or you can probably look it up how to uh go to sass on demand for academics online Because what will happen is you know, I think if I just put this welcome in here um, it'll make you um I think it'll make you go to a registration page um, because what happens is Then you register and you come in and it's a big deal when you register because this is this is your account On sass according to sass. So if you actually buy anything like a server sass, this is on your account And if you do help desk tickets and stuff, this is your real account. So don't making most that or anything Put your real data in and really validate it put a nice long password Okay, but then you get this this panel and I don't know what these other things are Sass studio is sass on demand for academics. That's what we want Okay, and so let's see here if I click on it. It's going to open and Let's see here. Um, all right. So it went away here. Let me see if I can uh Share the screen here. Oh, thanks. Um, they even put in the chat. Thank you Yeah, here Okay, so um now I'm so where am I now I'm where I would be if let me just make sure this is showing here Yeah, yeah, this is right. So this is where I would be if I clicked that link, okay So I'm going to just talk about generically What's going on in this in this? Window here. Um, as you can see, I've got a panel here. I can actually move this back and forth here So this is this is looks like a programming window, but see there's tabs across here You know, I can open more files here and then there's tabs here. This says code log Results, okay, and sometimes there's other stuff here too. So this is kind of complicated over here But they managed to get it to work because those are you who are used to Server sass and other kinds of sass. No, there's a million windows, right? And then over here, this is kind of like It kind of looks like I'm on a sass server and this is where my files are now. I created these folders I call them just af and h and this this was default I don't know why that was there and x and this is I usually just name them one letter because you have to retype that a lot Um, it's I make it a lib name as you can see in this code. I have open here It says set lib name for project. See this is a comment here in green It's got kind of a little editor in it then lib name f and see this reference to this location That's to this folder. Why? Well, I was helping Someone with some homework and I was making some code with them So I wanted to all save it in this folder and I want you to notice those of you would actually do read my book This uh Are my naming conventions for the code and you can see these are all code files um Here we have read in data. Let's see here. This is question one question two like they were we were doing some homework And you see this 900 here. I put stuff under 900 if I was working on something Then you can see there's a bunch of other kinds of files. These are code files This is like a csv And this is a sass 7b dat. So this is a sass data set And this is a csv and just out of convenience. I was just helping someone with their homework I threw all the stuff in here Also, if I generated any data sets in here, I just threw it in this app Okay, so and and again, I'm looking under here, but There's other things in here. There's like tasks and utilities and snippets and all that here the libraries Now you saw how I mapped f there We also have a library called work, but work is um If if anything ends up in work, it goes away when your session is over And so that's why it's good to um To actually have uh lib names and uh folders over here And then um, so that's that's the beginning. So maybe I'll go over here any questions from anybody um because then I was going to go over and um sort of show you some of the um You know just some of the code that was from this homework assignment because it's sort of uh revealing uh and and those of you take my uh course That you learn about sass you'll understand about you know, uh looking at this code so This so this code here you'll notice that the first one is called formats. Okay In sass, so let's talk about data in general There's two kinds of data, right? There's continuous data or you know, like numerical continuous data and then there's categorical data See this proc format here. See this value sex underscore f one equals men Two equals women. You can kind of tell what's going on there This is a this is a label that's going to be applied to Uh a field it doesn't say which one here But if if that field says one it's going to display men and if that field says two it's going to display women Now let's say I had a continuous variable I could do this too. Um, let me see if I had one I don't have one in here But like let's say if I had like systolic blood pressure I could have ranges of it Be labeled a certain way and that's actually kind of a trick And um, and you're probably one of these formats for well, these are what would show up on reports Like you could put these labels on reports because remember sass was programmed like in the 70s You could only save like one in the field like you couldn't save men in the field, right? So this is the workaround is to create these formats and then you apply the formats, okay? And so this is the format file that I make to create the formats and in fact if I run this That's me running it See, here's the log you always look at the log, right and you go to the top you start reading it These are system options Um, see the library reference was successfully signed here. It's nice and blue. That means everything worked out and then this is just my comments and um This is sass talking back to me So I created the format called sex underscore f format sex underscore f has been output Now I had this in code When I used to run the data warehouse When we start our Unfortunately, they wouldn't give it to me and um, they wouldn't give me A server or they wouldn't give me sequel I was trying to set up some sort of sequel integration. They wouldn't do that So we had to run anything in pc sass, which is so slow. Don't do it So what we do is we'd open um A sass file we'd open this file and we'd load these formats like I ran it and now they're loaded in memory But before we started at etl we'd have to actually apply the formats. I think I do that here Because I think that was her homework assignment. Yeah Her homework assignment had something to do with the framing hand data set any of you might know about that Generally, if you're a professor and you're listening here or a teacher Don't use old data sets like framing ham because it's really hard to teach With them because we don't know like someone seems bad for you and stuff Okay, so this maps the lib name I have a habit of mapping lib names at the top of my code because I just get sick, but And this is a classic data step um for their homework They were given this data set in sass 7b dad format So sass wasn't going to have any problems with it So I read it and using the set statement and I named it fram underscore sass underscore a And I'm putting it in work. So let's just go and Do that See notice how now we have the output data Pain here. We didn't have that before And see up here. It says work Dot Frams as well. So this is the name of the data set that says it's in work. Actually, let's go look at At work. Ah, here it is And see here's all the um variables in it and um And I guess they're just checked off and what you can do is you can see them over here Actually, this is really nice Because before, you know in sat like here, I can see that there's a missing variable here You know, it's kind of nice, but you can't really scroll like you want to scroll up and down like this But you really have to actually go like this To go to the next one and it can get really slow But it's just nice to quickly look at it and then there's information about the variable like here Like you can look down here. I don't really use that but I I would tell you, you know people who program in sass Have done a lot see i'm having trouble navigating Do a lot in sass like with with um formats and stuff I don't I try to stay out of sass. I do all my curation. I do everything outside of sass except for Like I'll even do etl outside sass if I can get away with it I try to use sass for the least amount, but I have to say sass is perfect for like prox survey rag Like all the prox that are for like regression and stuff It's so much better to use sass like you just it's just so much better And so it's like if you can find a way to make your data and some other program do it But the problem is getting it into the sass environment afterward Here, let me go back to see if anybody's asking questions. Oh, I guess not All right, so um, so let's see here. Let me go back to this. Um All right, so then um for her, um assignment Uh, so here's reading a data set in so the set is f dot framing ham here. Oops So f dot and then framing ham over here. Here's the and now it's in a work named fram sass. I okay Now we've got a prox prox contents. It's going to say the contents of this. Let's run this prox On work. Why doesn't it say that? Um, maybe it forgot Or maybe it's too far down Okay, here it is. Here's a prox contents. See it came over in the results. So let's look at this here This is the data set name. Now notice how how standardized this thing is back, um In the olden days before r existed It was really hard to program software like if you program This is a report. Like if you program to report It was so hard that your idea was you're gonna just put everything on that report anything anybody would ever want to need You put on that report. That's why like If you do anything like Um, let me see if I've got something here Yeah Um Let's see here Like if you have um a relatively simple Let's see here This is um me importing a um a csv using proc import I guess let's see if that works Yep So here This is prox survey freak This is why you want to use sass, right? Because this does a survey regression Like prox survey freak you specify the data. This is the hugest proc in the world, right? We're specifying the data is this analytic data set, which I etl somewhere else in the long done Um, this is the weight column because this is a weighted regression Strata and cluster These have to do with the units the sampling units And these are the tables. These are going to make me weighted tables. Okay And so I'll show you here Now We'll see how fast this goes on now if you were on server sass This would be like you click that and you wouldn't even believe how fast this But before we look at our results, you should always make a habit of going to your log and starting there So we go to the top here And we see the code it usually repeats the code back Okay, so it's trying to tell us that there might be some instability in our prox survey reg because Um, some of the clusters are small, but I didn't care The the you don't see any errors if just to show you what an error looks like here Let's let's leave the The semicolon off of mail See what happens. Okay. Imagine we're typing so fast. We don't know we don't notice that Now when we write it here So I know what we did wrong right is we left the semicolon, but look at what happened So it's variable table not found What the heck is that right? So that's just a great example of how Really common mistakes in sass Um are really hard to troubleshoot. Okay, and so if you're probably wondering why All this is formatted the way it is. It's really just so I can make sure that I can troubleshoot Um anything that I'm doing in sass because it's really hard to It's just really hard to Like like if you can imagine me putting all this in one in order It would be really hard for me to find that that was missing Okay, so um But anyway, so I thought I'd go back here Um, let's see here. So that I showed you this format This loads these formats. Let's get rid of this And then this reads in the data we have here, uh Oh here, um, remember how I said that um I was I was at this job and we were stuck with pc sass Which is not a bad program, but Our data were huge and we needed to store it in Like oracle or microsoft sql or something not pc sass or sass server, which I didn't want to set up one And so I was having so much trouble with that. Um, and I Normally what you use in sass to do data management are data steps like what I was showing you Like this is a data step here this data set um, but When sql is invented a lot of sql programmers had trouble adopting sass because they're not used to The data step language. So the sass created this sub language Remember how I mentioned macros that's seen as a sub language And so sass also created this other sub language called prox sql um So here it is an example of prox sql I showed you I think I ran all of these first. You have to run everything in order. Let me just make sure And that's a good shape. Um, oh, yeah, so I was showing you this contents I forgot what this is. Yeah, this was that framing ham data set. So there's a whole bunch of old fashioned variables in there See it's hard to kind of navigate this thing here. Um Okay, so then here's the code see i'm going back and forth here So let's look at what this says. So prox sql So already that's what's weird, right because see this prox contents that we just ran Prox contents data equals blah like you usually have a whole bunch of stuff But way prox sql works is you declare it and then you put all of your commands in between that And quit and then you put a run normally you put just a run, but here you have to put quit and run Okay, that's what happens when you you didn't think of it to begin with and then name it sql And then you have to do this. So what does this say this says create table fram underscore a From select all add select all from f framing ham. So this is just doing the same thing here renaming the table a different name Um, but just using prox sql. So let's see what happens when we run this And so when I was doing my data warehouse the problem I had this looks like it ran We can go here. Um, yeah, it looks good Um, the problem I had is I could not get good input output efficiency from prox sql I just couldn't do it and so um So I was like I was using pc sass now if I had been using the server a server Maybe I've asked people this question Since then like people who I know have a sass job in the server I'm like it's prox sql and I've tried to google it I think nowadays now just to remind you prox sql kind of relies on some Artificial intelligence of optimization, you know, so maybe if you're a really good data stepper probably you're better than prox sql Um, I would guess but I don't know. I haven't been able to figure it out. If you know, tell me Um, all right, and then let's see here. So these are Uh import risk table So this is importing I'll I'll just run this whole things. I don't know what the I forgot what the rest of the code does So I just wanted to make sure so, you know, I run this whole thing. It's been days So I'll ask look at but I just scroll up to the log. I don't see any errors. So I feel pretty good, right? So this was this was 105 that I ran. So let's open 115 here So I revamped the live name here and it says need to remove rows for rand id's for people who had BP meds equal one of baselines So this creates a table of id's with the flag So let's create table BP med id's as select rand id. This is the id From fram b. I guess I must have advanced the name of it where BP meds equals one and period equals one and then um I did alter table to add this exclusion flag And then I run this content. So one of the things you end up doing a lot Is you'll do an etl step like this and then you'll do a contents um like in r what I'll do is an etl step and I'll do and enrol the etl step and then enrol to verify I'm If I'm removing rows Or if I'm adding columns I'll do and call sometimes Let's run this and see what happens file or frambi Yeah, so see that's what an error looks like. I guess something didn't run from my last Yeah, it looks like something didn't happen from my last last code. So um, probably this isn't the best code to demonstrate um, let me go look at What we've got under x Here we've just got some data And notice how I just clicked on it. This is from the brfs. I just kind of threw it in here in case I wanted to Demonstrate anything you probably recognize that. Let me go back to the chat and just see if any of these got any questions Let me take a dream tool okay, so Let's say let's uh Not do a little program before I'll come back to that Okay, so let's say so I get this question a lot from people because they taking class courses in data science and not um Not necessarily sass just any courses in data science and It's not that hard to learn programming and so if you want to learn programming like I have two courses on LinkedIn learning in sass But there's different ways to learn sass. There's other sass courses on LinkedIn learning I think data camp has them and then also I want to tell you um sass itself has a lot of courses it's got um Like you can go through what used to happen Like in the 90s and early 2000s is you'd want to learn sass And you want to get hired and let's say you got your master's degree in statistics But then you still had work and you wanted to be competitive So what sass would do is put you through these certifications and sometimes your workplace would pay for them And they're very expensive and I don't have any of them And the reason I don't have any of them is the certifications would teach All those things I try to avoid doing in sass because I don't think they're a good idea And I and I guess the reason they would teach that is because they needed to maintain these old systems But I was like no these systems are very expensive like If you have a programmer and they cost a hundred dollars an hour and It takes them A lot longer in sass to program the etl than an r Then sass is a very expensive um Language and that's been the problem with sass for a very long time is it's very hard to program It takes a long time like things that take like one or two steps in r take like five steps in sass And so if you've got sass programmers You're paying like three times as much for anything they do And so my idea is to just minimize what they do the other thing that you we have problems with is we had very bad I o input and output So sometimes our our sass programmers were really good They were contractors that were really good, but the problem is sometimes I'd see her angrily playing solitaire because the pc sass we were stuck with was slow Now if you're wondering well, why did you have so much trouble getting um a sequel server when you had pc sass like Isn't that easy? We even had an instance of sequel server What happens is if you're a woman and you run a data center everybody's just trying to take you down like They I knew it would happen Or I didn't know it would happen It didn't happen the last time I ran a data thing that I got lucky this time and they just try to take it down They they star view staff. They try to make sure you don't have any staff. They try to make sure you don't have a budget and Like this problem they made sure I didn't have the software I needed or you know So this is how women are just thrown under the bus in um the workplace and that's why we don't run data warehouses very much and so um But anyways, so therefore My data warehouse that I was running it does. I don't think it exists anymore You know, if you look around for it, it's not really clear if it exists or it was moved to another command It was at the army. Um but anyway, so um So it's important to um use the right thing for the right purpose And if you're actually at a sass server If we we had a sass server, it wouldn't have been any problem, but wait at Okay, so but now today If you're learning sass today You know, why are you doing it, right? Well, maybe it's because you want a job working at a sass place Maybe not but let's say it is Then the next thing you're going to want to do is you're going to want to apply that knowledge And that's why i'm so happy we have sass on demand for academics is because then you can apply the knowledge now um a lot of you if you've seen my um live streams or uh other even just my youtube channel, you'll know that I um I put up on my blog an example of I guess what you call portfolio project, which i'm going to share here um, so here you go and I can put as much Always getting solo more Okay, um now I as it turns out whoops as it turns out I used r for this example, okay At the time I made it which a while back I had to use r because we didn't really have sass, right? um, what I did was I'm those of you've probably seen this before but um, I like to go to the casinos I live in massachusetts and we only have three casinos And because our casinos are regularly they have to donate they have to put in some data report some data to the state and I found the data online and see where it is here and I so um uh added like other um Other data like I found some data from the american gaming association just public data And I made some charts and made some recommendations for them And this is a great example of a portfolio project and it's because I'm hoping you know, maybe they'll hire me and my friend I've got a fintech data scientist friend That I like to go to the casino with because to be honest with you I haven't been very happy with this casino because I'm a vegetarian in their um Restaurants so I have a lot of vegetarian options, you know But let's say that I wanted to update this Maybe I would do it in sass, right? But until now I couldn't really do it in sass now. I've we've got the sass oda So it's possible to do um So one of the things that I was going to do. Oh, let me show you what I was going to make those of you who um Let me see here Okay, what I'm sharing here is a web page. It's a blog post Um, let me see here. I put it in the chat um It's a blog post I made about my free course And the reason is I well, of course I wanted to explain stuff about it um And here's me so I just stuff about it. But what I wanted to do was lay out um Kind of a learning path and all the different courses. I've only made the first two the free one in the first of the series Because I don't have that many people taking it yet after I make the rest of them. You can see there's a learning path here the Data warehouse manager would take these the beginner programmer would take these and the advanced programmer would take these um Because some of these are just for programming It just teaches you how to program and some of these are more for the data warehouse manager um And and again, this is based on the code that I made for my book um As you can see like one of the big questions I have is Using sass macros macros which I mentioned before and actually let me just say something about macros Before we go too far Let's see here So a lot of people have questions about macros and they're like monoclonal. I'm scared of macros You should be okay because they are scary But what I tell them is relax macros only come After you're frustrated with your code because you have to keep rerunning it So macros are really only for automated functions And how do you know you want to automate a function? It's because you're doing it all the time So if you are doing a research study where you're going to analyze the data and do a regression Then it's over you probably don't want any macros the macros are really for like production stuff And um Like uh, like low etl. That's what I would use it for in the warehouse macros are good for reporting And actually, you know, I should probably I can show you my um Let's see here If you go to my oh by the way, so I put up the celebrate black history. Um, look at these Black women in data science and in science Who I follow I I think um, one of them. I'm really excited about who is Um, dr. Sellers. She was named an asa fellow. So she does stuff with um distributions and dispersion So if you come over here, you'll see I have two Um, uh playlists sass reporting macros for beginners and sass etl macros for beginners And these are nice because they just kind of explain um here, um Well, you probably know where my channel is but I can They're um So that what's nice about those is they they're I'm just emphasizing um The philosophy behind the macros the coding is really simple because when you make macros They usually end up being pretty involved because you're automating something that you Do every month or every time you live the data and uh, and you have to sometimes set conditions on it like um Like I show a simple example of setting uh conditions Let's see here how to do the content Yeah, this conditional macro, um, because sometimes like you'll have you'll do this batch processing But there's a few variables that don't follow exactly the rules So you have to put a condition in and so you can kind of get the feel for that And also I put up, um My recommended sass white papers um, so so macros are always just a topic I get People asking about um Let me see here another topic I get well, I get a lot on data data steps And also arrays and I tried to post some things on arrays too Actually, let me go back to the list of um, oh, let's see here These are the courses I plan to make um Some of these are very important to um managers The ones on the with the x on the way left are important to managers um And these are the ones that you if you want to be a data warehouse manager You definitely want to read this book because this would be good. Um, oh, there was something I wanted to show you I saw recently um One thing that sass can do sass via And sass not via I think sass enterprise And that is make dashboards But please don't do it. It's not a good idea Okay, one of the dashboards that was made was the kovat 19 dashboard that was made in sass Not good And recently I've been working with um a colleague and she showed me this one data This database that's online and I think it's in sass and I'm going to show it to you I'm pretty sure it's in sass because it just doesn't even really run very well So, let me do let me go find it. Um, let's see here Let's see here I should have done this before I got on global burden of disease gbt Database Here it is Okay, uh, let me see if I clicked actually The reason I'm coming so now is I'm having trouble connecting. Okay. Let me let me um Oops We've got the wrong thing Okay, so let me go to um Here it is Okay, and I'll give you where I am here. I'll send put that in the chat Okay So the this I think I'm pretty sure is a sass front end Okay, so what's going on here? um These the this is ostensibly querying the global health data exchange But I would not Really recommend this database and it's because I do not think it's well curated If you dig around in it, you can find some documentation for what you need But I really do not think it is very clear. Um It's hard to tell what countries what data is available in what countries it's just hard to tell all of that stuff Um, you've seen me probably in other live streams where I point out Places that have really good data curation just makes it really easy to design your study This is the opposite that data curation is horrible. Okay so, um Let's say that you want to do this query Okay And remember this is a global burden of disease database So it's for comparing disease in countries And so let's let's just try to do that here um I'm not really sure. I I guess I would leave this on global Or maybe we'll do location Yeah, here. Let's So we want to choose something see how these are are grouped Like hierarchically. Well, what if I don't want those groups, right? What will happen is if I choose like for example, let's say I choose poland and I choose, um Estonia Um, then they're going to come out in their own strata, right and see how you cannot really see your selections here And then the this is the most recent year. Let's just throw that in there And then this says cause later when I experiment with this I realize that changing this changes this form We won't change it now, but apparently you can query other data sets and that's what this does So this is age and I guess we have all ages And then this says metric number percent and rate and I want to I'll leave them all there And then measure it says deaths and dollies now remember These things these years live with disabilities. So these are really Um bsc calculations and the reason they're bsc is because these countries the data that goes into these who knows Now, I I mean, they're they're validated on weird data, you know I don't totally reject these because I think you need a metric to compare countries But individually I would never look at these, you know, so I think um like prevalence is what we want And then uh Sex is all and causes all okay. So now we click search, I guess Um Now the person I was helping with this We were trying to request data from them And they were like well, you can download it, but we would have to download this right and this isn't really look right Okay, so here's Estonia and Poland And here's like the number the percent and the rate And the percent is oh, I guess we didn't choose Problems cause Oh, we didn't choose a cause let's choose a cause See and this is where we ran into trouble because if you want to just choose like like Can you imagine using this? This is awful. I don't even know like I think you can tie it The others I'll call it in here. Um, let's see here. Oh, this is 2019. Why don't we do cardiovascular disease? Okay, this is a fun one Okay, now now we'll um search At least we get to see who's 100% in here. Okay So, uh, what do we have here? We have all causes. I guess I accidentally chose all causes and cardiovascular Okay, so in Poland, here's the number of people and this is the confidence interval. Where does this come from? Remember earlier. I was showing you prox survey reg um It's not that but but one of those prox will take um Way to data sets and come out with this and the prevalence so in the poll in the prevalence of cardiovascular disease is about 11 percent Whereas in Estonia is probably 15 percent. Well, let's just see what it's like in um In the u.s. Maybe right? Okay Now when I search again, um Oh, good. I didn't lose it. I lost it before when I was working with my colleague. Okay Now here we've got all causes. Okay, so in the u.s. We've got about 12 percent You know, I don't really believe that, you know, because most of it's undiagnosed Right, uh, do you really believe that? We're that close to Poland in Estonia You don't like I just have trouble believing it and think of how painful it is to do this query Like can you believe it's 2022 and this is what you're doing with sass, right? So that's my like a long, um Demonstration to say that you should not use sass Um for dashboards. I mean, I guess if you're stuck to doing it Go ahead and do it, but try to use like our studio. Try to use something open source because Actually, I just published a book chapter with my um With my intern And it's on Like dashboarding and the ethical side of dashboarding When you make a dashboard people should be able to tell where the data is coming from and all that You know, they shouldn't it shouldn't be confusing and it shouldn't be like misleading and Like that dashboard we I was just looking at it's very confusing and very misleading and If that was an attempt at open government data That was a failed attempt because I can't get the data out. I can't use it, you know And I'm trying to you know, a lot of times people get mad When I complain about their app their data applications, but I asked them What what did you intend the functions to be in this application? Because every application can't do everything, you know, what is the goal of this? That's why it's nice with r. You've got these packages. You can custom make a function for that particular, um Uh situation and and then just deploy it there But you know, and I do care, you know, I I am cognizant of that sass was built in a different era You know sass sort of gets a pass because It was just amazing to build it in the first place So yes, you run a proc contents. You're going to get all the contents you ever wanted, you know You run a proc freak. That's a frequency. You're going to get more output than they ever wanted, right? But at least you get output um You know now That's overkill and it's a lot easier, you know Like it's harder to sort of suppress sass's output than it is to just use r. You know So that's why I'm trying to encourage people to at least learn sass because you're gonna have to do some sass our integration You probably will um, and also, you know a lot of times people have trouble learning sass And I can't say I'm the best sass program in the world But I can I can help you figure it out because if you've run a data warehouse and you're the top You have to figure out everything And so if you ever have a sass problem or you're trying to do project, you know, we can work together I do a lot of mentoring at sass and um and help I can help you with whatever part of the project you're you're working on um, and basically What I often do is I often um get a white paper. So Let me maybe I'll share my screen here. We'll do uh Yeah, sass. I'll go back to this one here So, um imagine you wanted to learn like uh, like How to do a data pipe, right data pipe sass white paper see how I'm doing this query it showed up on I did it Yeah, so, um So notice how notice the kind of um results I'm getting This one says support dot sass dot com Okay, and it says these numbers. That's not going to be a sass white paper. That's going to be sass support Now, I don't want to ding sass support because they're very comprehensive But I have trouble using it I I only use sass support if I want to know like details about the prox or the function I do not use it if I troubleshoot in code because they usually don't have code snippets or examples, right? so here Down here, this says mwsug that stands for midwest sass user group whenever you see sug That's probably good because it's actually users. So let's let's actually open this Just see what it looks like um Yeah, it is a sass white paper. Um, you probably can't see it because I opened another window. Um Now can you see it? I'm getting you see. Yeah, so, um So this is a sass white paper and if you're like, well, um sass commands pipe and call execute dynamically advancing from strangers to your new bff best friends forever You're probably wondering Is this real And the answer is yes, it's real All of the sass white papers are real and they're really important like they'll really help you in life So it's hard to believe right? Where are they? They're all over the place like you can kind of find them like Here you'll see some are posted at a school Whenever you see lex jansen I think there are some consultants that do a lot of sass white papers Here's another one. Um, this one Like all of these usually Come from a user group meeting But sometimes tell like I see this 2012 up here And that probably means that was some meeting in 2012, but they never get old because sass never really innovates like these little details like whatever they build they don't rebuild it and so um So this file name statement still runs the same way unless they maybe tweak it a little bit, but that's it and so, um So sass white papers are kind of like we're there before the internet was there And you'd pass them around and that was kind of how you got through things So what I'll do is I'll um I'll go and I'll try to find if I'm trying to help A customer I'll try to go find like a sass white paper um that matches, uh, what their issues are and then um, and then I go and I try to use that, um Those examples in the programming Let me see here. I like literally it looks like nobody showed up, you know, like it's here's the problem, right? I've got this little Counter on here that says there's zero people here But it has said that the whole time and there've been people talking so I don't really know how many people are really here So if anybody's actually here and you want to continue the stream with me Um, probably now you should say something because I'm thinking like nobody's here And I'll probably just end the stream. I thought more people would show up because who wants, uh, uh Anything better than like a sass brunch, right? Like your food tastes pretty good But just add a little sass. It's going to taste better I guess it's just not not a popular thing. Well, anyway, those of you who did show up. Thank you for coming And I guess I should have probably advertised this a little bit more. Um, and the next time I will and then, uh, also, um Don't forget to uh Come to my channel. I'm going to try I've been a little busy lately Um, but I'm going to try and put up some more videos I'm going to try I've been writing some papers And I'm going to try and take some code that from those papers and do some blog posts and put it up there All right. Well, thanks to everybody who did show up and uh, so I'm going to sign off early Um, and have a good sunday if you're watching this and if you're watching this have a good day