{"appState":{"pageLoadApiCallsStatus":true},"categoryState":{"relatedCategories":{"headers":{"timestamp":"2025-04-17T16:01:06+00:00"},"categoryId":33579,"data":{"title":"Databases","slug":"databases","image":{"src":null,"width":0,"height":0},"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Information Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33572"},"slug":"information-technology","categoryId":33572},{"name":"Data Science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"},"slug":"data-science","categoryId":33577},{"name":"Databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"},"slug":"databases","categoryId":33579}],"parentCategory":{"categoryId":33577,"title":"Data Science","slug":"data-science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"}},"childCategories":[],"description":"All that data's gotta go somewhere. And it's usually in a database of some kind. Learn about records management, SAS best practices, and more.","relatedArticles":{"self":"https://dummies-api.dummies.com/v2/articles?category=33579&offset=0&size=5"},"hasArticle":true,"hasBook":true,"articleCount":8,"bookCount":8},"_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"}},"relatedCategoriesLoadedStatus":"success"},"listState":{"list":{"count":8,"total":8,"items":[{"headers":{"creationTime":"2016-03-27T16:51:15+00:00","modifiedTime":"2022-03-25T14:42:17+00:00","timestamp":"2022-09-14T18:19:30+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Information Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33572"},"slug":"information-technology","categoryId":33572},{"name":"Data Science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"},"slug":"data-science","categoryId":33577},{"name":"Databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"},"slug":"databases","categoryId":33579}],"title":"Records Management For Dummies Cheat Sheet","strippedTitle":"records management for dummies cheat sheet","slug":"records-management-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Learn the key aspects of records management, including the benefits, retention scheduling, and managing on local and network drives.","noIndex":0,"noFollow":0},"content":"Whether you’re a small business owner or work for a global corporation, you deal with information every day. You receive information, you send it, you determine what’s relevant, and you make decisions, whether consciously or subconsciously, about what information to retain. That’s why records management — managing the flood of information you get every day — should be such an important part of your business strategy.\r\n\r\nThis Cheat Sheet can serve as a quick reference to some of the main aspects of record management.","description":"Whether you’re a small business owner or work for a global corporation, you deal with information every day. You receive information, you send it, you determine what’s relevant, and you make decisions, whether consciously or subconsciously, about what information to retain. That’s why records management — managing the flood of information you get every day — should be such an important part of your business strategy.\r\n\r\nThis Cheat Sheet can serve as a quick reference to some of the main aspects of record management.","blurb":"","authors":[{"authorId":9881,"name":"Blake Richardson CRM","slug":"blake-richardson","description":"Blake Richardson, CRM, is a certified records manager with more than 15 years of experience managing records and information for several Fortune 500 companies. He has been a records manager for CNA Insurance and the Dollar General Corporation, and is active in ARMA International. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9881"}},{"authorId":9882,"name":"CRM","slug":"crm","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9882"}}],"primaryCategoryTaxonomy":{"categoryId":33579,"title":"Databases","slug":"databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":208741,"title":"Kabbalah For Dummies Cheat Sheet","slug":"kabbalah-for-dummies-cheat-sheet","categoryList":["body-mind-spirit","religion-spirituality","kabbalah"],"_links":{"self":"/articles/208741"}},{"articleId":230957,"title":"Nikon D3400 For Dummies Cheat Sheet","slug":"nikon-d3400-dummies-cheat-sheet","categoryList":["home-auto-hobbies","photography"],"_links":{"self":"/articles/230957"}},{"articleId":235851,"title":"Praying the Rosary and Meditating on the Mysteries","slug":"praying-rosary-meditating-mysteries","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/235851"}},{"articleId":284787,"title":"What Your Society Says About You","slug":"what-your-society-says-about-you","categoryList":["academics-the-arts","humanities"],"_links":{"self":"/articles/284787"}}],"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}},{"articleId":173432,"title":"Managing Records on Local and Network Drives","slug":"managing-records-on-local-and-network-drives","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173432"}},{"articleId":173421,"title":"Benefits of Records Management","slug":"benefits-of-records-management","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173421"}}],"fromCategory":[{"articleId":285910,"title":"Data Lakes For Dummies Cheat Sheet","slug":"data-lakes-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/285910"}},{"articleId":207503,"title":"SAS For Dummies Cheat Sheet","slug":"sas-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207503"}},{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}},{"articleId":173432,"title":"Managing Records on Local and Network Drives","slug":"managing-records-on-local-and-network-drives","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173432"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281849,"slug":"records-management-for-dummies","isbn":"9781118388082","categoryList":["technology","information-technology","data-science","databases"],"amazon":{"default":"https://www.amazon.com/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1118388089-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/records-management-for-dummies-cover-9781118388082-203x255.jpg","width":203,"height":255},"title":"Records Management For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p>Blake Richardson, CRM, is a Certified Records Manager with more than 15 years of experience managing records and information for several Fortune 500 companies. He has been a records manager for CNA Insurance and the Dollar General Corporation, and is active in ARMA International.</p>","authors":[{"authorId":34784,"name":"","slug":"","description":" <p><b> Joseph A. Allen, PhD</b> is a professor of industrial and organizational (I/O) psychology at the University of Utah. His articles have appeared in <i>Human Relations, Journal of Business Psychology</i>, and more.</p> <p><b>Karin M. Reed</b> is CEO of Speaker Dynamics, a corporate communications training firm. She is an Emmy award-winning broadcast journalist. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/34784"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118388082&quot;]}]\" id=\"du-slot-63221b32a37cf\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118388082&quot;]}]\" id=\"du-slot-63221b32a41a5\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":173421,"title":"Benefits of Records Management","slug":"benefits-of-records-management","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173421"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}},{"articleId":173432,"title":"Managing Records on Local and Network Drives","slug":"managing-records-on-local-and-network-drives","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173432"}}],"content":[{"title":"Benefits of records management","thumb":null,"image":null,"content":"<p>Properly managing your records can help you reduce operating expense, enhance customer service and ensure your company is in compliance with laws and regulation.</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\"><b>Reduce operating expense.</b> Properly managing your records and information means that you only retain for a specific timeframe what you need for operational, legal, and compliance purposes and then appropriately dispose of it. This approach can eliminate the need to buy additional paper filing equipment and electronic storage. It can also reduce the cost of off-site record storage.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Enhance customer service.</b> A good records management strategy ensures that you don’t retain unneeded information. This reduces the amount of clutter you have to search through. Being able to quickly locate the right information allows you to better serve your customers.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Legal and compliance.</b> Implementing an effective records management program will allow you to identify records that are needed for legal and compliance purposes and ensure they are assigned the appropriate retention periods. This benefits organizations in the event of lawsuits, audits, and governmental inquiries.</p>\n</li>\n</ul>\n"},{"title":"Appraising records and managing retention scheduling","thumb":null,"image":null,"content":"<p>A fundamental part of a successful records and information management program is identifying what records and information your company possesses and then applying appropriate retention periods.</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\"><b>Records appraisal.</b> There are different methods for appraising your records and information, including inventories, interviews, and questionnaires. Picking the right appraisal method for your organization is important. The appraisal allows you to identify what records and information the organization possesses and forms the basis for your company’s record retention schedule.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Retention schedule.</b> The retention schedule is typically the most referenced records management program document. It allows employees to determine how long they should keep their records and information. <i>Records Management For Dummies</i> addresses three distinct retention schedule methods: departmental, functional, and big bucket.</p>\n</li>\n</ul>\n"},{"title":"Managing records on local and network drives","thumb":null,"image":null,"content":"<p>The amount of electronic information has grown exponentially over the past decade. Local (C: Drives) and network drives are becoming digital graveyards. An effective records management program will provide you with the knowledge and tools you need to ensure that electronic files are properly managed.</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\"><b>Folder structures and names.</b> Creating an electronic folder structure that meets the needs of each department and ensuring that the folders within the structure are logically named are critical for accurate electronic filing, retrieval, and file maintenance (clean-up).</p>\n</li>\n<li>\n<p class=\"first-para\"><b>File naming conventions.</b> After you have created the proper electronic folder structure, it’s important to ensure that your files are also named in an appropriate manner. A rule of thumb for naming your files is that you should be able to determine the contents of a file without having to open it. This means avoiding cryptic names such as abbreviations, acronyms, and numbers.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Maintenance.</b> It is important to regularly review your folders and files to determine what is no longer needed. Microsoft Windows allows you to determine the last access and modification dates of a file. This is a good starting point in determining whether a file can be deleted. However, employees should always reference the organization’s record retention schedule before deleting any files in order to determine if the file is eligible for deletion.</p>\n</li>\n</ul>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Two years","lifeExpectancySetFrom":"2022-03-25T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":208207},{"headers":{"creationTime":"2016-03-27T16:47:09+00:00","modifiedTime":"2022-03-01T18:08:45+00:00","timestamp":"2022-09-14T18:19:18+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Information Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33572"},"slug":"information-technology","categoryId":33572},{"name":"Data Science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"},"slug":"data-science","categoryId":33577},{"name":"Databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"},"slug":"databases","categoryId":33579}],"title":"SAS For Dummies Cheat Sheet","strippedTitle":"sas for dummies cheat sheet","slug":"sas-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Learn how to choose the right statistical analysis system (SAS) product and use this handy list of procedures in the SAS Enterprise Guide.","noIndex":0,"noFollow":0},"content":"SAS Institute has hundreds of statistical analysis system products, so a partial list of the ones you might run will help you know which one to use for your job.\r\n\r\nThe tasks in <a href=\"https://support.sas.com/en/software/enterprise-guide-support.html\" target=\"_blank\" rel=\"noopener\">SAS Enterprise Guide</a> and SAS Add-In for Microsoft Office create SAS programs that call on SAS procedures. Having a list of those procedures and being able to find them quickly in SAS Enterprise Guide will boost your efficiency.","description":"SAS Institute has hundreds of statistical analysis system products, so a partial list of the ones you might run will help you know which one to use for your job.\r\n\r\nThe tasks in <a href=\"https://support.sas.com/en/software/enterprise-guide-support.html\" target=\"_blank\" rel=\"noopener\">SAS Enterprise Guide</a> and SAS Add-In for Microsoft Office create SAS programs that call on SAS procedures. Having a list of those procedures and being able to find them quickly in SAS Enterprise Guide will boost your efficiency.","blurb":"","authors":[{"authorId":9190,"name":"Stephen McDaniel","slug":"stephen-mcdaniel","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9190"}},{"authorId":9191,"name":"Chris Hemedinger","slug":"chris-hemedinger","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9191"}}],"primaryCategoryTaxonomy":{"categoryId":33579,"title":"Databases","slug":"databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":208741,"title":"Kabbalah For Dummies Cheat Sheet","slug":"kabbalah-for-dummies-cheat-sheet","categoryList":["body-mind-spirit","religion-spirituality","kabbalah"],"_links":{"self":"/articles/208741"}},{"articleId":230957,"title":"Nikon D3400 For Dummies Cheat Sheet","slug":"nikon-d3400-dummies-cheat-sheet","categoryList":["home-auto-hobbies","photography"],"_links":{"self":"/articles/230957"}},{"articleId":235851,"title":"Praying the Rosary and Meditating on the Mysteries","slug":"praying-rosary-meditating-mysteries","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/235851"}},{"articleId":284787,"title":"What Your Society Says About You","slug":"what-your-society-says-about-you","categoryList":["academics-the-arts","humanities"],"_links":{"self":"/articles/284787"}}],"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}},{"articleId":143291,"title":"SAS Procedures and Their Location in SAS Enterprise Guide","slug":"sas-procedures-and-their-location-in-sas-enterprise-guide","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/143291"}}],"fromCategory":[{"articleId":285910,"title":"Data Lakes For Dummies Cheat Sheet","slug":"data-lakes-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/285910"}},{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}},{"articleId":173432,"title":"Managing Records on Local and Network Drives","slug":"managing-records-on-local-and-network-drives","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173432"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281857,"slug":"sas-for-dummies-2nd-edition","isbn":"9780470539682","categoryList":["technology","information-technology","data-science","databases"],"amazon":{"default":"https://www.amazon.com/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/0470539682-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/sas-for-dummies-2nd-edition-cover-9780470539682-203x255.jpg","width":203,"height":255},"title":"SAS For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9190\">Stephen McDaniel</b> is Principal and cofounder of Freakalytics™ LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b data-author-id=\"9191\">Chris Hemedinger</b> works in SAS R&amp;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. </p>","authors":[{"authorId":9190,"name":"Stephen McDaniel","slug":"stephen-mcdaniel","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9190"}},{"authorId":9191,"name":"Chris Hemedinger","slug":"chris-hemedinger","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9191"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470539682&quot;]}]\" id=\"du-slot-63221b26ddbfa\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470539682&quot;]}]\" id=\"du-slot-63221b26de6ce\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}},{"articleId":143291,"title":"SAS Procedures and Their Location in SAS Enterprise Guide","slug":"sas-procedures-and-their-location-in-sas-enterprise-guide","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/143291"}}],"content":[{"title":"Selecting the correct SAS product","thumb":null,"image":null,"content":"<p>SAS Institute offers hundreds of SAS products, and sometimes it&#8217;s difficult to decide which tool you should use for your work. Here is a <i>partial</i> list of SAS products you might encounter and who uses them for what purpose. As a SAS customer, you might use just one of these products or a few of them; if you&#8217;re really lucky, you might use them all.</p>\n<h2>SAS, or the SAS System</h2>\n<p>The SAS System is the original SAS product that customers have used in one form or another for more than 30 years, on systems ranging from big mainframes to laptops. It&#8217;s also known as Display Manager (the name of the windowing interface), or Base SAS, or just plain old SAS. The SAS System is primarily a tool for people comfortable with writing SAS programs. It contains the data processing and analytics engine that is at the core of most SAS products.</p>\n<h2>SAS Enterprise Guide</h2>\n<p>SAS Enterprise Guide provides a modern, easy-to-use interface to much of the power of SAS. SAS Enterprise Guide is used by SAS programmers, business analysts (who might or might not have programming skills), and statisticians. It’s a Microsoft Windows application that can connect to SAS; you can use it to drive the SAS analytics engine running on a mainframe, UNIX, or other remote machines as a server application. SAS Enterprise Guide is like a general store for SAS, where you can get a little bit of everything that SAS has to offer.</p>\n<h2>SAS Data Integration Studio</h2>\n<p>SAS Data Integration Studio is used to create and maintain data warehouses and data marts, which are specialized stores of data that have been prepared for effective reporting and analytics. Data experts, such as database administrators and IT specialists — people who support other folks who have to create reports — use SAS Data Integration Studio. Like SAS Enterprise Guide, this is a client application that runs on your desktop and provides an intuitive user interface, but it can connect to SAS and databases that run on machines all over your organization.</p>\n<h2>SAS Enterprise Miner</h2>\n<p>SAS Enterprise Miner is used for data mining, or investigating patterns in large amounts of data. Statisticians and professional modelers use SAS Enterprise Miner to segment data and create descriptive or predictive models. For example, a bank might use such a model to predict how likely you are to respond to a certain credit card offering. If your data profile is similar enough to others who have responded to similar offers, SAS Enterprise Miner would produce a model that indicates you&#8217;re worth sending the offer to. Hello, Platinum card!</p>\n<h2>SAS Add-In for Microsoft Office</h2>\n<p>Some people spend most of their working days working with a Microsoft Office application such as Excel or PowerPoint. SAS Add-In for Microsoft Office lets you open SAS data sources and run SAS analyses without ever having to leave the comfy world of your spreadsheet or slideshow. SAS Add-In for Microsoft Office is used by business analysts who don&#8217;t really need to know anything about SAS programming but need the answers that SAS can provide.</p>\n<h2>SAS Web Report Studio</h2>\n<p>All business intelligence software vendors must have a Web-based reporting product, and SAS Web Report Studio fits that bill. SAS Web Report Studio allows you to create and distribute reports to anyone who needs them, all without leaving your Web browser.</p>\n<h2>SAS Forecast Studio</h2>\n<p>SAS Forecast Studio analyzes time-based data and forecasting future trends and events. It&#8217;s like a crystal ball, only better! SAS Forecast Studio is used by professional modelers or statisticians who understand concepts such as seasonality and intermittent demand models. However, no SAS programming is required!</p>\n<h2>JMP</h2>\n<p>JMP is a standalone, highly visual analytics product. It runs on Microsoft Windows, Apple Macintosh, or Linux-based computers. JMP is sometimes packaged with SAS and can work with other SAS products, but most often it&#8217;s used by researchers, engineers, and quality-control experts who want advanced analytics without a big software footprint.</p>\n"},{"title":"SAS procedures and locations in the SAS Enterprise Guide","thumb":null,"image":null,"content":"<p>The tasks in SAS Enterprise Guide and SAS Add-In for Microsoft Office cover a wide range of SAS capabilities.</p>\n<p>These SAS tasks are easy-to-use interfaces that create SAS programs to do their work. The programs call on SAS procedures, where each procedure represents a specialized capability. And to make it even more interesting, SAS (the company) provides these procedures in product bundles, which must be separately licensed for customers to use them.</p>\n<p>With all of this at work, it can be tricky to keep track of which tasks use which procedures that need which SAS products.</p>\n<p>The following table lays it all out for you: all the tasks, how to find them in the menu, which procedures they use, and which SAS products are involved.</p>\n<table>\n<tbody>\n<tr>\n<th>Task<br />\nand<br />\nMenu Location</th>\n<th>SAS Procedures<br />\nand<br />\nSAS Products</th>\n</tr>\n<tr>\n<td>Import Data<br />\n(Excel)File→Import Data</td>\n<td>DATA step; IMPORT</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Open<br />\nInformation MapFile→Open</td>\n<td>DATA step</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Linear Models</p>\n<p>Tasks→ANOVA</td>\n<td>GLM</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Mixed Models</p>\n<p>Tasks→ANOVA</td>\n<td>MIXED</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Nonparametric<br />\nOne-Way<br />\nANOVATasks→ANOVA</td>\n<td>NPAR1WAY</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>One-Way<br />\nANOVATasks→ANOVA</td>\n<td>ANOVA; GPLOT</p>\n<p>SAS/STAT; SAS/GRAPH</td>\n</tr>\n<tr>\n<td>t Test</p>\n<p>Tasks→ANOVA</td>\n<td>TTEST</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>CDF Plots</p>\n<p>Tasks&#8211;<br />\n&gt;Capability</td>\n<td>CAPABILITY</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>Histograms</p>\n<p>Tasks&#8211;<br />\n&gt;Capability</td>\n<td>CAPABILITY</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>P-P Plots</p>\n<p>Tasks&#8211;<br />\n&gt;Capability</td>\n<td>CAPABILITY</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>Probability<br />\nPlotsTasks→Capability</td>\n<td>CAPABILITY</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>Q-Q Plots</p>\n<p>Tasks&#8211;<br />\n&gt;Capability</td>\n<td>CAPABILITY</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>Box Chart</p>\n<p>Tasks→Control<br />\nCharts</td>\n<td>SHEWHART</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>c Chart</p>\n<p>Tasks→Control<br />\nCharts</td>\n<td>SHEWHART</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>Individual<br />\nMeasurements<br />\nChartTasks→Control<br />\nCharts</td>\n<td>SHEWHART</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>Mean and<br />\nRange ChartTasks→Control<br />\nCharts</td>\n<td>SHEWHART</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>Mean and<br />\nStandard<br />\nDeviation ChartTasks→Control<br />\nCharts</td>\n<td>SHEWHART</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>np Chart</p>\n<p>Tasks→Control<br />\nCharts</td>\n<td>SHEWHART</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>p Chart</p>\n<p>Tasks→Control<br />\nCharts</td>\n<td>SHEWHART</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>u Chart</p>\n<p>Tasks→Control<br />\nCharts</td>\n<td>SHEWHART</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>Append Table</p>\n<p>Tasks→Data</td>\n<td>SQL</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Compare Data</p>\n<p>Tasks→Data</td>\n<td>COMPARE</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Create Format</p>\n<p>Tasks→Data</td>\n<td>FORMAT</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Data Set<br />\nAttributesTasks→Data</td>\n<td>DATASETS</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Delete Data<br />\nSets and<br />\nFormatsTasks→Data</td>\n<td>DELETE</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Download Data<br />\nFiles to PCTasks→Data</td>\n<td>SQL</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Filter and Sort</p>\n<p>Tasks→Data</td>\n<td>SQL</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Query Builder</p>\n<p>Tasks→Data</td>\n<td>SQL</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Random Sample</p>\n<p>Tasks→Data</td>\n<td>SURVEYSELECT</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Rank</p>\n<p>Tasks→Data</td>\n<td>RANK</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Sort Data</p>\n<p>Tasks→Data</td>\n<td>SORT</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Split Columns</p>\n<p>Tasks→Data</td>\n<td>TRANSPOSE</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Stack Columns</p>\n<p>Tasks→Data</td>\n<td>TRANSPOSE</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Standardize<br />\nDataTasks→Data</td>\n<td>STANDARD</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Table Analysis</p>\n<p>Tasks→Data</td>\n<td>FREQ</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Transpose</p>\n<p>Tasks→Data</td>\n<td>TRANSPOSE</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Upload Data to<br />\nSAS ServerTasks→Data</td>\n<td>SQL</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Import from<br />\nSPSSTasks→Data</td>\n<td>IMPORT</p>\n<p>SAS/ACCESS<br />\nInterface to PC File<br />\nFormats</td>\n</tr>\n<tr>\n<td>Import from JMP</p>\n<p>Tasks→Data</td>\n<td>IMPORT</p>\n<p>SAS/ACCESS<br />\nInterface to PC File<br />\nFormats</td>\n</tr>\n<tr>\n<td>Import from<br />\nStataTasks→Data</td>\n<td>IMPORT</p>\n<p>SAS/ACCESS<br />\nInterface to PC File<br />\nFormats</td>\n</tr>\n<tr>\n<td>Characterize Data Wizard</p>\n<p>Tasks→Describe</td>\n<td>CONTENTS;<br />\nUNIVARIATE;<br />\nFREQSAS/STAT</td>\n</tr>\n<tr>\n<td>Distribution<br />\nAnalysisTasks→Describe</td>\n<td>UNIVARIATE</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>List Data</p>\n<p>Tasks→Describe</td>\n<td>PRINT</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>List Report</p>\n<p>Tasks→Describe</td>\n<td>REPORT</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>One-Way<br />\nFrequenciesTasks→Describe</td>\n<td>FREQ</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Summary Statistics</p>\n<p>Tasks→Describe</td>\n<td>MEANS</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Summary Tables</p>\n<p>Tasks→Describe</td>\n<td>TABULATE</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Area Plot</p>\n<p>Tasks→Graph</td>\n<td>GPLOT</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Bar Chart</p>\n<p>Tasks→Graph</td>\n<td>GCHART</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Bar-Line Chart</p>\n<p>Tasks→Graph</td>\n<td>GBARLINE</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Box Plot</p>\n<p>Tasks→Graph</td>\n<td>GPLOT</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Bubble Plot</p>\n<p>Tasks→Graph</td>\n<td>GPLOT</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Contour Plot</p>\n<p>Tasks→Graph</td>\n<td>GCONTOUR</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Create Map<br />\nFeature TableTasks→Graph</td>\n<td>GPROJECT</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Donut Chart</p>\n<p>Tasks→Graph</td>\n<td>GCHART</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Line Plot</p>\n<p>Tasks→Graph</td>\n<td>GPLOT</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Map Graph</p>\n<p>Tasks→Graph</td>\n<td>GMAP</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Pie Chart</p>\n<p>Tasks→Graph</td>\n<td>GCHART</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Radar Chart</p>\n<p>Tasks→Graph</td>\n<td>GRADAR</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Scatter Plot</p>\n<p>Tasks→Graph</td>\n<td>GPLOT; G3D</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Surface Plot</p>\n<p>Tasks→Graph</td>\n<td>G3D</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Tile Chart</p>\n<p>Tasks→Graph</td>\n<td>GTILE</p>\n<p>SAS/GRAPH</td>\n</tr>\n<tr>\n<td>Model Scoring</p>\n<p>Tasks→Model Scoring</td>\n<td>NONE</p>\n<p>SAS Enterprise Miner</td>\n</tr>\n<tr>\n<td>Canonical<br />\nCorrelationTasks→<br />\nMultivariate</td>\n<td>CANCORR</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Cluster Analysis</p>\n<p>Tasks→<br />\nMultivariate</td>\n<td>CLUSTER, TREE,<br />\nFASTCLUSSAS/STAT</td>\n</tr>\n<tr>\n<td>Correlations</p>\n<p>Tasks→<br />\nMultivariate</td>\n<td>CORR</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Discriminant Analysis</p>\n<p>Tasks→<br />\nMultivariate</td>\n<td>DISCRIM</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Factor Analysis</p>\n<p>Tasks→<br />\nMultivariate</td>\n<td>FACTOR</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Principal<br />\nComponentsTasks→Multivariate</td>\n<td>PRINCOMP</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Pareto Chart</p>\n<p>Tasks→Pareto</td>\n<td>PARETO</p>\n<p>SAS/QC</td>\n</tr>\n<tr>\n<td>Generalized Linear<br />\nModelsTasks→<br />\nRegression</td>\n<td>GENMOD</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Linear Regression</p>\n<p>Tasks→<br />\nRegression</td>\n<td>REG</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Logistic Regression</p>\n<p>Tasks→<br />\nRegression</td>\n<td>LOGISTIC</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Nonlinear<br />\nRegressionTasks→<br />\nRegression</td>\n<td>NLIN</p>\n<p>SAS/STAT</td>\n</tr>\n<tr>\n<td>Life Tables</p>\n<p>Tasks→<br />\nSurvival Analysis</td>\n<td>LIFETEST</p>\n<p>SAS/ETS</td>\n</tr>\n<tr>\n<td>Proportional<br />\nHazardsTasks→<br />\nSurvival Analysis</td>\n<td>PHREG</p>\n<p>SAS/ETS</td>\n</tr>\n<tr>\n<td>ARIMA Modeling<br />\nand ForecastingTasks→<br />\nTime Series</td>\n<td>ARIMA</p>\n<p>SAS/ETS</td>\n</tr>\n<tr>\n<td>Basic Forecasting</p>\n<p>Tasks→<br />\nTime Series</td>\n<td>FORECAST</p>\n<p>SAS/ETS</td>\n</tr>\n<tr>\n<td>Create Time<br />\nSeries DataTasks→<br />\nTime Series</td>\n<td>TIMESERIES</p>\n<p>SAS/ETS</td>\n</tr>\n<tr>\n<td>Forecast Studio<br />\nCreate Project<br />\nWizardTasks→<br />\nTime Series</td>\n<td>Forecast Studio</p>\n<p>SAS<br />\nForecast Server</td>\n</tr>\n<tr>\n<td>Forecast Studio<br />\nOpen Project WizardTasks→Time<br />\nSeries</td>\n<td>Forecast Studio</p>\n<p>SAS<br />\nForecast Server</td>\n</tr>\n<tr>\n<td>Forecast Studio<br />\nOverride WizardTasks→Time Series</td>\n<td>Forecast Studio</p>\n<p>SAS<br />\nForecast Server</td>\n</tr>\n<tr>\n<td>Prepare Time<br />\nSeries DataTasks→Time<br />\nSeries</td>\n<td>EXPAND</p>\n<p>SAS/ETS</td>\n</tr>\n<tr>\n<td>Regression<br />\nAnalysis of Panel<br />\nDataTasks→Time<br />\nSeries</td>\n<td>TSCSREG</p>\n<p>SAS/ETS</td>\n</tr>\n<tr>\n<td>Regression<br />\nAnalysis with<br />\nAutoregressive<br />\nErrorsTasks→Time<br />\nSeries</td>\n<td>AUTOREG</p>\n<p>SAS/ETS</td>\n</tr>\n<tr>\n<td>Update Library<br />\nMetadataTools</td>\n<td>METALIB</p>\n<p>Base SAS</td>\n</tr>\n<tr>\n<td>Assign Project<br />\nLibraryTools</td>\n<td>LIBNAME</p>\n<p>Base SAS</td>\n</tr>\n</tbody>\n</table>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-03-01T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":207503},{"headers":{"creationTime":"2021-09-16T15:42:53+00:00","modifiedTime":"2022-02-25T17:43:49+00:00","timestamp":"2022-09-14T18:19:16+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Information Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33572"},"slug":"information-technology","categoryId":33572},{"name":"Data Science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"},"slug":"data-science","categoryId":33577},{"name":"Databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"},"slug":"databases","categoryId":33579}],"title":"Data Lakes For Dummies Cheat Sheet","strippedTitle":"data lakes for dummies cheat sheet","slug":"data-lakes-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Learn what a data lake is, how to build a data lake, and how to ensure that your company's data lake supports a broad range of analytics.","noIndex":0,"noFollow":0},"content":"A data lake is an enterprise-scale home for analytical data from all corners of your company or governmental agency. No matter what your analytical data landscape looks like today, your organization will benefit from building a data lake.\r\n\r\n[caption id=\"attachment_285911\" align=\"alignnone\" width=\"556\"]<img class=\"size-full wp-image-285911\" src=\"https://www.dummies.com/wp-content/uploads/data-lakes-concept.jpg\" alt=\"conceptual graphic of a data lake\" width=\"556\" height=\"440\" /> © Stuart Miles / Shutterstock.com[/caption]","description":"A data lake is an enterprise-scale home for analytical data from all corners of your company or governmental agency. No matter what your analytical data landscape looks like today, your organization will benefit from building a data lake.\r\n\r\n[caption id=\"attachment_285911\" align=\"alignnone\" width=\"556\"]<img class=\"size-full wp-image-285911\" src=\"https://www.dummies.com/wp-content/uploads/data-lakes-concept.jpg\" alt=\"conceptual graphic of a data lake\" width=\"556\" height=\"440\" /> © Stuart Miles / Shutterstock.com[/caption]","blurb":"","authors":[{"authorId":10199,"name":"Alan Simpson","slug":"alan-simpson","description":" <b>Alan Simpson</b> is the author of over 90 computer books on databases, Windows, Web site design and development, programming, and networking. His books are published throughout the world in over a dozen languages and have millions of copies. Alan has also taught introductory and advanced computer programming courses at San Diego State University and the UCSD Extension. He has served as a consultant on high-technology, educationoriented projects for the United States Navy and Air Force. Despite that, Alan has no fancy job title because he has never had a real job.","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/10199"}}],"primaryCategoryTaxonomy":{"categoryId":33579,"title":"Databases","slug":"databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":208741,"title":"Kabbalah For Dummies Cheat Sheet","slug":"kabbalah-for-dummies-cheat-sheet","categoryList":["body-mind-spirit","religion-spirituality","kabbalah"],"_links":{"self":"/articles/208741"}},{"articleId":230957,"title":"Nikon D3400 For Dummies Cheat Sheet","slug":"nikon-d3400-dummies-cheat-sheet","categoryList":["home-auto-hobbies","photography"],"_links":{"self":"/articles/230957"}},{"articleId":235851,"title":"Praying the Rosary and Meditating on the Mysteries","slug":"praying-rosary-meditating-mysteries","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/235851"}},{"articleId":284787,"title":"What Your Society Says About You","slug":"what-your-society-says-about-you","categoryList":["academics-the-arts","humanities"],"_links":{"self":"/articles/284787"}}],"inThisArticle":[],"relatedArticles":{"fromBook":[],"fromCategory":[{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":207503,"title":"SAS For Dummies Cheat Sheet","slug":"sas-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207503"}},{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}},{"articleId":173432,"title":"Managing Records on Local and Network Drives","slug":"managing-records-on-local-and-network-drives","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173432"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":284366,"slug":"data-lakes-for-dummies","isbn":"9781119786160","categoryList":["technology","information-technology","data-science","general-data-science"],"amazon":{"default":"https://www.amazon.com/gp/product/1119786169/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119786169/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119786169-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119786169/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119786169/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/data-lakes-for-dummies-cover-9781119786160-203x255.jpg","width":203,"height":255},"title":"Data Lakes For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"<p><b><b data-author-id=\"10511\">Alan R. Simon</b></b>, author of <i>Data Warehousing For Dummies</i>, is a manager at Deloitte Consulting. Alan has experienced every side of stock options in public and pre-IPO companies, large Fortune 500 corporations, and small consulting firms.</p>","authors":[{"authorId":10511,"name":"Alan R. Simon","slug":"alan-r-simon","description":" <b>Alan R. Simon</b>, author of <i>Data Warehousing For Dummies</i>, is a manager at Deloitte Consulting. Alan has experienced every side of stock options in public and pre-IPO companies, large Fortune 500 corporations, and small consulting firms.","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/10511"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119786160&quot;]}]\" id=\"du-slot-63221b24c325d\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119786160&quot;]}]\" id=\"du-slot-63221b24c3c49\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}}],"content":[{"title":"Five phases to building a data lake","thumb":null,"image":null,"content":"<p>Your data lake journey begins with a thorough understanding of today’s analytics and data throughout your entire organization. Then, you’ll methodically progress through conceptual and high-level activities into your implementation activities. Follow these phases whose first letters spell out A LAKE:</p>\n<ol>\n<li>ASSESS your current state, and score the results.</li>\n<li>Prepare a LOFTY VISION for what your data lake will bring you, both technology-wise and in terms of business value.</li>\n<li>Decide on your data lake ARCHITECTURE, starting at the conceptual level and then shifting into specific products and services.</li>\n<li>Begin with your KICKOFF ACTIVITIES that will deliver the first end-to-end data pipelines that culminate in high-value analytics.</li>\n<li>Progressively EXPAND your data lake through subsequent phases.</li>\n</ol>\n"},{"title":"Three types of data for a data lake","thumb":null,"image":null,"content":"<p>If you’ve been working primarily with traditional data warehouses and data marts, you’re in for a treat. Not only will your data lake include the structured data that you’re used to working with, but you’ll also ingest, manage, and deliver:</p>\n<ul>\n<li>Semi-structured data, such as tweets, blog posts, and email messages</li>\n<li>Unstructured data, such as photos, videos, and audio files</li>\n</ul>\n<p>Your next generation of analytics will be built from the fusion of these various types of data. Sometimes, the insights you need aren’t just in the numbers or the stats, but in what you can learn from these other forms of data.</p>\n"},{"title":"Four zones inside a data lake","thumb":null,"image":null,"content":"<p>From the 30,000-foot view, your data lake appears to be a large store of all types of data. When you peel the lid back, though, your data lake should be well organized into the following zones:</p>\n<ul>\n<li><strong>The bronze zone,</strong> where you ingest your raw data into inexpensive storage that is infinitely expandable . . . or at least pretty close to infinitely expandable!</li>\n<li><strong>The silver zone,</strong> where you store your formerly raw data that is now cleansed and enriched</li>\n<li><strong>The gold zone,</strong> where you store curated packages of data that are prepared to support users and analytical needs all across your enterprise</li>\n<li><strong>The sandbox,</strong> where you can quickly place data from elsewhere in your data lake — or even new data coming in from the outside — for experimental or short-term analysis</li>\n</ul>\n"},{"title":"Supporting an entire analytics continuum","thumb":null,"image":null,"content":"<p>Your data lake will support a broad range of analytics in a coordinated, well-architected manner. Prepare to make use of:</p>\n<ul>\n<li><strong>Descriptive analytics,</strong> which tell you what happened in the past or what’s happening right now</li>\n<li><strong>Diagnostic analytics,</strong> which dig into your descriptive analytics and help you understand why something happened or is happening</li>\n<li><strong><a href=\"https://dummies-wp-admin.dummies.com/programming/big-data/data-science/big-data-visualization-tools-can-use-predictive-analytics/\" target=\"_blank\" rel=\"noopener\">Predictive analytics</a>,</strong> which tell you what’s likely to happen</li>\n<li><strong>Discovery analytics,</strong> in which you turn your analytical power loose on mountains of data with a mission to tell us interesting and important patterns and other insights out of all of this data, without our asking specific questions</li>\n<li><strong>Prescriptive analytics,</strong> which take all your other categories of analytics to the last mile and guide you to decision-making, present you with alternatives for taking action, and make a recommendation for your “best” course of action</li>\n</ul>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2021-09-16T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":285910},{"headers":{"creationTime":"2016-03-26T21:39:38+00:00","modifiedTime":"2016-03-26T21:39:38+00:00","timestamp":"2022-09-14T18:10:15+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Information Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33572"},"slug":"information-technology","categoryId":33572},{"name":"Data Science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"},"slug":"data-science","categoryId":33577},{"name":"Databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"},"slug":"databases","categoryId":33579}],"title":"Selecting the Correct SAS Product","strippedTitle":"selecting the correct sas product","slug":"selecting-the-correct-sas-product","canonicalUrl":"","seo":{"metaDescription":"SAS Institute offers hundreds of SAS products, and sometimes it's difficult to decide which tool you should use for your work. Here is a partial list of SAS pro","noIndex":0,"noFollow":0},"content":"<p>SAS Institute offers hundreds of SAS products, and sometimes it's difficult to decide which tool you should use for your work. Here is a <i>partial</i> list of SAS products you might encounter and who uses them for what purpose. As a SAS customer, you might use just one of these products or a few of them; if you're really lucky, you might use them all.</p>\n<h2 id=\"tab1\" >SAS, or the SAS System</h2>\n<p>The SAS System is the original SAS product that customers have used in one form or another for more than 30 years, on systems ranging from big mainframes to laptops. It's also known as Display Manager (the name of the windowing interface), or Base SAS, or just plain old SAS. The SAS System is primarily a tool for people comfortable with writing SAS programs. It contains the data processing and analytics engine that is at the core of most SAS products.</p>\n<h2 id=\"tab2\" >SAS Enterprise Guide</h2>\n<p>SAS Enterprise Guide provides a modern, easy-to-use interface to much of the power of SAS. SAS Enterprise Guide is used by SAS programmers, business analysts (who might or might not have programming skills), and statisticians. It’s a Microsoft Windows application that can connect to SAS; you can use it to drive the SAS analytics engine running on a mainframe, UNIX, or other remote machines as a server application. SAS Enterprise Guide is like a general store for SAS, where you can get a little bit of everything that SAS has to offer.</p>\n<h2 id=\"tab3\" >SAS Data Integration Studio</h2>\n<p>SAS Data Integration Studio is used to create and maintain data warehouses and data marts, which are specialized stores of data that have been prepared for effective reporting and analytics. Data experts, such as database administrators and IT specialists — people who support other folks who have to create reports — use SAS Data Integration Studio. Like SAS Enterprise Guide, this is a client application that runs on your desktop and provides an intuitive user interface, but it can connect to SAS and databases that run on machines all over your organization.</p>\n<h2 id=\"tab4\" >SAS Enterprise Miner</h2>\n<p>SAS Enterprise Miner is used for data mining, or investigating patterns in large amounts of data. Statisticians and professional modelers use SAS Enterprise Miner to segment data and create descriptive or predictive models. For example, a bank might use such a model to predict how likely you are to respond to a certain credit card offering. If your data profile is similar enough to others who have responded to similar offers, SAS Enterprise Miner would produce a model that indicates you're worth sending the offer to. Hello, Platinum card!</p>\n<h2 id=\"tab5\" >SAS Add-In for Microsoft Office</h2>\n<p>Some people spend most of their working days working with a Microsoft Office application such as Excel or PowerPoint. SAS Add-In for Microsoft Office lets you open SAS data sources and run SAS analyses without ever having to leave the comfy world of your spreadsheet or slideshow. SAS Add-In for Microsoft Office is used by business analysts who don't really need to know anything about SAS programming but need the answers that SAS can provide.</p>\n<h2 id=\"tab6\" >SAS Web Report Studio</h2>\n<p>All business intelligence software vendors must have a Web-based reporting product, and SAS Web Report Studio fits that bill. SAS Web Report Studio allows you to create and distribute reports to anyone who needs them, all without leaving your Web browser.</p>\n<h2 id=\"tab7\" >SAS Forecast Studio</h2>\n<p>SAS Forecast Studio analyzes time-based data and forecasting future trends and events. It's like a crystal ball, only better! SAS Forecast Studio is used by professional modelers or statisticians who understand concepts such as seasonality and intermittent demand models. However, no SAS programming is required!</p>\n<h2 id=\"tab8\" >JMP</h2>\n<p>JMP is a standalone, highly visual analytics product. It runs on Microsoft Windows, Apple Macintosh, or Linux-based computers. JMP is sometimes packaged with SAS and can work with other SAS products, but most often it's used by researchers, engineers, and quality-control experts who want advanced analytics without a big software footprint.</p>","description":"<p>SAS Institute offers hundreds of SAS products, and sometimes it's difficult to decide which tool you should use for your work. Here is a <i>partial</i> list of SAS products you might encounter and who uses them for what purpose. As a SAS customer, you might use just one of these products or a few of them; if you're really lucky, you might use them all.</p>\n<h2 id=\"tab1\" >SAS, or the SAS System</h2>\n<p>The SAS System is the original SAS product that customers have used in one form or another for more than 30 years, on systems ranging from big mainframes to laptops. It's also known as Display Manager (the name of the windowing interface), or Base SAS, or just plain old SAS. The SAS System is primarily a tool for people comfortable with writing SAS programs. It contains the data processing and analytics engine that is at the core of most SAS products.</p>\n<h2 id=\"tab2\" >SAS Enterprise Guide</h2>\n<p>SAS Enterprise Guide provides a modern, easy-to-use interface to much of the power of SAS. SAS Enterprise Guide is used by SAS programmers, business analysts (who might or might not have programming skills), and statisticians. It’s a Microsoft Windows application that can connect to SAS; you can use it to drive the SAS analytics engine running on a mainframe, UNIX, or other remote machines as a server application. SAS Enterprise Guide is like a general store for SAS, where you can get a little bit of everything that SAS has to offer.</p>\n<h2 id=\"tab3\" >SAS Data Integration Studio</h2>\n<p>SAS Data Integration Studio is used to create and maintain data warehouses and data marts, which are specialized stores of data that have been prepared for effective reporting and analytics. Data experts, such as database administrators and IT specialists — people who support other folks who have to create reports — use SAS Data Integration Studio. Like SAS Enterprise Guide, this is a client application that runs on your desktop and provides an intuitive user interface, but it can connect to SAS and databases that run on machines all over your organization.</p>\n<h2 id=\"tab4\" >SAS Enterprise Miner</h2>\n<p>SAS Enterprise Miner is used for data mining, or investigating patterns in large amounts of data. Statisticians and professional modelers use SAS Enterprise Miner to segment data and create descriptive or predictive models. For example, a bank might use such a model to predict how likely you are to respond to a certain credit card offering. If your data profile is similar enough to others who have responded to similar offers, SAS Enterprise Miner would produce a model that indicates you're worth sending the offer to. Hello, Platinum card!</p>\n<h2 id=\"tab5\" >SAS Add-In for Microsoft Office</h2>\n<p>Some people spend most of their working days working with a Microsoft Office application such as Excel or PowerPoint. SAS Add-In for Microsoft Office lets you open SAS data sources and run SAS analyses without ever having to leave the comfy world of your spreadsheet or slideshow. SAS Add-In for Microsoft Office is used by business analysts who don't really need to know anything about SAS programming but need the answers that SAS can provide.</p>\n<h2 id=\"tab6\" >SAS Web Report Studio</h2>\n<p>All business intelligence software vendors must have a Web-based reporting product, and SAS Web Report Studio fits that bill. SAS Web Report Studio allows you to create and distribute reports to anyone who needs them, all without leaving your Web browser.</p>\n<h2 id=\"tab7\" >SAS Forecast Studio</h2>\n<p>SAS Forecast Studio analyzes time-based data and forecasting future trends and events. It's like a crystal ball, only better! SAS Forecast Studio is used by professional modelers or statisticians who understand concepts such as seasonality and intermittent demand models. However, no SAS programming is required!</p>\n<h2 id=\"tab8\" >JMP</h2>\n<p>JMP is a standalone, highly visual analytics product. It runs on Microsoft Windows, Apple Macintosh, or Linux-based computers. JMP is sometimes packaged with SAS and can work with other SAS products, but most often it's used by researchers, engineers, and quality-control experts who want advanced analytics without a big software footprint.</p>","blurb":"","authors":[{"authorId":9190,"name":"Stephen McDaniel","slug":"stephen-mcdaniel","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9190"}},{"authorId":9191,"name":"Chris Hemedinger","slug":"chris-hemedinger","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9191"}}],"primaryCategoryTaxonomy":{"categoryId":33579,"title":"Databases","slug":"databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":208741,"title":"Kabbalah For Dummies Cheat Sheet","slug":"kabbalah-for-dummies-cheat-sheet","categoryList":["body-mind-spirit","religion-spirituality","kabbalah"],"_links":{"self":"/articles/208741"}},{"articleId":230957,"title":"Nikon D3400 For Dummies Cheat Sheet","slug":"nikon-d3400-dummies-cheat-sheet","categoryList":["home-auto-hobbies","photography"],"_links":{"self":"/articles/230957"}},{"articleId":235851,"title":"Praying the Rosary and Meditating on the Mysteries","slug":"praying-rosary-meditating-mysteries","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/235851"}},{"articleId":284787,"title":"What Your Society Says About You","slug":"what-your-society-says-about-you","categoryList":["academics-the-arts","humanities"],"_links":{"self":"/articles/284787"}}],"inThisArticle":[{"label":"SAS, or the SAS System","target":"#tab1"},{"label":"SAS Enterprise Guide","target":"#tab2"},{"label":"SAS Data Integration Studio","target":"#tab3"},{"label":"SAS Enterprise Miner","target":"#tab4"},{"label":"SAS Add-In for Microsoft Office","target":"#tab5"},{"label":"SAS Web Report Studio","target":"#tab6"},{"label":"SAS Forecast Studio","target":"#tab7"},{"label":"JMP","target":"#tab8"}],"relatedArticles":{"fromBook":[{"articleId":207503,"title":"SAS For Dummies Cheat Sheet","slug":"sas-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207503"}},{"articleId":143291,"title":"SAS Procedures and Their Location in SAS Enterprise Guide","slug":"sas-procedures-and-their-location-in-sas-enterprise-guide","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/143291"}}],"fromCategory":[{"articleId":285910,"title":"Data Lakes For Dummies Cheat Sheet","slug":"data-lakes-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/285910"}},{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":207503,"title":"SAS For Dummies Cheat Sheet","slug":"sas-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207503"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}},{"articleId":173432,"title":"Managing Records on Local and Network Drives","slug":"managing-records-on-local-and-network-drives","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173432"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281857,"slug":"sas-for-dummies-2nd-edition","isbn":"9780470539682","categoryList":["technology","information-technology","data-science","databases"],"amazon":{"default":"https://www.amazon.com/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/0470539682-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/sas-for-dummies-2nd-edition-cover-9780470539682-203x255.jpg","width":203,"height":255},"title":"SAS For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9190\">Stephen McDaniel</b> is Principal and cofounder of Freakalytics™ LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b data-author-id=\"9191\">Chris Hemedinger</b> works in SAS R&amp;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. </p>","authors":[{"authorId":9190,"name":"Stephen McDaniel","slug":"stephen-mcdaniel","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9190"}},{"authorId":9191,"name":"Chris Hemedinger","slug":"chris-hemedinger","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9191"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470539682&quot;]}]\" id=\"du-slot-63221907d34f3\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470539682&quot;]}]\" id=\"du-slot-63221907d3e08\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":193380},{"headers":{"creationTime":"2016-03-26T17:14:28+00:00","modifiedTime":"2016-03-26T17:14:28+00:00","timestamp":"2022-09-14T18:06:46+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Information Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33572"},"slug":"information-technology","categoryId":33572},{"name":"Data Science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"},"slug":"data-science","categoryId":33577},{"name":"Databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"},"slug":"databases","categoryId":33579}],"title":"Appraising Records and Managing Retention Scheduling","strippedTitle":"appraising records and managing retention scheduling","slug":"appraising-records-and-managing-retention-scheduling","canonicalUrl":"","seo":{"metaDescription":"A fundamental part of a successful records and information management program is identifying what records and information your company possesses and then applyi","noIndex":0,"noFollow":0},"content":"<p>A fundamental part of a successful records and information management program is identifying what records and information your company possesses and then applying appropriate retention periods.</p>\n<ul class=\"level-one\">\n <li><p class=\"first-para\"><b>Records appraisal.</b> There are different methods for appraising your records and information, including inventories, interviews, and questionnaires. Picking the right appraisal method for your organization is important. The appraisal allows you to identify what records and information the organization possesses and forms the basis for your company’s record retention schedule.</p>\n </li>\n <li><p class=\"first-para\"><b>Retention schedule.</b> The retention schedule is typically the most referenced records management program document. It allows employees to determine how long they should keep their records and information. <i>Records Management For Dummies</i> addresses three distinct retention schedule methods: departmental, functional, and big bucket.</p>\n </li>\n</ul>","description":"<p>A fundamental part of a successful records and information management program is identifying what records and information your company possesses and then applying appropriate retention periods.</p>\n<ul class=\"level-one\">\n <li><p class=\"first-para\"><b>Records appraisal.</b> There are different methods for appraising your records and information, including inventories, interviews, and questionnaires. Picking the right appraisal method for your organization is important. The appraisal allows you to identify what records and information the organization possesses and forms the basis for your company’s record retention schedule.</p>\n </li>\n <li><p class=\"first-para\"><b>Retention schedule.</b> The retention schedule is typically the most referenced records management program document. It allows employees to determine how long they should keep their records and information. <i>Records Management For Dummies</i> addresses three distinct retention schedule methods: departmental, functional, and big bucket.</p>\n </li>\n</ul>","blurb":"","authors":[{"authorId":9881,"name":"Blake Richardson CRM","slug":"blake-richardson","description":"Blake Richardson, CRM, is a certified records manager with more than 15 years of experience managing records and information for several Fortune 500 companies. He has been a records manager for CNA Insurance and the Dollar General Corporation, and is active in ARMA International. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9881"}},{"authorId":9882,"name":"CRM","slug":"crm","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9882"}}],"primaryCategoryTaxonomy":{"categoryId":33579,"title":"Databases","slug":"databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":208741,"title":"Kabbalah For Dummies Cheat Sheet","slug":"kabbalah-for-dummies-cheat-sheet","categoryList":["body-mind-spirit","religion-spirituality","kabbalah"],"_links":{"self":"/articles/208741"}},{"articleId":230957,"title":"Nikon D3400 For Dummies Cheat Sheet","slug":"nikon-d3400-dummies-cheat-sheet","categoryList":["home-auto-hobbies","photography"],"_links":{"self":"/articles/230957"}},{"articleId":235851,"title":"Praying the Rosary and Meditating on the Mysteries","slug":"praying-rosary-meditating-mysteries","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/235851"}},{"articleId":284787,"title":"What Your Society Says About You","slug":"what-your-society-says-about-you","categoryList":["academics-the-arts","humanities"],"_links":{"self":"/articles/284787"}}],"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":173432,"title":"Managing Records on Local and Network Drives","slug":"managing-records-on-local-and-network-drives","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173432"}},{"articleId":173421,"title":"Benefits of Records Management","slug":"benefits-of-records-management","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173421"}}],"fromCategory":[{"articleId":285910,"title":"Data Lakes For Dummies Cheat Sheet","slug":"data-lakes-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/285910"}},{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":207503,"title":"SAS For Dummies Cheat Sheet","slug":"sas-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207503"}},{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}},{"articleId":173432,"title":"Managing Records on Local and Network Drives","slug":"managing-records-on-local-and-network-drives","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173432"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281849,"slug":"records-management-for-dummies","isbn":"9781118388082","categoryList":["technology","information-technology","data-science","databases"],"amazon":{"default":"https://www.amazon.com/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1118388089-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/records-management-for-dummies-cover-9781118388082-203x255.jpg","width":203,"height":255},"title":"Records Management For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p>Blake Richardson, CRM, is a Certified Records Manager with more than 15 years of experience managing records and information for several Fortune 500 companies. He has been a records manager for CNA Insurance and the Dollar General Corporation, and is active in ARMA International.</p>","authors":[{"authorId":34784,"name":"","slug":"","description":" <p><b> Joseph A. Allen, PhD</b> is a professor of industrial and organizational (I/O) psychology at the University of Utah. His articles have appeared in <i>Human Relations, Journal of Business Psychology</i>, and more.</p> <p><b>Karin M. Reed</b> is CEO of Speaker Dynamics, a corporate communications training firm. She is an Emmy award-winning broadcast journalist. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/34784"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118388082&quot;]}]\" id=\"du-slot-632218367247f\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118388082&quot;]}]\" id=\"du-slot-6322183672cf3\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":173434},{"headers":{"creationTime":"2016-03-26T17:14:27+00:00","modifiedTime":"2016-03-26T17:14:27+00:00","timestamp":"2022-09-14T18:06:46+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Information Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33572"},"slug":"information-technology","categoryId":33572},{"name":"Data Science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"},"slug":"data-science","categoryId":33577},{"name":"Databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"},"slug":"databases","categoryId":33579}],"title":"Managing Records on Local and Network Drives","strippedTitle":"managing records on local and network drives","slug":"managing-records-on-local-and-network-drives","canonicalUrl":"","seo":{"metaDescription":"The amount of electronic information has grown exponentially over the past decade. Local (C: Drives) and network drives are becoming digital graveyards. An effe","noIndex":0,"noFollow":0},"content":"<p>The amount of electronic information has grown exponentially over the past decade. Local (C: Drives) and network drives are becoming digital graveyards. An effective records management program will provide you with the knowledge and tools you need to ensure that electronic files are properly managed.</p>\n<ul class=\"level-one\">\n <li><p class=\"first-para\"><b>Folder structures and names.</b> Creating an electronic folder structure that meets the needs of each department and ensuring that the folders within the structure are logically named are critical for accurate electronic filing, retrieval, and file maintenance (clean-up).</p>\n </li>\n <li><p class=\"first-para\"><b>File naming conventions.</b> After you have created the proper electronic folder structure, it’s important to ensure that your files are also named in an appropriate manner. A rule of thumb for naming your files is that you should be able to determine the contents of a file without having to open it. This means avoiding cryptic names such as abbreviations, acronyms, and numbers.</p>\n </li>\n <li><p class=\"first-para\"><b>Maintenance.</b> It is important to regularly review your folders and files to determine what is no longer needed. Microsoft Windows allows you to determine the last access and modification dates of a file. This is a good starting point in determining whether a file can be deleted. However, employees should always reference the organization’s record retention schedule before deleting any files in order to determine if the file is eligible for deletion.</p>\n </li>\n</ul>","description":"<p>The amount of electronic information has grown exponentially over the past decade. Local (C: Drives) and network drives are becoming digital graveyards. An effective records management program will provide you with the knowledge and tools you need to ensure that electronic files are properly managed.</p>\n<ul class=\"level-one\">\n <li><p class=\"first-para\"><b>Folder structures and names.</b> Creating an electronic folder structure that meets the needs of each department and ensuring that the folders within the structure are logically named are critical for accurate electronic filing, retrieval, and file maintenance (clean-up).</p>\n </li>\n <li><p class=\"first-para\"><b>File naming conventions.</b> After you have created the proper electronic folder structure, it’s important to ensure that your files are also named in an appropriate manner. A rule of thumb for naming your files is that you should be able to determine the contents of a file without having to open it. This means avoiding cryptic names such as abbreviations, acronyms, and numbers.</p>\n </li>\n <li><p class=\"first-para\"><b>Maintenance.</b> It is important to regularly review your folders and files to determine what is no longer needed. Microsoft Windows allows you to determine the last access and modification dates of a file. This is a good starting point in determining whether a file can be deleted. However, employees should always reference the organization’s record retention schedule before deleting any files in order to determine if the file is eligible for deletion.</p>\n </li>\n</ul>","blurb":"","authors":[{"authorId":9881,"name":"Blake Richardson CRM","slug":"blake-richardson","description":"Blake Richardson, CRM, is a certified records manager with more than 15 years of experience managing records and information for several Fortune 500 companies. He has been a records manager for CNA Insurance and the Dollar General Corporation, and is active in ARMA International. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9881"}},{"authorId":9882,"name":"CRM","slug":"crm","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9882"}}],"primaryCategoryTaxonomy":{"categoryId":33579,"title":"Databases","slug":"databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":208741,"title":"Kabbalah For Dummies Cheat Sheet","slug":"kabbalah-for-dummies-cheat-sheet","categoryList":["body-mind-spirit","religion-spirituality","kabbalah"],"_links":{"self":"/articles/208741"}},{"articleId":230957,"title":"Nikon D3400 For Dummies Cheat Sheet","slug":"nikon-d3400-dummies-cheat-sheet","categoryList":["home-auto-hobbies","photography"],"_links":{"self":"/articles/230957"}},{"articleId":235851,"title":"Praying the Rosary and Meditating on the Mysteries","slug":"praying-rosary-meditating-mysteries","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/235851"}},{"articleId":284787,"title":"What Your Society Says About You","slug":"what-your-society-says-about-you","categoryList":["academics-the-arts","humanities"],"_links":{"self":"/articles/284787"}}],"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}},{"articleId":173421,"title":"Benefits of Records Management","slug":"benefits-of-records-management","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173421"}}],"fromCategory":[{"articleId":285910,"title":"Data Lakes For Dummies Cheat Sheet","slug":"data-lakes-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/285910"}},{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":207503,"title":"SAS For Dummies Cheat Sheet","slug":"sas-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207503"}},{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281849,"slug":"records-management-for-dummies","isbn":"9781118388082","categoryList":["technology","information-technology","data-science","databases"],"amazon":{"default":"https://www.amazon.com/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1118388089-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/records-management-for-dummies-cover-9781118388082-203x255.jpg","width":203,"height":255},"title":"Records Management For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p>Blake Richardson, CRM, is a Certified Records Manager with more than 15 years of experience managing records and information for several Fortune 500 companies. He has been a records manager for CNA Insurance and the Dollar General Corporation, and is active in ARMA International.</p>","authors":[{"authorId":34784,"name":"","slug":"","description":" <p><b> Joseph A. Allen, PhD</b> is a professor of industrial and organizational (I/O) psychology at the University of Utah. His articles have appeared in <i>Human Relations, Journal of Business Psychology</i>, and more.</p> <p><b>Karin M. Reed</b> is CEO of Speaker Dynamics, a corporate communications training firm. She is an Emmy award-winning broadcast journalist. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/34784"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118388082&quot;]}]\" id=\"du-slot-632218366ad27\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118388082&quot;]}]\" id=\"du-slot-632218366b5a0\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":173432},{"headers":{"creationTime":"2016-03-26T17:14:21+00:00","modifiedTime":"2016-03-26T17:14:21+00:00","timestamp":"2022-09-14T18:06:46+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Information Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33572"},"slug":"information-technology","categoryId":33572},{"name":"Data Science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"},"slug":"data-science","categoryId":33577},{"name":"Databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"},"slug":"databases","categoryId":33579}],"title":"Benefits of Records Management","strippedTitle":"benefits of records management","slug":"benefits-of-records-management","canonicalUrl":"","seo":{"metaDescription":"Properly managing your records can help you reduce operating expense, enhance customer service and ensure your company is in compliance with laws and regulation","noIndex":0,"noFollow":0},"content":"<p>Properly managing your records can help you reduce operating expense, enhance customer service and ensure your company is in compliance with laws and regulation.</p>\n<ul class=\"level-one\">\n <li><p class=\"first-para\"><b>Reduce operating expense.</b> Properly managing your records and information means that you only retain for a specific timeframe what you need for operational, legal, and compliance purposes and then appropriately dispose of it. This approach can eliminate the need to buy additional paper filing equipment and electronic storage. It can also reduce the cost of off-site record storage. </p>\n </li>\n <li><p class=\"first-para\"><b>Enhance customer service.</b> A good records management strategy ensures that you don’t retain unneeded information. This reduces the amount of clutter you have to search through. Being able to quickly locate the right information allows you to better serve your customers.</p>\n </li>\n <li><p class=\"first-para\"><b>Legal and compliance.</b> Implementing an effective records management program will allow you to identify records that are needed for legal and compliance purposes and ensure they are assigned the appropriate retention periods. This benefits organizations in the event of lawsuits, audits, and governmental inquiries.</p>\n </li>\n</ul>","description":"<p>Properly managing your records can help you reduce operating expense, enhance customer service and ensure your company is in compliance with laws and regulation.</p>\n<ul class=\"level-one\">\n <li><p class=\"first-para\"><b>Reduce operating expense.</b> Properly managing your records and information means that you only retain for a specific timeframe what you need for operational, legal, and compliance purposes and then appropriately dispose of it. This approach can eliminate the need to buy additional paper filing equipment and electronic storage. It can also reduce the cost of off-site record storage. </p>\n </li>\n <li><p class=\"first-para\"><b>Enhance customer service.</b> A good records management strategy ensures that you don’t retain unneeded information. This reduces the amount of clutter you have to search through. Being able to quickly locate the right information allows you to better serve your customers.</p>\n </li>\n <li><p class=\"first-para\"><b>Legal and compliance.</b> Implementing an effective records management program will allow you to identify records that are needed for legal and compliance purposes and ensure they are assigned the appropriate retention periods. This benefits organizations in the event of lawsuits, audits, and governmental inquiries.</p>\n </li>\n</ul>","blurb":"","authors":[{"authorId":9881,"name":"Blake Richardson CRM","slug":"blake-richardson","description":"Blake Richardson, CRM, is a certified records manager with more than 15 years of experience managing records and information for several Fortune 500 companies. He has been a records manager for CNA Insurance and the Dollar General Corporation, and is active in ARMA International. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9881"}},{"authorId":9882,"name":"CRM","slug":"crm","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9882"}}],"primaryCategoryTaxonomy":{"categoryId":33579,"title":"Databases","slug":"databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":208741,"title":"Kabbalah For Dummies Cheat Sheet","slug":"kabbalah-for-dummies-cheat-sheet","categoryList":["body-mind-spirit","religion-spirituality","kabbalah"],"_links":{"self":"/articles/208741"}},{"articleId":230957,"title":"Nikon D3400 For Dummies Cheat Sheet","slug":"nikon-d3400-dummies-cheat-sheet","categoryList":["home-auto-hobbies","photography"],"_links":{"self":"/articles/230957"}},{"articleId":235851,"title":"Praying the Rosary and Meditating on the Mysteries","slug":"praying-rosary-meditating-mysteries","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/235851"}},{"articleId":284787,"title":"What Your Society Says About You","slug":"what-your-society-says-about-you","categoryList":["academics-the-arts","humanities"],"_links":{"self":"/articles/284787"}}],"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}},{"articleId":173432,"title":"Managing Records on Local and Network Drives","slug":"managing-records-on-local-and-network-drives","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173432"}}],"fromCategory":[{"articleId":285910,"title":"Data Lakes For Dummies Cheat Sheet","slug":"data-lakes-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/285910"}},{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":207503,"title":"SAS For Dummies Cheat Sheet","slug":"sas-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207503"}},{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281849,"slug":"records-management-for-dummies","isbn":"9781118388082","categoryList":["technology","information-technology","data-science","databases"],"amazon":{"default":"https://www.amazon.com/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1118388089-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1118388089/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/records-management-for-dummies-cover-9781118388082-203x255.jpg","width":203,"height":255},"title":"Records Management For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p>Blake Richardson, CRM, is a Certified Records Manager with more than 15 years of experience managing records and information for several Fortune 500 companies. He has been a records manager for CNA Insurance and the Dollar General Corporation, and is active in ARMA International.</p>","authors":[{"authorId":34784,"name":"","slug":"","description":" <p><b> Joseph A. Allen, PhD</b> is a professor of industrial and organizational (I/O) psychology at the University of Utah. His articles have appeared in <i>Human Relations, Journal of Business Psychology</i>, and more.</p> <p><b>Karin M. Reed</b> is CEO of Speaker Dynamics, a corporate communications training firm. She is an Emmy award-winning broadcast journalist. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/34784"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118388082&quot;]}]\" id=\"du-slot-632218365c717\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781118388082&quot;]}]\" id=\"du-slot-632218365cfbd\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":173421},{"headers":{"creationTime":"2016-03-26T07:52:44+00:00","modifiedTime":"2016-03-26T07:52:44+00:00","timestamp":"2022-09-14T17:51:35+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Information Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33572"},"slug":"information-technology","categoryId":33572},{"name":"Data Science","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33577"},"slug":"data-science","categoryId":33577},{"name":"Databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"},"slug":"databases","categoryId":33579}],"title":"SAS Procedures and Their Location in SAS Enterprise Guide","strippedTitle":"sas procedures and their location in sas enterprise guide","slug":"sas-procedures-and-their-location-in-sas-enterprise-guide","canonicalUrl":"","seo":{"metaDescription":"The tasks in SAS Enterprise Guide and SAS Add-In for Microsoft Office cover a wide range of SAS capabilities. These SAS tasks are easy-to-use interfaces that cr","noIndex":0,"noFollow":0},"content":"<p>The tasks in SAS Enterprise Guide and SAS Add-In for Microsoft Office cover a wide range of SAS capabilities. These SAS tasks are easy-to-use interfaces that create SAS programs to do their work. The programs call on SAS procedures, where each procedure represents a specialized capability. And to make it even more interesting, SAS (the company) provides these procedures in product bundles, which must be separately licensed for customers to use them. With all of this at work, it can be tricky to keep track of which tasks use which procedures that need which SAS products.</p>\n<p>The following table lays it all out for you: all the tasks, how to find them in the menu, which procedures they use, and which SAS products are involved.</p>\n<table>\n<tr>\n<th>Task<br />\nand<br />\nMenu Location</th>\n<th>SAS Procedures<br />\nand<br />\nSAS Products</th>\n</tr>\n<tr>\n<td>Import Data<br />\n(Excel)<br />\n<br />\nFile→Import Data</td>\n<td>DATA step; IMPORT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Open<br />\nInformation Map<br />\n<br />\nFile→Open</td>\n<td>DATA step<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Linear Models<br />\n<br />\nTasks→ANOVA</td>\n<td>GLM<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Mixed Models<br />\n<br />\nTasks→ANOVA</td>\n<td>MIXED<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Nonparametric<br />\nOne-Way<br />\nANOVA<br />\n<br />\nTasks→ANOVA</td>\n<td>NPAR1WAY<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>One-Way<br />\nANOVA<br />\n<br />\nTasks→ANOVA</td>\n<td>ANOVA; GPLOT<br />\n<br />\nSAS/STAT; SAS/GRAPH</td>\n</tr>\n<tr>\n<td>t Test<br />\n<br />\nTasks→ANOVA</td>\n<td>TTEST<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>CDF Plots<br />\n<br />\nTasks--<br />\n>Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Histograms<br />\n<br />\nTasks--<br />\n>Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>P-P Plots<br />\n<br />\nTasks--<br />\n>Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Probability<br />\nPlots<br />\n<br />\nTasks→Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Q-Q Plots<br />\n<br />\nTasks--<br />\n>Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Box Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>c Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Individual<br />\nMeasurements<br />\nChart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Mean and<br />\nRange Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Mean and<br />\nStandard<br />\nDeviation Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>np Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>p Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>u Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Append Table<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Compare Data<br />\n<br />\nTasks→Data</td>\n<td>COMPARE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Create Format<br />\n<br />\nTasks→Data</td>\n<td>FORMAT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Data Set<br />\nAttributes<br />\n<br />\nTasks→Data</td>\n<td>DATASETS<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Delete Data<br />\nSets and<br />\nFormats<br />\n<br />\nTasks→Data</td>\n<td>DELETE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Download Data<br />\nFiles to PC<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Filter and Sort<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Query Builder<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Random Sample<br />\n<br />\nTasks→Data</td>\n<td>SURVEYSELECT<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Rank<br />\n<br />\nTasks→Data</td>\n<td>RANK<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Sort Data<br />\n<br />\nTasks→Data</td>\n<td>SORT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Split Columns<br />\n<br />\nTasks→Data</td>\n<td>TRANSPOSE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Stack Columns<br />\n<br />\nTasks→Data</td>\n<td>TRANSPOSE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Standardize<br />\nData<br />\n<br />\nTasks→Data</td>\n<td>STANDARD<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Table Analysis<br />\n<br />\nTasks→Data</td>\n<td>FREQ<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Transpose<br />\n<br />\nTasks→Data</td>\n<td>TRANSPOSE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Upload Data to<br />\nSAS Server<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Import from<br />\nSPSS<br />\n<br />\nTasks→Data</td>\n<td>IMPORT<br />\n<br />\nSAS/ACCESS<br />\nInterface to PC File<br />\nFormats</td>\n</tr>\n<tr>\n<td>Import from JMP<br />\n<br />\nTasks→Data</td>\n<td>IMPORT<br />\n<br />\nSAS/ACCESS<br />\nInterface to PC File<br />\nFormats</td>\n</tr>\n<tr>\n<td>Import from<br />\nStata<br />\n<br />\nTasks→Data</td>\n<td>IMPORT<br />\n<br />\nSAS/ACCESS<br />\nInterface to PC File<br />\nFormats</td>\n</tr>\n<tr>\n<td>Characterize Data Wizard<br />\n<br />\nTasks→Describe</td>\n<td>CONTENTS;<br />\nUNIVARIATE;<br />\nFREQ<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Distribution<br />\nAnalysis<br />\n<br />\nTasks→Describe</td>\n<td>UNIVARIATE<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>List Data<br />\n<br />\nTasks→Describe</td>\n<td>PRINT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>List Report<br />\n<br />\nTasks→Describe</td>\n<td>REPORT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>One-Way<br />\nFrequencies<br />\n<br />\nTasks→Describe</td>\n<td>FREQ<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Summary Statistics<br />\n<br />\nTasks→Describe</td>\n<td>MEANS<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Summary Tables<br />\n<br />\nTasks→Describe</td>\n<td>TABULATE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Area Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Bar Chart<br />\n<br />\nTasks→Graph</td>\n<td>GCHART<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Bar-Line Chart<br />\n<br />\nTasks→Graph</td>\n<td>GBARLINE<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Box Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Bubble Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Contour Plot<br />\n<br />\nTasks→Graph</td>\n<td>GCONTOUR<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Create Map<br />\nFeature Table<br />\n<br />\nTasks→Graph</td>\n<td>GPROJECT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Donut Chart<br />\n<br />\nTasks→Graph</td>\n<td>GCHART<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Line Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Map Graph<br />\n<br />\nTasks→Graph</td>\n<td>GMAP<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Pie Chart<br />\n<br />\nTasks→Graph</td>\n<td>GCHART<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Radar Chart<br />\n<br />\nTasks→Graph</td>\n<td>GRADAR<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Scatter Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT; G3D<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Surface Plot<br />\n<br />\nTasks→Graph</td>\n<td>G3D<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Tile Chart<br />\n<br />\nTasks→Graph</td>\n<td>GTILE<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Model Scoring<br />\n<br />\nTasks→Model Scoring</td>\n<td>NONE<br />\n<br />\nSAS Enterprise Miner</td>\n</tr>\n<tr>\n<td>Canonical<br />\nCorrelation<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>CANCORR<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Cluster Analysis<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>CLUSTER, TREE,<br />\nFASTCLUS<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Correlations<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>CORR<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Discriminant Analysis<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>DISCRIM<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Factor Analysis<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>FACTOR<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Principal<br />\nComponents<br />\n<br />\nTasks→Multivariate</td>\n<td>PRINCOMP<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Pareto Chart<br />\n<br />\nTasks→Pareto</td>\n<td>PARETO<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Generalized Linear<br />\nModels<br />\n<br />\nTasks→<br />\nRegression</td>\n<td>GENMOD<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Linear Regression<br />\n<br />\nTasks→<br />\nRegression</td>\n<td>REG<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Logistic Regression<br />\n<br />\nTasks→<br />\nRegression</td>\n<td>LOGISTIC<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Nonlinear<br />\nRegression<br />\n<br />\nTasks→<br />\nRegression</td>\n<td>NLIN<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Life Tables<br />\n<br />\nTasks→<br />\nSurvival Analysis</td>\n<td>LIFETEST<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Proportional<br />\nHazards<br />\n<br />\nTasks→<br />\nSurvival Analysis</td>\n<td>PHREG<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>ARIMA Modeling<br />\nand Forecasting<br />\n<br />\nTasks→<br />\nTime Series</td>\n<td>ARIMA<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Basic Forecasting<br />\n<br />\nTasks→<br />\nTime Series</td>\n<td>FORECAST<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Create Time<br />\nSeries Data<br />\n<br />\nTasks→<br />\nTime Series</td>\n<td>TIMESERIES<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Forecast Studio<br />\nCreate Project<br />\nWizard<br />\n<br />\nTasks→<br />\nTime Series</td>\n<td>Forecast Studio<br />\n<br />\nSAS<br />\nForecast Server</td>\n</tr>\n<tr>\n<td>Forecast Studio<br />\nOpen Project Wizard<br />\n<br />\nTasks→Time<br />\nSeries</td>\n<td>Forecast Studio<br />\n<br />\nSAS<br />\nForecast Server</td>\n</tr>\n<tr>\n<td>Forecast Studio<br />\nOverride Wizard<br />\n<br />\nTasks→Time Series</td>\n<td>Forecast Studio<br />\n<br />\nSAS<br />\nForecast Server</td>\n</tr>\n<tr>\n<td>Prepare Time<br />\nSeries Data<br />\n<br />\nTasks→Time<br />\nSeries</td>\n<td>EXPAND<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Regression<br />\nAnalysis of Panel<br />\nData<br />\n<br />\nTasks→Time<br />\nSeries</td>\n<td>TSCSREG<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Regression<br />\nAnalysis with<br />\nAutoregressive<br />\nErrors<br />\n<br />\nTasks→Time<br />\nSeries</td>\n<td>AUTOREG<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Update Library<br />\nMetadata<br />\n<br />\nTools</td>\n<td>METALIB<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Assign Project<br />\nLibrary<br />\n<br />\nTools</td>\n<td>LIBNAME<br />\n<br />\nBase SAS</td>\n</tr>\n</table>","description":"<p>The tasks in SAS Enterprise Guide and SAS Add-In for Microsoft Office cover a wide range of SAS capabilities. These SAS tasks are easy-to-use interfaces that create SAS programs to do their work. The programs call on SAS procedures, where each procedure represents a specialized capability. And to make it even more interesting, SAS (the company) provides these procedures in product bundles, which must be separately licensed for customers to use them. With all of this at work, it can be tricky to keep track of which tasks use which procedures that need which SAS products.</p>\n<p>The following table lays it all out for you: all the tasks, how to find them in the menu, which procedures they use, and which SAS products are involved.</p>\n<table>\n<tr>\n<th>Task<br />\nand<br />\nMenu Location</th>\n<th>SAS Procedures<br />\nand<br />\nSAS Products</th>\n</tr>\n<tr>\n<td>Import Data<br />\n(Excel)<br />\n<br />\nFile→Import Data</td>\n<td>DATA step; IMPORT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Open<br />\nInformation Map<br />\n<br />\nFile→Open</td>\n<td>DATA step<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Linear Models<br />\n<br />\nTasks→ANOVA</td>\n<td>GLM<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Mixed Models<br />\n<br />\nTasks→ANOVA</td>\n<td>MIXED<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Nonparametric<br />\nOne-Way<br />\nANOVA<br />\n<br />\nTasks→ANOVA</td>\n<td>NPAR1WAY<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>One-Way<br />\nANOVA<br />\n<br />\nTasks→ANOVA</td>\n<td>ANOVA; GPLOT<br />\n<br />\nSAS/STAT; SAS/GRAPH</td>\n</tr>\n<tr>\n<td>t Test<br />\n<br />\nTasks→ANOVA</td>\n<td>TTEST<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>CDF Plots<br />\n<br />\nTasks--<br />\n>Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Histograms<br />\n<br />\nTasks--<br />\n>Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>P-P Plots<br />\n<br />\nTasks--<br />\n>Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Probability<br />\nPlots<br />\n<br />\nTasks→Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Q-Q Plots<br />\n<br />\nTasks--<br />\n>Capability</td>\n<td>CAPABILITY<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Box Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>c Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Individual<br />\nMeasurements<br />\nChart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Mean and<br />\nRange Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Mean and<br />\nStandard<br />\nDeviation Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>np Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>p Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>u Chart<br />\n<br />\nTasks→Control<br />\nCharts</td>\n<td>SHEWHART<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Append Table<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Compare Data<br />\n<br />\nTasks→Data</td>\n<td>COMPARE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Create Format<br />\n<br />\nTasks→Data</td>\n<td>FORMAT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Data Set<br />\nAttributes<br />\n<br />\nTasks→Data</td>\n<td>DATASETS<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Delete Data<br />\nSets and<br />\nFormats<br />\n<br />\nTasks→Data</td>\n<td>DELETE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Download Data<br />\nFiles to PC<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Filter and Sort<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Query Builder<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Random Sample<br />\n<br />\nTasks→Data</td>\n<td>SURVEYSELECT<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Rank<br />\n<br />\nTasks→Data</td>\n<td>RANK<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Sort Data<br />\n<br />\nTasks→Data</td>\n<td>SORT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Split Columns<br />\n<br />\nTasks→Data</td>\n<td>TRANSPOSE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Stack Columns<br />\n<br />\nTasks→Data</td>\n<td>TRANSPOSE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Standardize<br />\nData<br />\n<br />\nTasks→Data</td>\n<td>STANDARD<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Table Analysis<br />\n<br />\nTasks→Data</td>\n<td>FREQ<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Transpose<br />\n<br />\nTasks→Data</td>\n<td>TRANSPOSE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Upload Data to<br />\nSAS Server<br />\n<br />\nTasks→Data</td>\n<td>SQL<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Import from<br />\nSPSS<br />\n<br />\nTasks→Data</td>\n<td>IMPORT<br />\n<br />\nSAS/ACCESS<br />\nInterface to PC File<br />\nFormats</td>\n</tr>\n<tr>\n<td>Import from JMP<br />\n<br />\nTasks→Data</td>\n<td>IMPORT<br />\n<br />\nSAS/ACCESS<br />\nInterface to PC File<br />\nFormats</td>\n</tr>\n<tr>\n<td>Import from<br />\nStata<br />\n<br />\nTasks→Data</td>\n<td>IMPORT<br />\n<br />\nSAS/ACCESS<br />\nInterface to PC File<br />\nFormats</td>\n</tr>\n<tr>\n<td>Characterize Data Wizard<br />\n<br />\nTasks→Describe</td>\n<td>CONTENTS;<br />\nUNIVARIATE;<br />\nFREQ<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Distribution<br />\nAnalysis<br />\n<br />\nTasks→Describe</td>\n<td>UNIVARIATE<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>List Data<br />\n<br />\nTasks→Describe</td>\n<td>PRINT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>List Report<br />\n<br />\nTasks→Describe</td>\n<td>REPORT<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>One-Way<br />\nFrequencies<br />\n<br />\nTasks→Describe</td>\n<td>FREQ<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Summary Statistics<br />\n<br />\nTasks→Describe</td>\n<td>MEANS<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Summary Tables<br />\n<br />\nTasks→Describe</td>\n<td>TABULATE<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Area Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Bar Chart<br />\n<br />\nTasks→Graph</td>\n<td>GCHART<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Bar-Line Chart<br />\n<br />\nTasks→Graph</td>\n<td>GBARLINE<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Box Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Bubble Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Contour Plot<br />\n<br />\nTasks→Graph</td>\n<td>GCONTOUR<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Create Map<br />\nFeature Table<br />\n<br />\nTasks→Graph</td>\n<td>GPROJECT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Donut Chart<br />\n<br />\nTasks→Graph</td>\n<td>GCHART<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Line Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Map Graph<br />\n<br />\nTasks→Graph</td>\n<td>GMAP<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Pie Chart<br />\n<br />\nTasks→Graph</td>\n<td>GCHART<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Radar Chart<br />\n<br />\nTasks→Graph</td>\n<td>GRADAR<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Scatter Plot<br />\n<br />\nTasks→Graph</td>\n<td>GPLOT; G3D<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Surface Plot<br />\n<br />\nTasks→Graph</td>\n<td>G3D<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Tile Chart<br />\n<br />\nTasks→Graph</td>\n<td>GTILE<br />\n<br />\nSAS/GRAPH</td>\n</tr>\n<tr>\n<td>Model Scoring<br />\n<br />\nTasks→Model Scoring</td>\n<td>NONE<br />\n<br />\nSAS Enterprise Miner</td>\n</tr>\n<tr>\n<td>Canonical<br />\nCorrelation<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>CANCORR<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Cluster Analysis<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>CLUSTER, TREE,<br />\nFASTCLUS<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Correlations<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>CORR<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Discriminant Analysis<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>DISCRIM<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Factor Analysis<br />\n<br />\nTasks→<br />\nMultivariate</td>\n<td>FACTOR<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Principal<br />\nComponents<br />\n<br />\nTasks→Multivariate</td>\n<td>PRINCOMP<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Pareto Chart<br />\n<br />\nTasks→Pareto</td>\n<td>PARETO<br />\n<br />\nSAS/QC</td>\n</tr>\n<tr>\n<td>Generalized Linear<br />\nModels<br />\n<br />\nTasks→<br />\nRegression</td>\n<td>GENMOD<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Linear Regression<br />\n<br />\nTasks→<br />\nRegression</td>\n<td>REG<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Logistic Regression<br />\n<br />\nTasks→<br />\nRegression</td>\n<td>LOGISTIC<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Nonlinear<br />\nRegression<br />\n<br />\nTasks→<br />\nRegression</td>\n<td>NLIN<br />\n<br />\nSAS/STAT</td>\n</tr>\n<tr>\n<td>Life Tables<br />\n<br />\nTasks→<br />\nSurvival Analysis</td>\n<td>LIFETEST<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Proportional<br />\nHazards<br />\n<br />\nTasks→<br />\nSurvival Analysis</td>\n<td>PHREG<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>ARIMA Modeling<br />\nand Forecasting<br />\n<br />\nTasks→<br />\nTime Series</td>\n<td>ARIMA<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Basic Forecasting<br />\n<br />\nTasks→<br />\nTime Series</td>\n<td>FORECAST<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Create Time<br />\nSeries Data<br />\n<br />\nTasks→<br />\nTime Series</td>\n<td>TIMESERIES<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Forecast Studio<br />\nCreate Project<br />\nWizard<br />\n<br />\nTasks→<br />\nTime Series</td>\n<td>Forecast Studio<br />\n<br />\nSAS<br />\nForecast Server</td>\n</tr>\n<tr>\n<td>Forecast Studio<br />\nOpen Project Wizard<br />\n<br />\nTasks→Time<br />\nSeries</td>\n<td>Forecast Studio<br />\n<br />\nSAS<br />\nForecast Server</td>\n</tr>\n<tr>\n<td>Forecast Studio<br />\nOverride Wizard<br />\n<br />\nTasks→Time Series</td>\n<td>Forecast Studio<br />\n<br />\nSAS<br />\nForecast Server</td>\n</tr>\n<tr>\n<td>Prepare Time<br />\nSeries Data<br />\n<br />\nTasks→Time<br />\nSeries</td>\n<td>EXPAND<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Regression<br />\nAnalysis of Panel<br />\nData<br />\n<br />\nTasks→Time<br />\nSeries</td>\n<td>TSCSREG<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Regression<br />\nAnalysis with<br />\nAutoregressive<br />\nErrors<br />\n<br />\nTasks→Time<br />\nSeries</td>\n<td>AUTOREG<br />\n<br />\nSAS/ETS</td>\n</tr>\n<tr>\n<td>Update Library<br />\nMetadata<br />\n<br />\nTools</td>\n<td>METALIB<br />\n<br />\nBase SAS</td>\n</tr>\n<tr>\n<td>Assign Project<br />\nLibrary<br />\n<br />\nTools</td>\n<td>LIBNAME<br />\n<br />\nBase SAS</td>\n</tr>\n</table>","blurb":"","authors":[{"authorId":9190,"name":"Stephen McDaniel","slug":"stephen-mcdaniel","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9190"}},{"authorId":9191,"name":"Chris Hemedinger","slug":"chris-hemedinger","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9191"}}],"primaryCategoryTaxonomy":{"categoryId":33579,"title":"Databases","slug":"databases","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33579"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":208741,"title":"Kabbalah For Dummies Cheat Sheet","slug":"kabbalah-for-dummies-cheat-sheet","categoryList":["body-mind-spirit","religion-spirituality","kabbalah"],"_links":{"self":"/articles/208741"}},{"articleId":230957,"title":"Nikon D3400 For Dummies Cheat Sheet","slug":"nikon-d3400-dummies-cheat-sheet","categoryList":["home-auto-hobbies","photography"],"_links":{"self":"/articles/230957"}},{"articleId":235851,"title":"Praying the Rosary and Meditating on the Mysteries","slug":"praying-rosary-meditating-mysteries","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/235851"}},{"articleId":284787,"title":"What Your Society Says About You","slug":"what-your-society-says-about-you","categoryList":["academics-the-arts","humanities"],"_links":{"self":"/articles/284787"}}],"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":207503,"title":"SAS For Dummies Cheat Sheet","slug":"sas-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207503"}},{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}}],"fromCategory":[{"articleId":285910,"title":"Data Lakes For Dummies Cheat Sheet","slug":"data-lakes-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/285910"}},{"articleId":208207,"title":"Records Management For Dummies Cheat Sheet","slug":"records-management-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/208207"}},{"articleId":207503,"title":"SAS For Dummies Cheat Sheet","slug":"sas-for-dummies-cheat-sheet","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207503"}},{"articleId":193380,"title":"Selecting the Correct SAS Product","slug":"selecting-the-correct-sas-product","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193380"}},{"articleId":173434,"title":"Appraising Records and Managing Retention Scheduling","slug":"appraising-records-and-managing-retention-scheduling","categoryList":["technology","information-technology","data-science","databases"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/173434"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281857,"slug":"sas-for-dummies-2nd-edition","isbn":"9780470539682","categoryList":["technology","information-technology","data-science","databases"],"amazon":{"default":"https://www.amazon.com/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/0470539682-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/0470539682/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/sas-for-dummies-2nd-edition-cover-9780470539682-203x255.jpg","width":203,"height":255},"title":"SAS For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9190\">Stephen McDaniel</b> is Principal and cofounder of Freakalytics™ LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b data-author-id=\"9191\">Chris Hemedinger</b> works in SAS R&amp;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. </p>","authors":[{"authorId":9190,"name":"Stephen McDaniel","slug":"stephen-mcdaniel","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9190"}},{"authorId":9191,"name":"Chris Hemedinger","slug":"chris-hemedinger","description":" <p><b>Stephen McDaniel</b> is Principal and cofounder of Freakalytics&#8482; LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development. <b>Chris Hemedinger</b> works in SAS R&#38;D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9191"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470539682&quot;]}]\" id=\"du-slot-632214a77f112\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;information-technology&quot;,&quot;data-science&quot;,&quot;databases&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470539682&quot;]}]\" id=\"du-slot-632214a78fe4a\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":143291}],"_links":{"self":{"self":"https://dummies-api.dummies.com/v2/categories/33579/categoryArticles?sortField=time&sortOrder=1&size=10&offset=0"}}},"objectTitle":"","status":"success","pageType":"article-category","objectId":"33579","page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{"categoriesFilter":[{"itemId":0,"itemName":"All Categories","count":8}],"articleTypeFilter":[{"articleType":"All Types","count":8},{"articleType":"Articles","count":5},{"articleType":"Cheat Sheet","count":3}]},"filterDataLoadedStatus":"success","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2025-04-17T15:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"<!--Optimizely Script-->\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"<!-- comScore Tag -->\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n<!-- / comScore Tag -->","enabled":true},{"pages":["all"],"location":"footer","script":"<!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>\r\n<!--END WEBSITE FEEDBACK SNIPPET-->","enabled":false},{"pages":["all"],"location":"header","script":"<!-- Hotjar Tracking Code for http://www.dummies.com -->\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":"<!-- //Connect Container: dummies --> <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"<!-- Facebook Pixel Code -->\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n<!-- End Facebook Pixel Code -->","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"ArticleCategory","path":"/category/articles/databases-33579/","hash":"","query":{},"params":{"category":"databases-33579"},"fullPath":"/category/articles/databases-33579/","meta":{"routeType":"category","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"profileState":{"auth":{},"userOptions":{},"status":"success"}}
Logo
  • Articles Open Article Categories
  • Books Open Book Categories
  • Collections Open Collections list
  • Custom Solutions

