SAS SQL 1 Essentials

《SAS SQL 1 Essentials》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、2010-4-23SASSQL1:Essentials212010-4-23Chapter1GettingStarted1.1IntroducingtheStructuredQueryLanguage….31.2IntroducingtheBusinessScenario……………..8Chapter2BasicQueries2.1OverviewoftheSQLProcedure………………..122.2SpecifyingColumns………………………………202.3SpecifyingRows………………………………….

2、.383Chapter3DisplayingQueryResults3.1PresentingData………………………………….533.2SummarizingData……………………………….62Chapter4Subqueries4.1NoncorrelatedSubqueries………………………81422010-4-23Chapter1:GettingStarted1.1IntroducingtheStructuredQueryLanguage1.2IntroducingtheBusinessScenario5Chap

3、ter1:GettingStarted1.1IntroducingtheStructuredQueryLanguage1.2IntroducingtheBusinessScenario632010-4-23Objectives¢DescribethehistoricaldevelopmentofStructuredQueryLanguage(SQL).¢ExplainhowSQLisused.7StructuredQueryLanguageStructuredQueryLanguage(SQL)isastandardizedla

4、nguageoriginallydesignedasarelationaldatabasequerytool.SQLiscurrentlyusedinmanysoftwareproductstoretrieveandupdatedata.842010-4-23StructuredQueryLanguage:Timeline1970198019902000IBMdevelopsSQL.1970–Dr.E.F.CoddofIBMproposesSQL.1981–FirstcommercialSQLproductisreleased.

5、1989–Morethan75SQL-basedsystemsexist.SAS6.06includesPROCSQLincludesPROCSQL.1999–PROCSQLisenhancedforSAS8.2004–PROCSQLisenhancedforSAS®9.9TheSQLProcedureTheSQLprocedurehasthefollowingcharacteristics:¢enablestheuseofSQLinSAS¢ispartofBaseSASsoftware¢followsAmericanNatio

6、nalStandardsInstitute(ANSI)standards¢includesenhancementsforcompatibilitywithSASsoftware1052010-4-23TheSQLProcedureFeaturesWithPROCSQL,youcanuseSQLlanguagesyntaxtodothefollowing:¢querySASdatasets¢generatereportsfromSASdatasets¢combineSASdatasetsinmanyways¢createandde

7、leteSASdatasets,views,andindexes¢updateexistingSASdatasets¢sometimesreproducetheresultsofmultipleDATAandprocedrestepsandprocedurestepswithasingleqerithasinglequery11StructuredQueryLanguageInputOutputSASDataSetReportPROCSQLPROCDBMSTableSQLSASDataSetSASDataViewSASDataV

8、iewDBMSTable1262010-4-23TheSQLProcedureTheSQLprocedureis¢atoolforqueryingdata¢atoolfordatamanippgulationandmanagement¢anaugmentatio