Maintaining Formats when Exporting Data from SAS into ...
Introduction Solutions
Conclusions
Maintaining Formats when Exporting Data from SAS into Microsoft Excel
Nate Derby & Colleen McGahan
Stakana Analytics, Seattle, WA BC Cancer Agency, Vancouver, BC
Regina SAS Users Group 3/11/15
Nate Derby & Colleen McGahan
Organizing SAS Files
1 / 24
Outline
Introduction Solutions
Conclusions
1 Introduction
2 Solutions The ExcelXP Tagset Dynamic Data Exchange (DDE)
The LIBNAME Engine
3 Conclusions
Nate Derby & Colleen McGahan
Organizing SAS Files
2 / 24
Introduction
Introduction Solutions
Conclusions
Many typical ways of exporting data from SAS into Excel destroy the data formats.
Creating Data Formats DATA class;
SET sashelp.class; FORMAT age 3. height weight 6.2; IF name = 'Thomas' THEN age = .; RUN;
Nate Derby & Colleen McGahan
Organizing SAS Files
3 / 24
SAS Dataset
Introduction Solutions
Conclusions
Nate Derby & Colleen McGahan
Organizing SAS Files
4 / 24
Introduction Solutions
Conclusions
Exporting SAS Data
Now let's export it via PROC EXPORT and the ExcelXP tagset:
SAS Code
PROC EXPORT DATA=class OUTFILE="&outroot\Output from PROC EXPORT.xls";
RUN;
ODS tagsets.ExcelXP FILE="&outroot\Output from ExcelXP.xls";
PROC PRINT DATA=class; RUN;
ODS tagsets.ExcelXP CLOSE;
Nate Derby & Colleen McGahan
Organizing SAS Files
5 / 24
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pharmasug china 2017 paper 64 how to read rtf files into
- create a format from a sas data set
- 068 2007 creating a format from raw data or a sas data set
- handling sas formats catalogs across versions
- sugi 27 programming tricks for reducing storage and sas
- some useful techniques of proc format
- using proc datasets for efficient sas processing
- proc format advanced techniques multi label and nested
- proc doc iii self generating codebooks using sas
- 316 2013 maintaining formats when exporting data from sas
Related searches
- exporting data from a pdf to excel
- importing data from pdf to excel
- when is data significant
- extract data from pdf to excel
- pull data from pdf to excel
- data from pdf to excel
- python read data from pdf
- python get data from pdf
- extract data from pdf document
- extract data from pdf files
- extract data from pdf form
- dow jones historical data from 1900