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 "Tips:Would you like additional capabilities when exporting data to Excel?"

From sasCommunity
Jump to: navigation, search
(Change 'I' to third-person.)
m (changed let's to lets)
Line 1: Line 1:
Tom Abernathy, Matt Kastin and Arthur Tabachneck wrote a macro that let's one: (1) include or exclude a variable name or variable label row; (2) export formatted or unformatted data; (3) use excel templates; (4) add to an existing worksheet; (5) copy to a non-predefined range; and (6) not run into 32-bit/64-bit incompatibilities. And it doesn't even require SAS/Access for PC File Formats.
+
Tom Abernathy, Matt Kastin and Arthur Tabachneck wrote a macro that lets one: (1) include or exclude a variable name or variable label row; (2) export formatted or unformatted data; (3) use excel templates; (4) add to an existing worksheet; (5) copy to a non-predefined range; and (6) not run into 32-bit/64-bit incompatibilities. And it doesn't even require SAS/Access for PC File Formats.
  
 
Additionally, the macro uses the same parameters as proc export, and its supporting paper even shows how it can be run as a SAS abbreviation.
 
Additionally, the macro uses the same parameters as proc export, and its supporting paper even shows how it can be run as a SAS abbreviation.

Revision as of 21:49, 2 May 2015

Tom Abernathy, Matt Kastin and Arthur Tabachneck wrote a macro that lets one: (1) include or exclude a variable name or variable label row; (2) export formatted or unformatted data; (3) use excel templates; (4) add to an existing worksheet; (5) copy to a non-predefined range; and (6) not run into 32-bit/64-bit incompatibilities. And it doesn't even require SAS/Access for PC File Formats.

Additionally, the macro uses the same parameters as proc export, and its supporting paper even shows how it can be run as a SAS abbreviation.

....[|read more ]

Submitted By Art T