Microsoft Access Integration
|
I Want It All – Recovering Variable Labels When Importing Data from Microsoft Access |
|
Dimitri Shvorob, SAS Global Forum 2007, 003-2007
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
|
|
Microsoft Access Integration 
