I’m just heading off to the Western Users of SAS Software meeting that starts tomorrow.\u00a0 After the keynote, during which I have promised not to swear even once, I’m doing a SAS Essentials talk on Thursday, where I teach students 10 basic steps that allow them to complete an entire annual report project.<\/p>\n
One of these is PROC DATASETS.\u00a0 It is used twice in the project. First, they get a list of all of the datasets in the directory. We’re using SAS Studio which runs on the SAS server. Since students neither have access to issue Unix commands directly nor do they know any most likely, we use PROC DATASETS. This gives me the output below.<\/p>\n <\/p>\n Once we have cleaned up the data in every data set, we are not quite ready to start merging them together. A common problem is that data sets have different names, lengths or types for the same variable. You\u2019d be wise to check the variable names, types and lengths of all the variables.\u00a0 So, here is where we use PROC DATASETS a second time. This time, we added another statement. The \u201ccontents data = _all_ \u201c will print the contents of all of the data sets. In perusing the contents, I see that grade is entered as character data in one \u2013 5th, 4th and so on, while it is numeric data in another. This is the sort of thing you never run into in \u201cback of the textbook\u201d data, but that shows up often in real life.<\/p>\n Those are two super simple steps that allow you to do useful things.<\/p>\n You can do more with PROC DATASETS – append, compare – but my plane is boarding so more about that some other time.<\/p>\n <\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" I’m just heading off to the Western Users of SAS Software meeting that starts tomorrow.\u00a0 After the keynote, during which I have promised not to swear even once, I’m doing a SAS Essentials talk on Thursday, where I teach students 10 basic steps that allow them to complete an entire annual report project. One of…<\/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":[9],"tags":[],"class_list":["post-4238","post","type-post","status-publish","format-standard","hentry","category-software"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/4238","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=4238"}],"version-history":[{"count":4,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/4238\/revisions"}],"predecessor-version":[{"id":4242,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/4238\/revisions\/4242"}],"wp:attachment":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/media?parent=4238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/categories?post=4238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/tags?post=4238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\nlibname mydata\u00a0 \"\/courses\/u_mine.edu1\/i_1234\/c_7890\/wuss14\/\";
\nproc datasets library= mydata ;<\/code><\/p>\n\n\n
\n #<\/strong><\/td>\n Name<\/strong><\/td>\n Member Type<\/strong><\/td>\n File Size<\/strong><\/td>\n Last Modified<\/strong><\/td>\n<\/tr>\n<\/thead>\n\n \n 1<\/strong><\/td>\n SLPOST_SCORED<\/td>\n DATA<\/td>\n 208896<\/td>\n 26Jun14:04:00:40<\/td>\n<\/tr>\n \n 2<\/strong><\/td>\n SLPRE_SCORED<\/td>\n DATA<\/td>\n 487424<\/td>\n 26Jun14:04:00:41<\/td>\n<\/tr>\n \n 3<\/strong><\/td>\n SL_ANSWERS<\/td>\n DATA<\/td>\n 619520<\/td>\n 26Jun14:03:59:42<\/td>\n<\/tr>\n \n 4<\/strong><\/td>\n SL_PRE_POST<\/td>\n DATA<\/td>\n 196608<\/td>\n 26Jun14:04:00:03<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n
\nproc datasets library= work ;
\ncontents data = _all_ ;<\/code><\/p>\n