Article Categories

Book Categories

Collections

Explore all collections
BYOB (Be Your Own Boss)
Be a Rad Dad
Career Shifting
Contemplating the Cosmos
For Those Seeking Peace of Mind
For the Aspiring Aficionado
For the Budding Cannabis Enthusiast
For the College Bound
For the Exam-Season Crammer
For the Game Day Prepper
Log In
  • Home
  • Technology Articles
  • Information Technology Articles
  • Data Science Articles
  • Databases Articles

Databases Articles

All that data's gotta go somewhere. And it's usually in a database of some kind. Learn about records management, SAS best practices, and more.

Articles From Databases

Filter Results

8 results
8 results
Databases Records Management For Dummies Cheat Sheet

Cheat Sheet / Updated 03-25-2022

Whether you’re a small business owner or work for a global corporation, you deal with information every day. You receive information, you send it, you determine what’s relevant, and you make decisions, whether consciously or subconsciously, about what information to retain. That’s why records management — managing the flood of information you get every day — should be such an important part of your business strategy. This Cheat Sheet can serve as a quick reference to some of the main aspects of record management.

View Cheat Sheet
Databases SAS For Dummies Cheat Sheet

Cheat Sheet / Updated 03-01-2022

SAS Institute has hundreds of statistical analysis system products, so a partial list of the ones you might run will help you know which one to use for your job. The tasks in SAS Enterprise Guide and SAS Add-In for Microsoft Office create SAS programs that call on SAS procedures. Having a list of those procedures and being able to find them quickly in SAS Enterprise Guide will boost your efficiency.

