SAS 9.2 SQL procedure user guide

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

1、SAS®9.2SQLProcedureUser’sGuideTW10871_sqlproc_colortitlepg.indd12/17/093:43:14PMThecorrectbibliographiccitationforthismanualisasfollows:SASInstituteInc.,SAS®9.2SQLProcedureUsersGuide.Cary,NC:SASInstituteInc.,2009.SAS®9.2SQLProcedureUsersGuideCopyright©2009,SASInstituteInc.,Cary,NC,USA.IS

2、BN97815999448539Allrightsreserved.ProducedintheUnitedStatesofAmerica.Forahard-copybook:Nopartofthispublicationmaybereproduced,storedinaretrievalsystem,ortransmitted,inanyformorbyanymeans,electronic,mechanical,photocopying,orotherwise,withoutthepriorwrittenpermissionofthepublisher,SASInst

3、ituteInc.ForaWebdownloadore-book:Youruseofthispublicationshallbegovernedbythetermsestablishedbythevendoratthetimeyouacquirethispublication.U.S.GovernmentRestrictedRightsNotice.Use,duplication,ordisclosureofthissoftwareandrelateddocumentationbytheU.S.governmentissubjecttotheAgreementwithS

4、ASInstituteandtherestrictionssetforthinFAR52.22719CommercialComputerSoftware-RestrictedRights(June1987).SASInstituteInc.,SASCampusDrive,Cary,NorthCarolina27513.1stelectronicbook,February20091stprinting,February2009SAS®Publishingprovidesacompleteselectionofbooksandelectronicproductstohelp

5、customersuseSASsoftwaretoitsfullestpotential.Formoreinformationaboutoure-books,e-learningproducts,CDs,andhard-copybooks,visittheSASPublishingWebsiteatsupport.sas.com/publishingorcall1-800-727-3228.SAS®andallotherSASInstituteInc.productorservicenamesareregisteredtrademarksortrademarksofSA

6、SInstituteInc.intheUSAandothercountries.®indicatesUSAregistration.Otherbrandandproductnamesareregisteredtrademarksortrademarksoftheirrespectivecompanies.ContentsChapter1IntroductiontotheSQLProcedure1WhatIsSQL?1WhatIstheSQLProcedure?1Terminology2ComparingPROCSQLwiththeSASDATAStep3Notesab

7、outtheExampleTables5Chapter2RetrievingDatafromaSingleTable11OverviewoftheSELECTStatement12SelectingColumnsinaTable14CreatingNewColumns18SortingData25RetrievingRowsThatSatisfyaCondition31SummarizingData40GroupingData47FilteringGroupedData51ValidatingaQuery53Chapter3Retri