SAS/ACCESS offers a number of ways to retrieve data stored in a Microsoft Access table, but none of them lets one recover table field descriptions, Access's limited analog of SAS variable labels. A Visual Basic macro saves the day; called from icrosoft Word, it looks up field descriptions ertaining to selected table, and embeds them in a uitable ABEL statement, ready to cut-and-paste into our SAS code.

 I Want It All – Recovering Variable Labels When Importing Data from Microsoft Access

 Michael Kilhullen, PharmaSUG 2007, Paper sa04

The SAS metadata server is a core component of all SAS 9 solutions. It delivers the power to integrate, share, centrally manage and leverage metadata across entire organizations. Through these capabilities, standard data models such as the CDISC Study Data Tabulation Model (SDTM) can be deployed and leveraged by all users in your organization without the need for developing additional metadata libraries or programs. In this paper, we examine the
value that the SAS® Open Metadata Architecture can bring to your organization, how the SDTM data model is implemented in the metadata server, and how the metadata can be leveraged by SAS products and solutions such as SAS® Data Integration Studio.

 Implementing CDISC Data Models in the SAS® Metadata Server 

 Neil Howard, Sug24, p57-24

A FUNCTION returns a value from a computation or system manipulation that requires zero or more arguments. And, like most programming languages, the SAS System provides an extensive library of “built-in” functions. SAS has more than 190 functions for a variety of programming tasks. This tutorial will cover the syntax for invoking functions, an overview of the functions available, examples of commonly used functions, selected character handling and numeric functions, and some tricks and applications of functions that will surprise you.

 Introduction to SAS Functions - p57-24 

Abstract

 Large Scale Data Warehousing with the SASâ System (Link)