資源描述:
《sas_adv_sql高級sql_計算機軟件及應(yīng)用_it計算機_專業(yè)資料》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、TopicPROCSQL1.Introduction2.GeneratereportsusingPROCSQLandtheappropriateoptions3.ConstructsubquerieswithinaPROCSQLstep4.AccessDictionaryTablesusingtheSQLprocedure5.CombiningTablesverticallyusingSetOperationsinPROCSQL6.JoiningTableshorizontally7.CreatingandManagingTablesusingPROCSQL8.CreatingInde
2、xusingPROCSQL9.CreatingMacro10.IntegrityConstraints291.IntroductionSQL,anacronymforStructuredQueryLanguage,isanANSI(AmericanNationalStandardsInstitute)standarddatabaseprogramming/querylanguage.SQLisastandardized,widelyusedlanguagethatretrievesandupdatesdataintablesandviewsbasedonthosetables.PROC
3、SQLcanoftenbeusedasanalternativetootherSASproceduresortheDATAstep.YoucanusePROCSQLto·retrievedatafromandmanipulateSAStables·addormodifydatavaluesinatable·add,modify,ordropcolumnsinatable·createtablesandviews·joinmultipletables(whetherornottheycontaincolumnswiththesamename)·generatereports.1.1Wha
4、tisSQLtable?APROCSQLtableissynonymouswithaSASdatafileandhasamembertypeofDATA.YoucanusePROCSQLtablesasinputintoDATAstepsandprocedures.ArowinatableisthesameasanobservationinaSASdatafile.Acolumnisthesameasavariable.1.2Table-ComparisonofSQLterms,BaseSAS,andDataprocessingterminology:SQLBaseSASDataPro
5、cessing_______________________________________________________________________tableSASdatafilefilerowobservationrecordcolumnvariablefield_______________________________________________________________________1.3WhyuseSQLorlearnit?·Powerful-candomanythings·Flexible-justsaywhatyouwant·Compatible-y
6、oucanusetheSQLyoulearnlaterinotherapplications·Required-forSASadvancedprogrammer291.4SASDataStepandSQLSASSQLCreatedatasetCreatetablesUpdatevaluesUpdatevaluesDeleterecordsDeleterecordsAppendnewrecordsUnion/InsertSortdataSortdataMergedatasetsJointables1.5SQLProcedureCodingConventionsSQLstatementsa
7、redividedintoclauses.Forexample,themostbasicSELECTstatementcontainstheSELECTandFROMclauses.TheSELECTstatement,whichisusedtoretrievedata,alsooutputsthedataautomaticallyunlessyouspecifytheNOPRINToptioninthePROCSQLstatement.Thi