sas 9 1 3 sql procedures guide外语英文电子书

《sas 9 1 3 sql procedures guide外语英文电子书》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、SAS®9.1SQLProcedureUser’sGuideThecorrectbibliographiccitationforthismanualisasfollows:SASInstituteInc.,2004.SAS®9.1SQLProcedureUsersGuide.Cary,NC:SASInstituteInc.SAS®9.1SQLProcedureUsersGuideCopyright©2004,SASInstituteInc.,Cary,NC,USA.ISBN1-59047-334-5Allrightsreser

2、ved.ProducedintheUnitedStatesofAmerica.Nopartofthispublicationmaybereproduced,storedinaretrievalsystem,ortransmitted,inanyformorbyanymeans,electronic,mechanical,photocopying,orotherwise,withoutthepriorwrittenpermissionofthepublisher,SASInstituteInc.U.S.GovernmentRes

3、trictedRightsNotice.Use,duplication,ordisclosureofthissoftwareandrelateddocumentationbytheU.S.governmentissubjecttotheAgreementwithSASInstituteandtherestrictionssetforthinFAR52.22719CommercialComputerSoftware-RestrictedRights(June1987).SASInstituteInc.,SASCampusDriv

4、e,Cary,NorthCarolina27513.1stprinting,January2004SASPublishingprovidesacompleteselectionofbooksandelectronicproductstohelpcustomersuseSASsoftwaretoitsfullestpotential.Formoreinformationaboutoure-books,e-learningproducts,CDs,andhard-copybooks,visittheSASPublishingWeb

5、siteatsupport.sas.com/publishingorcall1-800-727-3228.SAS®andallotherSASInstituteInc.productorservicenamesareregisteredtrademarksortrademarksofSASInstituteInc.intheUSAandothercountries.®indicatesUSAregistration.Otherbrandandproductnamesareregisteredtrademarksortradem

6、arksoftheirrespectivecompanies.ContentsChapter1IntroductiontotheSQLProcedure1WhatIsSQL?1WhatIstheSQLProcedure?1Terminology2ComparingPROCSQLwiththeSASDATAStep3NotesabouttheExampleTables4Chapter2RetrievingDatafromaSingleTable11OverviewoftheSELECTStatement12Selecting

7、ColumnsinaTable14CreatingNewColumns18SortingData25RetrievingRowsThatSatisfyaCondition30SummarizingData39GroupingData45FilteringGroupedData50ValidatingaQuery52Chapter3RetrievingDatafromMultipleTables55Introduction56SelectingDatafromMoreThanOneTablebyUsingJoins56Usin

8、gSubqueriestoSelectData74WhentoUseJoinsandSubqueries80CombiningQuerieswithSetOperators81Chapter4CreatingandUpdatingTablesandViews89Introd