Transcription of Introduction to Using PROC SQL - SAS
{{id}} {{{paragraph}}}
Example: bachelor of science
Introduction to Using PROC SQL - SAS
,TexasStateComptroller sOffice,Austin, @System simplementationofStructuredQueryLanguage , (DATA step,PROCSORT,andPROCMEANS steps), [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) ,eachRDBMS mayuseitsownparticular dialect , ,forexample,SQLallowssuchfamiliaractions asCREATE,SELECT,INSERT,UPDATE,DELETE, , , (thedesiredendresult),butnotaboutapartic ularmethod(thewhereandthehow) (ANSI) , ,whichexceedtheANSI specifications, :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
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: