{"id":5782,"date":"2019-12-01T16:40:57","date_gmt":"2019-12-01T21:40:57","guid":{"rendered":"https:\/\/www.thejuliagroup.com\/blog\/?p=5782"},"modified":"2020-01-19T02:28:53","modified_gmt":"2020-01-19T07:28:53","slug":"why-use-sas-as-a-statistical-consultant","status":"publish","type":"post","link":"https:\/\/www.thejuliagroup.com\/blog\/why-use-sas-as-a-statistical-consultant\/","title":{"rendered":"Why use SAS as a statistical consultant?"},"content":{"rendered":"\n<p>Anyone who uses SAS (or doesn&#8217;t) probably has their own reasons. I have a few but a major one is the ease of importing just about any type of data. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Mo&#8217; clients, Mo&#8217; problems<\/h2>\n\n\n\n<p>There are multiple types of consultants. I&#8217;m the type who is, literally, all over the map. I&#8217;ve been in five countries this year and I think 11 states plus the District of Columbia, but I might have left off a couple. I said 9 in a post on <a href=\"http:\/\/drannmaria.blogspot.com\/2019\/11\/my-life-not-on-instagram.html\">a different blog where I occasionally write about my life and judo<\/a>, but then I remembered I&#8217;d been in Texas for <a href=\"https:\/\/www.sas.com\/content\/dam\/SAS\/support\/en\/sas-global-forum-proceedings\/2019\/3561-2019.pdf\">SAS Global Forum where I gave a talk on biostatistics<\/a> and also in New Mexico speaking on transition from school to work for tribal youth with disabilities.<\/p>\n\n\n\n<p>What that means is that I work with a wide range of organizations and their data is not all in the same format. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">If you work with a wide range of clients, ease of data import matters<\/h3>\n\n\n\n<p>If you&#8217;re a consultant who works consistently with one client, data formats may not be your biggest issue. You probably wrote a program to read in that data, no matter what messy format it was in and you&#8217;re good to go. In my case, though, every dataset, every project is different. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">All the data, all the time<\/h2>\n\n\n\n<p>In the previous post, <a href=\"https:\/\/www.thejuliagroup.com\/blog\/dont-believe-your-numbers-too-much-ipeds-example\/\">I mentioned reading in the IPEDS data<\/a>, which is a relatively small public data set (around 7,000 x 60).  Fantastically, that came with a SAS program so all I needed to do was upload the raw data file and change the INFILE statement.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>A couple of years ago,<a href=\"https:\/\/www.thejuliagroup.com\/blog\/watch-me-work-data-project\/\"> I wrote about getting data from PHPMyAdmin into SAS Enterprise Guide<\/a> just by doing  a lot of pointing and clicking. <\/li><li>Earlier this year, <a href=\"https:\/\/www.thejuliagroup.com\/blog\/reading-json-data-saved-in-a-column-and-other-sas-string-function-tricks\/\">I mentioned reading JSON data that had been saved as a string in an SQL database into SAS<\/a> , all it took was a DATA step and liberal use of the INDEX function.<\/li><li>SAS also works well for reading in extremely large data sets, <a href=\"https:\/\/www.thejuliagroup.com\/blog\/success-with-sas-web-editor\/\">older data sets that used really old versions of SAS<\/a> and I&#8217;ve even used it once to import a very large Excel file which the customer had omitted to tell me was in Korean. I haven&#8217;t had to use PROC CPORT for a while so I&#8217;m hoping to have work that requires that at some point so I can test it out again.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Proc import does not a consultant make<\/h3>\n\n\n\n<p>Maybe when you were a student you <a href=\"https:\/\/www.thejuliagroup.com\/blog\/these-are-a-few-of-my-favorite-procs-i-import\/\">imported your data sets by a PROC IMPORT step<\/a>. This isn&#8217;t terrible. You should use this procedure when you can. However, you&#8217;re going to need to go several steps further.<\/p>\n\n\n\n<p>Even worse, if you&#8217;ve been getting your data by simply using the LIBNAME statement your professor provided you or doing some pointy-clicky thing with SAS Studio or Enterprise Guide (or SPSS) you have a lot to learn.<\/p>\n\n\n\n<p>Every year, I have graduate students who tell me they are going to become consultants. More often than not, I shake my head and think,<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>&#8220;You have no idea what you are getting into.&#8221;<\/p><cite>&#8211; Me<\/cite><\/blockquote>\n\n\n\n<p>If you are going to be working as a statistical consultant for a variety of clients, far more than PROC LOGISTIC or PROC GLIMMIX, your time is going to be spent in the DATA step. <\/p>\n\n\n\n<p>It&#8217;s not just a matter of data formatting or missing data, but of creating the data you need that isn&#8217;t there. What do I mean by that? Ha ha, that is a future blog post that I may write next time I&#8217;m on a plane somewhere and have a spare moment. Probably tomorrow.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re the kind of statistical consultant that has a range of clients, the ability of SAS to easily read lots of data formats is a godsend for you.<\/p>\n","protected":false},"author":2,"featured_media":5783,"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":[28],"tags":[],"class_list":["post-5782","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-30-consulting-tips"],"jetpack_featured_media_url":"https:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2019\/12\/IMG_1822.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/5782","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/comments?post=5782"}],"version-history":[{"count":6,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/5782\/revisions"}],"predecessor-version":[{"id":5805,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/5782\/revisions\/5805"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/media\/5783"}],"wp:attachment":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/media?parent=5782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/categories?post=5782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/tags?post=5782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}