Importing excel data into word for labels

#IMPORTING EXCEL DATA INTO WORD FOR LABELS HOW TO#
#IMPORTING EXCEL DATA INTO WORD FOR LABELS UPDATE#
#IMPORTING EXCEL DATA INTO WORD FOR LABELS MANUAL#

This method can import any Wordreadable document into SAS without concerning RTF tagsets. A much easy way introduced by Xu and Zhou (2007) is to use the INFILE statement to convert the plain text file programmatically saved by Word via DDE (Dynamic Data Exchange) into SAS. In addition, table titles, column headers, and footnotes, and special characters are not imported for QC comparison. Artificially searching the specific RTF tagsets could be cumbersome and unreliable. Because the tool reads the RTF file with the INFILE statement in a data step to import the data from the table body based on the RFT control words, intensive maintenance to the macro is needed to remove different special symbols, and sub-/super-scripts, and to fit different column settings and data presentations. There are many limitations with this method. (2006) developed a utility macro tool that converts RTF-formatted table/listing back to SAS for the purpose of quality control (QC), comparing it against the data independently programmed with PROC COMPARE. To meet the challenge, SAS programmers have developed a few ways to read data from Word with SAS (Hagendoorn et al., 2006 Xu and Zhou, 2007 Huang and Lynn, 2008 Tran, 2008). However, there is no existing SAS procedure which will directly import Word document into SAS.

#IMPORTING EXCEL DATA INTO WORD FOR LABELS UPDATE#

For instances, it is valuable to replace human visual check by programmatically identifying differences between versions of Word tables/listings caused by database update it is more accurate and efficient to populate derived variables with their attributes programmatically obtained from the Word document of the analysis dataset specifications.

Often times, it is desired for SAS programmers directly to convert data or text from the Word documents back into SAS.

#IMPORTING EXCEL DATA INTO WORD FOR LABELS MANUAL#

Tables and listings generated from SAS in Word format can be directly inserted or included into these formal Word documents with the similar font type and size without manual editing. Microsoft Word is standard word processing software in the pharmaceutical industry widely used to write formal documentations, including clinical study protocol, statistical analysis plan, analysis dataset specifications, and clinical study report.

With this convenient and reliable solution, SAS programmers will become more effective and innovative to leverage MS Word and SAS for their daily work. In addition, a SAS macro, %word2sas, used for the converting process will be introduced. This paper will review several published solutions with pros and cons and present a creative way programmatically to import any Word-readable documents, such as.

#IMPORTING EXCEL DATA INTO WORD FOR LABELS HOW TO#

This deficiency stimulates SAS programmers to explore the techniques of how to programmatically convert Word documents into SAS data. However, SAS does not provide a procedure to import data directly from Microsoft Word into SAS as PROC IMPORT reads data from Microsoft Excel. Jay Zhou, Amylin Pharmaceuticals, Inc., San Diego, CAДocuments in Word format are popular in the pharmaceutical industry.

Importing Data from Microsoft Word into SASВ®

Importing excel data into word for labels