Course Hero Logo

Lecture1.pdf - Lecture 1: Introduction 1.1 Using SAS...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 12 out of 38 pages.

Copyright © SAS Institute Inc. All rights reserved.Lecture 1: Introduction1.1Using SAS Programming Tools1.2 List of topics1.3 Databases and Installing SAS
Multiple Disciplines of Data Science...BusinessAcumenMath or StatisticsKnowledgeProgramming,Data Management, DataIntegration, Data Quality,and Data TransformationProgramming:SAS and SQLData Management:define, manipulate, retrieve andmanage data in a database
Multiple Disciplines of Data Science...BusinessAcumenMath or StatisticsKnowledgeProgramming,Data Management, DataIntegration, Data Quality,and Data Transformationtraditionalstatistics
Multiple Disciplines of Data Science...BusinessAcumenMath or StatisticsKnowledgeProgramming,Data Management, DataIntegration, Data Quality,and Data Transformationbusinessdomainexpertise
Multiple Disciplines of Data ScienceBusinessAcumenMath or StatisticsKnowledgeBusinessAnalyticsMachineLearningDataScienceBusinessIntelligence(BI)Programming,Data Management, DataIntegration, Data Quality,and Data Transformation
Tables
Collection of Related Tables
SAS Programming InterfacesSAS windowingenvironmentSAS EnterpriseGuideSAS StudioA web-basedinterface to SASSAS has severalprogramminginterfaces that you canuse to interactivelywrite and submit code
SAS Programming InterfacesEditorLogdata myclass;set sashelp.class;run;proc print data=myclass;run;1data myclass;2set sashelp.class;3run;NOTE: There were 19 observations read fromthe data set SASHELP.CLASS.NOTE: The data set WORK.MYCLASS has 19observations and 5 variables.NOTE: DATA statement used:real time0.01 secondscpu time0.00 seconds45proc print data=myclass;NOTE: Writing HTML Body file: sashtml.htm6run;NOTE: There were 19 observations readfrom the data set WORK.MYCLASS.Results andOutput Dataviewmessagesfrom SASwriteandsubmitcodeviewresults
Structured Query Language (SQL)Structured Query Language(SQL) is a standardized, widelyused language designed toquery and manage data inrelational databases.SQL
Timeline of SQLRelational DatabaseModel Proposed:organize data intotables of columns androws, with a unique keyidentifying each row19701973SEQUELDeveloped1986First ANSI (AmericanNational Standards Institute)Standard SQL (SQL-87)1992Firstmajorrevision to theANSI Standard (SQL-2)1993SAS PROC SQL1999Lastmajorrevision to theANSI Standard (SQL-3)

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 38 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture