As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Difference between revisions of "Universal File Flattener"

From sasCommunity
Jump to: navigation, search
(cleanup/gardening)
(change URLs to wikilinks for source files)
 
Line 3: Line 3:
  
 
== Online Materials ==
 
== Online Materials ==
See [http://www.sascommunity.org/mwiki/images/f/f6/SAS_Global_Forum_Paper_2016-1780.pdf the paper describing the program], the [http://www.sascommunity.org/mwiki/images/1/10/Universal_File_Flattener.sas source code], and a [http://www.sascommunity.org/mwiki/images/1/1f/Generate_Sample_Data.SAS program to generate sample data].
+
See [http://www.sascommunity.org/mwiki/images/f/f6/SAS_Global_Forum_Paper_2016-1780.pdf the paper describing the program], the [[Media:Universal File Flattener.sas|source code]], and a [[Media:Generate Sample Data.SAS|program to generate sample data]].
  
 
== Contact info ==
 
== Contact info ==

Latest revision as of 12:59, 28 September 2017

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