sas base tables
RSS sas base tablesSort by: Relevance | Date
Creating Microsoft Excel Pivot Tables From SAS - (Part 2)
White Paper This paper provides several enhancements to a technique that uses Base SAS and Visual Basic Scripting to automate the creation of Excel Pivot Tables from SAS data sets. The earlier paper presented at SUGI 31 consisted of a macro that produced a... [09 Jun 2007]
Web-Based Data Quality Assurance Reports at the National Alzheimer's Coordinating Center (NACC)
White Paper A series of approximately 60 tables and reports has been developed for monitoring the quality of data submitted to the Uniform Data Set (UDS) of the National Alzheimers Coordinating Center (NACC). Base SAS and SAS IntrNet are used, including PROC... [09 Jun 2007]
Calculating Statistics Using PROC MEANS Versus PROC SQL
White Paper PROC SQL is a widely used language for retrieving and updating data in tables/views. Both PROC MEANS and PROC SQL are now part of the base SAS product. Mainly it is used to retrieve data from RDBMS, calculate the descriptive statistics or summarize... [01 Jun 2007]
Visualizing Patterns With Scrollable Web Graphics
White Paper By combining the power of SAS with the visual clarity of HTML tables, one can create scrollable Web graphics that illuminate the data. The method uses base SAS, SAS/Intrnet, SAS/Access, HTML, JavaScript, and Microsoft's Active Server Pages (ASP... [03 May 2007]
DATA Step Vs. PROC SQL: What's a Neophyte to Do?
White Paper Structured Query Language (SQL) is a widely used language for retrieving and updating data in tables and/or views of those tables. It has its origins in and is primarily used for retrieval of tables in relational databases. [31 Jan 2007]
Managing a SAS Programming Environment Using Data Access Pages and the Microsoft Office Data Source Control
White Paper In addition, either as part of the TOP or in a separate file, people also often see some sort of "Table of Tables, Figures and Listings (TFLs)", containing data such as titles and footnotes, TFL number, source data, analysis population, and output... [25 Dec 2006]
A Hands-On Tour Inside the World of PROC SQL
It enables access to data stored in SAS data sets or tables using a powerful assortment of statements, clauses, options, functions, and other language features. Structured Query Language (PROC SQL) is a database language found in the base-SAS... [22 Dec 2006]
A Hands-On Tour Inside the World of PROC SQL
White Paper It enables access to data stored in SAS data sets or tables using a powerful assortment of statements, clauses, options, functions, and other language features. Structured Query Language (PROC SQL) is a database language found in the base-SAS... [21 Dec 2006]
Fancy MS Word Reports Made Easy: Harnessing the Power of Dynamic Data Exchange - Against All ODS, Part II
White Paper Using a set of easy-to-use SAS macros, the authors show the beginner-to-advanced SAS user how to insert and format SAS data, graphs, and tables into a Word report. DDE enables the creation of fully customized Microsoft Word documents from within a... [13 Dec 2006]
Creating Ranking Charts Using SAS/GRAPH and the Annotate Facility
White Paper Census Bureau began producing ranking charts and tables in order to provide reporters as well as Federal, state, and local government decision makers with a simple yet effective visual representation of comparative data on key issues across states... [13 Sep 2006]
Sur La Table: Creating Microsoft Excel PivotTables in a Jiffy From SAS Data
White Paper This paper presents a technique and macro that combine Base SAS with Visual Basic Scripting to make possible to fully automate the creation of custom formatted Excel Pivot Tables from SAS data sets. Creating good looking Excel Pivot Tables to hold... [12 Sep 2006]
Creating And Importing Multi-Sheet Excel Workbooks the Easy Way With SAS
White Paper The paper provides information about converting one's own multi-sheet Excel workbooks to SAS tables. This paper discusses using XML support in Base SAS 9.1 software to move data between SAS and Microsoft Excel (versions 2002 and later). [05 May 2006]
