Introduction to Using PROC SQL - SAS
,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.]
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
Download Introduction to Using PROC SQL - SAS
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
PROC SQL, A Primer for SAS Programmers, Structured Query Language, Become Really Productive, Removing Duplicates Using SAS, Using PROC, PROC, Using the COMPUTE Block in PROC REPORT, Data Normalization for Dummies Using SAS, Advanced Subqueries In PROC SQL, Using SQL, Using the Magical Keyword 'INTO:' in, Using the Magical Keyword "INTO:" in PROC SQL