Universal File Flattener

From sasCommunity
Jump to: navigation, search

Abstract

This session describes the construction of a program that converts any set of relational tables into a single flat file, using Base SAS® in SAS® 9.3. The program gets the information it needs from the data tables themselves, with a minimum of user configuration. It automatically detects one-to-many relationships and creates sets of replicate variables in the flat file. The program illustrates the use of macro programming and the SQL, DATASETS, and TRANSPOSE procedures, among others. The output is sent to a Microsoft Excel spreadsheet using the Output Delivery System (ODS).

Online Materials

See the paper describing the program, the source code, and a program to generate sample data.

Contact info

Dav Vandenbroucke

david.a.vandenbroucke@hud.gov