Loading...
Please wait, while we are loading the content...
Publishing SAS ® Metadata Using Macros, PROC SQL and Dictionary Tables
| Content Provider | Semantic Scholar |
|---|---|
| Author | Fahey, John Campbell, Barry J. |
| Copyright Year | 2012 |
| Abstract | Users of your SAS data may not have the skills or access to obtain the metadata about it they require. This paper provides a method to extract and publish a catalogue containing variable names and types, descriptions, availability, and proportion missing. The macro is most useful when dealing with wide data; the motivating example has more than 10,000 variables. It iterates through a provided list, and uses PROC SQL to pull the relevant details from built-in dictionary tables. A summary dataset is produced and used as the basis for delivery to the end user via Excel, web applications, or portable documents. One unique feature of this macro is that, for datasets with an observation date, it determines the start and end of availability for each variable. |
| File Format | PDF HTM / HTML |
| Alternate Webpage(s) | https://www.lexjansen.com/nesug/nesug12/bb/bb16.pdf |
| Alternate Webpage(s) | http://www.shrugonline.ca/downloads/20130222/BB16%20Publishing%20SAS%20metadata%20using%20macros,%20PROC%20SQL%20ID%20204.pdf |
| Language | English |
| Access Restriction | Open |
| Content Type | Text |
| Resource Type | Article |
