{"id":3581,"date":"2013-09-04T00:18:22","date_gmt":"2013-09-04T05:18:22","guid":{"rendered":"http:\/\/www.thejuliagroup.com\/blog\/?p=3581"},"modified":"2013-09-04T00:18:22","modified_gmt":"2013-09-04T05:18:22","slug":"exploring-your-data-with-sas-enterprise-guide-important-basics","status":"publish","type":"post","link":"https:\/\/www.thejuliagroup.com\/blog\/exploring-your-data-with-sas-enterprise-guide-important-basics\/","title":{"rendered":"Exploring Your Data with SAS Enterprise Guide: Important Basics"},"content":{"rendered":"<p>I&#8217;m doing a <a href=\"http:\/\/www.wuss.org\">Hands-On Workshop in Las Vegas at the Western Users of SAS Software conference in November<\/a>. When they asked me for some topics, I thought about factor analysis or categorical data analysis, but I&#8217;m already doing a couple of other talks on those procedures.<\/p>\n<p>I really felt like one of the most overlooked parts of data analysis was exploring your data and getting cozy with it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-3136\" alt=\"Maria and Eva cuddled up\" src=\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/03\/mariaevarobes-225x300.jpg\" width=\"225\" height=\"300\" srcset=\"https:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/03\/mariaevarobes-225x300.jpg 225w, https:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/03\/mariaevarobes-768x1024.jpg 768w\" sizes=\"auto, (max-width: 225px) 100vw, 225px\" \/><\/p>\n<p>So, I&#8217;m talking about exploratory data analysis, with a focus on the basics. There is a lot of talk about BIG data, but many of us spend our days with not-very-big-at-all data where a few errant records here and there can throw off your results.<\/p>\n<p>Also, I don&#8217;t think SAS Enterprise Guide was really designed for ginormous data sets.<\/p>\n<p>My workshop uses data from the pilot study for 7 Generation Games. Before you can go out and collect enormous amounts of data, you need to pilot your measures, your methods &#8211; and at this stage it really is important to understand your data.<\/p>\n<p>One quick tip \u00a0&#8212;<\/p>\n<p>If you do the Characterize Data task (which you always should), it produces a data set of frequency distributions and another of univariate statistics. Notice in the second of the three pop-up windows, that&#8217;s the default. People often ignore those data sets created, which is too bad,<\/p>\n<p><a href=\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/09\/7CharacterizeDataMenu3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-3591\" alt=\"Characterize Data window with defaults\" src=\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/09\/7CharacterizeDataMenu3-300x207.png\" width=\"300\" height=\"207\" srcset=\"https:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/09\/7CharacterizeDataMenu3-300x207.png 300w, https:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/09\/7CharacterizeDataMenu3.png 792w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>You can use the univariate statistics data set to create tables like the one below, selecting which descriptive statistics and variables you want.<\/p>\n<p><a href=\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/08\/reportlist.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-3582\" alt=\"Report of descriptive statistics\" src=\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/08\/reportlist-300x71.png\" width=\"300\" height=\"71\" srcset=\"https:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/08\/reportlist-300x71.png 300w, https:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2013\/08\/reportlist.png 965w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Of much more use than simple reports like this, you can sort your univariate statistics data set to get things like items in order of difficulty. \u00a0As always, I have way more material than I can fit in the time allotted, but one part I will definitely keep in is the usefulness of these data sets for getting a second quick look at your data. (The first is the Characterize Data task. Didn&#8217;t you just read that I said you should always do it? Sheesh!)<\/p>\n<p>If you&#8217;re interested, you can come to the presentation, <em>&#8220;Telling stories with your data &#8211; graphs, tables and basic, basic statistics with SAS Enterprise Guide&#8221;<\/em> in Las Vegas in November. Or you can check back on this blog as I ramble on about it while writing my paper.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m doing a Hands-On Workshop in Las Vegas at the Western Users of SAS Software conference in November. When they asked me for some topics, I thought about factor analysis or categorical data analysis, but I&#8217;m already doing a couple of other talks on those procedures. I really felt like one of the most overlooked&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1,9,8],"tags":[],"class_list":["post-3581","post","type-post","status-publish","format-standard","hentry","category-dr-de-mars-general-life-ramblings","category-software","category-technology"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/3581","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/comments?post=3581"}],"version-history":[{"count":2,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/3581\/revisions"}],"predecessor-version":[{"id":3592,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/3581\/revisions\/3592"}],"wp:attachment":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/media?parent=3581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/categories?post=3581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/tags?post=3581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}