sas.certification.prep.guide.advanced.program

《sas.certification.prep.guide.advanced.program》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、SAS®@boqfcf`^qflkMobmDrfabAdvancedProgrammingforSAS®9Thecorrectbibliographiccitationforthismanualisasfollows:SASInstituteInc.2007.SAS®CertificationPrepGuide:AdvancedProgrammingforSAS®9.Cary,NC:SASInstituteInc.SAS®CertificationPrepGuide:AdvancedProgrammingforSAS®9Copyright©

2、2002–2007,SASInstituteInc.,Cary,NC,USA978-1-59994-559-0Allrightsreserved.ProducedintheUnitedStatesofAmerica.Forahard-copybook:Nopartofthispublicationmaybereproduced,storedinaretrievalsystem,ortransmitted,inanyformorbyanymeans,electronic,mechanical,photocopying,orotherwise,w

3、ithoutthepriorwrittenpermissionofthepublisher,SASInstituteInc.ForaWebdownloadore-book:Youruseofthispublicationshallbegovernedbythetermsestablishedbythevendoratthetimeyouacquirethispublication.U.S.GovernmentRestrictedRightsNotice.Use,duplication,ordisclosureofthissoftwareand

4、relateddocumentationbytheU.S.governmentissubjecttotheAgreementwithSASInstituteandtherestrictionssetforthinFAR52.227-19CommercialComputerSoftware-RestrictedRights(June1987).SASInstituteInc.,SASCampusDrive,Cary,NorthCarolina27513.1stprinting,November2007SAS®Publishingprovides

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

6、teInc.productorservicenamesareregisteredtrademarksortrademarksofSASInstituteInc.intheUSAandothercountries.®indicatesUSAregistration.Otherbrandandproductnamesareregisteredtrademarksortrademarksoftheirrespectivecompanies.ContentsAboutThisBookandCDxiWhat’sNewxiPurposexiAudienc

7、exiPrerequisitesxiHowtoUseThisBookandCDxiiSyntaxConventionsforThisBookxiiSASCertificationPracticeExam:AdvancedProgrammingforSAS9xiiiSASAdvancedProgrammingExamforSAS9xiiiAdditionalResourcesxiiiPART1SQLProcessingWithSAS1Chapter1PerformingQueriesUsingPROCSQL3Overview4PROCSQLBa

8、sics4WritingaPROCSQLStep6SelectingColumns8SpecifyingtheTable10SpecifyingSubsetting