View Cheat Sheet
Databases Data Lakes For Dummies Cheat Sheet

Cheat Sheet / Updated 02-25-2022

A data lake is an enterprise-scale home for analytical data from all corners of your company or governmental agency. No matter what your analytical data landscape looks like today, your organization will benefit from building a data lake.

View Cheat Sheet
Databases Selecting the Correct SAS Product

Article / Updated 03-26-2016

SAS Institute offers hundreds of SAS products, and sometimes it's difficult to decide which tool you should use for your work. Here is a partial list of SAS products you might encounter and who uses them for what purpose. As a SAS customer, you might use just one of these products or a few of them; if you're really lucky, you might use them all. SAS, or the SAS System The SAS System is the original SAS product that customers have used in one form or another for more than 30 years, on systems ranging from big mainframes to laptops. It's also known as Display Manager (the name of the windowing interface), or Base SAS, or just plain old SAS. The SAS System is primarily a tool for people comfortable with writing SAS programs. It contains the data processing and analytics engine that is at the core of most SAS products. SAS Enterprise Guide SAS Enterprise Guide provides a modern, easy-to-use interface to much of the power of SAS. SAS Enterprise Guide is used by SAS programmers, business analysts (who might or might not have programming skills), and statisticians. It’s a Microsoft Windows application that can connect to SAS; you can use it to drive the SAS analytics engine running on a mainframe, UNIX, or other remote machines as a server application. SAS Enterprise Guide is like a general store for SAS, where you can get a little bit of everything that SAS has to offer. SAS Data Integration Studio SAS Data Integration Studio is used to create and maintain data warehouses and data marts, which are specialized stores of data that have been prepared for effective reporting and analytics. Data experts, such as database administrators and IT specialists — people who support other folks who have to create reports — use SAS Data Integration Studio. Like SAS Enterprise Guide, this is a client application that runs on your desktop and provides an intuitive user interface, but it can connect to SAS and databases that run on machines all over your organization. SAS Enterprise Miner SAS Enterprise Miner is used for data mining, or investigating patterns in large amounts of data. Statisticians and professional modelers use SAS Enterprise Miner to segment data and create descriptive or predictive models. For example, a bank might use such a model to predict how likely you are to respond to a certain credit card offering. If your data profile is similar enough to others who have responded to similar offers, SAS Enterprise Miner would produce a model that indicates you're worth sending the offer to. Hello, Platinum card! SAS Add-In for Microsoft Office Some people spend most of their working days working with a Microsoft Office application such as Excel or PowerPoint. SAS Add-In for Microsoft Office lets you open SAS data sources and run SAS analyses without ever having to leave the comfy world of your spreadsheet or slideshow. SAS Add-In for Microsoft Office is used by business analysts who don't really need to know anything about SAS programming but need the answers that SAS can provide. SAS Web Report Studio All business intelligence software vendors must have a Web-based reporting product, and SAS Web Report Studio fits that bill. SAS Web Report Studio allows you to create and distribute reports to anyone who needs them, all without leaving your Web browser. SAS Forecast Studio SAS Forecast Studio analyzes time-based data and forecasting future trends and events. It's like a crystal ball, only better! SAS Forecast Studio is used by professional modelers or statisticians who understand concepts such as seasonality and intermittent demand models. However, no SAS programming is required! JMP JMP is a standalone, highly visual analytics product. It runs on Microsoft Windows, Apple Macintosh, or Linux-based computers. JMP is sometimes packaged with SAS and can work with other SAS products, but most often it's used by researchers, engineers, and quality-control experts who want advanced analytics without a big software footprint.

