Introduction to Using PROC SQL - SAS

← Back to document page

,TexasStateComptroller sOffice,Austin, @System simplementationofStructuredQueryLanguage , (DATAstep,PROCSORT,andPROCMEANSsteps), [esinthispresentationpertaintoDB2tablesw hichareusedfortaxadministrationpurposesa ttheauthor ,eachcontainingoneormorerowsandcolumns, ,basedupontheirvalues, (SQL).Sometimes,ImayrefertoSASdatasets(S ASdatafilesandSASdataviews)as tables ,toSASvariablesas columns ,andtoobservationsas rows .Strictlyspeaking,thesearen texactlythesamethings(thereexisttableswh icharen tSASdatasets,andviewscontainnodatathemse lves)buttheunderlyingconceptsarecertainl ycomparable, ,thenwheneverIrefertoa table ,youmaysubstitute SASdatafile;andwhenIwrite column ,substitute SASvariable ;andwhenIsay row ,substitute SASobservation .StructuredQueryLanguage(SQL) ,eachRDBMSmayuseitsownparticular dialect , ,forexample,SQLallowssuchfamiliaractions asCREATE,SELECT,INSERT,UPDATE,DELETE, , , (thedesiredendresult),butnotaboutapartic ularmethod(thewhereandthehow) (ANSI) , ,whichexceedtheANSIspecifications, :lretrieveandmanipulateSASdatasets,ccrea teanddeletedatasets,laddormodifydatavalu esinadataset.]

Introduction to Using PROC SQL Thomas J. Winn Jr., Texas State Comptroller’s Office, Austin, Texas ABSTRACT This tutorial presentation will explain the basic syntax of the

  Introduction, Using, Corps, Introduction to using proc sql