Transcription of Introduction to Using PROC SQL - SAS
{{id}} {{{paragraph}}}
Example: confidence
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:
Related search queries
Introduction to Robotics and Java Programming, Using, Introduction to Sockets Programming in, Computer, Of COMPUTER OPERATOR AND PROGRAMMING ASSISTANT, Computer programming, Introduction to Numerical Methods and Matlab, Introduction to Numerical Methods and Matlab Programming, Introduction to Computer Architecture, Think Python