View Article
Databases Appraising Records and Managing Retention Scheduling

Article / Updated 03-26-2016

A fundamental part of a successful records and information management program is identifying what records and information your company possesses and then applying appropriate retention periods. Records appraisal. There are different methods for appraising your records and information, including inventories, interviews, and questionnaires. Picking the right appraisal method for your organization is important. The appraisal allows you to identify what records and information the organization possesses and forms the basis for your company’s record retention schedule. Retention schedule. The retention schedule is typically the most referenced records management program document. It allows employees to determine how long they should keep their records and information. Records Management For Dummies addresses three distinct retention schedule methods: departmental, functional, and big bucket.

View Article
Databases Managing Records on Local and Network Drives

Article / Updated 03-26-2016

The amount of electronic information has grown exponentially over the past decade. Local (C: Drives) and network drives are becoming digital graveyards. An effective records management program will provide you with the knowledge and tools you need to ensure that electronic files are properly managed. Folder structures and names. Creating an electronic folder structure that meets the needs of each department and ensuring that the folders within the structure are logically named are critical for accurate electronic filing, retrieval, and file maintenance (clean-up). File naming conventions. After you have created the proper electronic folder structure, it’s important to ensure that your files are also named in an appropriate manner. A rule of thumb for naming your files is that you should be able to determine the contents of a file without having to open it. This means avoiding cryptic names such as abbreviations, acronyms, and numbers. Maintenance. It is important to regularly review your folders and files to determine what is no longer needed. Microsoft Windows allows you to determine the last access and modification dates of a file. This is a good starting point in determining whether a file can be deleted. However, employees should always reference the organization’s record retention schedule before deleting any files in order to determine if the file is eligible for deletion.

View Article
Databases Benefits of Records Management

Article / Updated 03-26-2016

Properly managing your records can help you reduce operating expense, enhance customer service and ensure your company is in compliance with laws and regulation. Reduce operating expense. Properly managing your records and information means that you only retain for a specific timeframe what you need for operational, legal, and compliance purposes and then appropriately dispose of it. This approach can eliminate the need to buy additional paper filing equipment and electronic storage. It can also reduce the cost of off-site record storage. Enhance customer service. A good records management strategy ensures that you don’t retain unneeded information. This reduces the amount of clutter you have to search through. Being able to quickly locate the right information allows you to better serve your customers. Legal and compliance. Implementing an effective records management program will allow you to identify records that are needed for legal and compliance purposes and ensure they are assigned the appropriate retention periods. This benefits organizations in the event of lawsuits, audits, and governmental inquiries.

View Article
Databases SAS Procedures and Their Location in SAS Enterprise Guide

Article / Updated 03-26-2016

The tasks in SAS Enterprise Guide and SAS Add-In for Microsoft Office cover a wide range of SAS capabilities. These SAS tasks are easy-to-use interfaces that create SAS programs to do their work. The programs call on SAS procedures, where each procedure represents a specialized capability. And to make it even more interesting, SAS (the company) provides these procedures in product bundles, which must be separately licensed for customers to use them. With all of this at work, it can be tricky to keep track of which tasks use which procedures that need which SAS products. The following table lays it all out for you: all the tasks, how to find them in the menu, which procedures they use, and which SAS products are involved. Task and Menu Location SAS Procedures and SAS Products Import Data (Excel) File→Import Data DATA step; IMPORT Base SAS Open Information Map File→Open DATA step Base SAS Linear Models Tasks→ANOVA GLM SAS/STAT Mixed Models Tasks→ANOVA MIXED SAS/STAT Nonparametric One-Way ANOVA Tasks→ANOVA NPAR1WAY SAS/STAT One-Way ANOVA Tasks→ANOVA ANOVA; GPLOT SAS/STAT; SAS/GRAPH t Test Tasks→ANOVA TTEST SAS/STAT CDF Plots Tasks-- >Capability CAPABILITY SAS/QC Histograms Tasks-- >Capability CAPABILITY SAS/QC P-P Plots Tasks-- >Capability CAPABILITY SAS/QC Probability Plots Tasks→Capability CAPABILITY SAS/QC Q-Q Plots Tasks-- >Capability CAPABILITY SAS/QC Box Chart Tasks→Control Charts SHEWHART SAS/QC c Chart Tasks→Control Charts SHEWHART SAS/QC Individual Measurements Chart Tasks→Control Charts SHEWHART SAS/QC Mean and Range Chart Tasks→Control Charts SHEWHART SAS/QC Mean and Standard Deviation Chart Tasks→Control Charts SHEWHART SAS/QC np Chart Tasks→Control Charts SHEWHART SAS/QC p Chart Tasks→Control Charts SHEWHART SAS/QC u Chart Tasks→Control Charts SHEWHART SAS/QC Append Table Tasks→Data SQL Base SAS Compare Data Tasks→Data COMPARE Base SAS Create Format Tasks→Data FORMAT Base SAS Data Set Attributes Tasks→Data DATASETS Base SAS Delete Data Sets and Formats Tasks→Data DELETE Base SAS Download Data Files to PC Tasks→Data SQL Base SAS Filter and Sort Tasks→Data SQL Base SAS Query Builder Tasks→Data SQL Base SAS Random Sample Tasks→Data SURVEYSELECT SAS/STAT Rank Tasks→Data RANK Base SAS Sort Data Tasks→Data SORT Base SAS Split Columns Tasks→Data TRANSPOSE Base SAS Stack Columns Tasks→Data TRANSPOSE Base SAS Standardize Data Tasks→Data STANDARD Base SAS Table Analysis Tasks→Data FREQ Base SAS Transpose Tasks→Data TRANSPOSE Base SAS Upload Data to SAS Server Tasks→Data SQL Base SAS Import from SPSS Tasks→Data IMPORT SAS/ACCESS Interface to PC File Formats Import from JMP Tasks→Data IMPORT SAS/ACCESS Interface to PC File Formats Import from Stata Tasks→Data IMPORT SAS/ACCESS Interface to PC File Formats Characterize Data Wizard Tasks→Describe CONTENTS; UNIVARIATE; FREQ SAS/STAT Distribution Analysis Tasks→Describe UNIVARIATE SAS/STAT List Data Tasks→Describe PRINT Base SAS List Report Tasks→Describe REPORT Base SAS One-Way Frequencies Tasks→Describe FREQ Base SAS Summary Statistics Tasks→Describe MEANS Base SAS Summary Tables Tasks→Describe TABULATE Base SAS Area Plot Tasks→Graph GPLOT SAS/GRAPH Bar Chart Tasks→Graph GCHART SAS/GRAPH Bar-Line Chart Tasks→Graph GBARLINE SAS/GRAPH Box Plot Tasks→Graph GPLOT SAS/GRAPH Bubble Plot Tasks→Graph GPLOT SAS/GRAPH Contour Plot Tasks→Graph GCONTOUR SAS/GRAPH Create Map Feature Table Tasks→Graph GPROJECT SAS/GRAPH Donut Chart Tasks→Graph GCHART SAS/GRAPH Line Plot Tasks→Graph GPLOT SAS/GRAPH Map Graph Tasks→Graph GMAP SAS/GRAPH Pie Chart Tasks→Graph GCHART SAS/GRAPH Radar Chart Tasks→Graph GRADAR SAS/GRAPH Scatter Plot Tasks→Graph GPLOT; G3D SAS/GRAPH Surface Plot Tasks→Graph G3D SAS/GRAPH Tile Chart Tasks→Graph GTILE SAS/GRAPH Model Scoring Tasks→Model Scoring NONE SAS Enterprise Miner Canonical Correlation Tasks→ Multivariate CANCORR SAS/STAT Cluster Analysis Tasks→ Multivariate CLUSTER, TREE, FASTCLUS SAS/STAT Correlations Tasks→ Multivariate CORR Base SAS Discriminant Analysis Tasks→ Multivariate DISCRIM SAS/STAT Factor Analysis Tasks→ Multivariate FACTOR SAS/STAT Principal Components Tasks→Multivariate PRINCOMP SAS/STAT Pareto Chart Tasks→Pareto PARETO SAS/QC Generalized Linear Models Tasks→ Regression GENMOD SAS/STAT Linear Regression Tasks→ Regression REG SAS/STAT Logistic Regression Tasks→ Regression LOGISTIC SAS/STAT Nonlinear Regression Tasks→ Regression NLIN SAS/STAT Life Tables Tasks→ Survival Analysis LIFETEST SAS/ETS Proportional Hazards Tasks→ Survival Analysis PHREG SAS/ETS ARIMA Modeling and Forecasting Tasks→ Time Series ARIMA SAS/ETS Basic Forecasting Tasks→ Time Series FORECAST SAS/ETS Create Time Series Data Tasks→ Time Series TIMESERIES SAS/ETS Forecast Studio Create Project Wizard Tasks→ Time Series Forecast Studio SAS Forecast Server Forecast Studio Open Project Wizard Tasks→Time Series Forecast Studio SAS Forecast Server Forecast Studio Override Wizard Tasks→Time Series Forecast Studio SAS Forecast Server Prepare Time Series Data Tasks→Time Series EXPAND SAS/ETS Regression Analysis of Panel Data Tasks→Time Series TSCSREG SAS/ETS Regression Analysis with Autoregressive Errors Tasks→Time Series AUTOREG SAS/ETS Update Library Metadata Tools METALIB Base SAS Assign Project Library Tools LIBNAME Base SAS

View Article

Quick Links

  • About For Dummies
  • Contact Us
  • Activate Online Content

Connect

About Dummies

Dummies has always stood for taking on complex concepts and making them easy to understand. Dummies helps everyone be more knowledgeable and confident in applying what they know. Whether it's to pass that big test, qualify for that big promotion or even master that cooking technique; people who rely on dummies, rely on it to learn the critical skills and relevant information necessary for success.

Copyright @ 2000-2024 by John Wiley & Sons, Inc., or related companies. All rights reserved, including rights for text and data mining and training of artificial technologies or similar technologies.

Terms of Use
Privacy Policy
Cookies Settings
Do Not Sell My Personal Info - CA Only