Copyright © 2014, SAS Institute Inc. All rights reserved.
EXPORTING SAS
®
DATA SETS AND CREATING 
ODS FILES FOR MICROSOFT EXCEL
GEORGIOS KARAGIANNIS, SAS SUPPORT
.Net pdf to jpg - Convert PDF to JPEG images in C#.net, ASP.NET MVC, WinForms, WPF project
How to convert PDF to JPEG using C#.NET PDF to JPEG conversion / converter library control SDK
changing file from pdf to jpg; changing pdf file to jpg
.Net pdf to jpg - VB.NET PDF Convert to Jpeg SDK: Convert PDF to JPEG images in vb.net, ASP.NET MVC, WinForms, WPF project
Online Tutorial for PDF to JPEG (JPG) Conversion in VB.NET Image Application
.net pdf to jpg; convert pdf image to jpg image
Copyright © 2014, SAS Institute Inc. All rights reserved.
OUTPUT DELIVERY SYSTEM
You can use ODS statements to send output from procedures to a variety 
of destinations.
HTML
EXCEL
PDF
RTF
CSV
XML
PROC Step
Online Convert Jpeg to PDF file. Best free online export Jpg image
All your JPG and PDF files will be permanently erased from our servers into image file format in C# application, then RasterEdge XDoc.PDF for .NET can also
convert pdf to jpg for; convert pdf into jpg format
Online Convert PDF to Jpeg images. Best free online PDF JPEG
Your PDF and JPG files will be deleted from our servers an hour after RasterEdge PDF to JPEG converting control SDK (XDoc.PDF for .NET) supports converting
.pdf to jpg converter online; bulk pdf to jpg
Copyright © 2014, SAS Institute Inc. All rights reserved.
OVERVIEW OF METHODS
The following methods enable you to create a file that can be opened with 
Excel or other software products:
Data Set Methods
EXPORT procedure 
SAS LIBNAME Engine for Excel
Procedure Output Methodsvia ODS
CSV and CSVALL
MSOFFICE2K and MSOFFICE2K_X 
TABLEEDITOR
EXCELXP
C# Image Convert: How to Convert Adobe PDF to Jpeg, Png, Bmp, &
C# Guide for PDF to Bmp. Copy the code below to your .NET project to test fast PDF to Bmp conversion. C# sample code for PDF to jpg image conversion.
batch convert pdf to jpg online; change pdf to jpg online
C# Image Convert: How to Convert Tiff Image to Jpeg, Png, Bmp, &
Of course, our XDoc.Converter for .NET still enables you to RasterEdge.XDoc.PDF.dll. C:\input.tif"; String outputFilePath = @"C:\output.jpg"; // Convert tiff to
convert pdf file to jpg format; convert multi page pdf to jpg
Copyright © 2014, SAS Institute Inc. All rights reserved.
WHAT DO YOU WANT TO EXPORT? 
Exporting…
Technique
SAS Data Set
EXPORT Procedure
Excel LIBNAME Engine
SAS ProcedureOutput
OutputDelivery System
4
C# Create PDF from images Library to convert Jpeg, png images to
Batch convert PDF documents from multiple image formats, including Jpg, Png, Bmp, Gif, Tiff, Bitmap, .NET Graphics, and REImage.
pdf to jpg; convert pdf photo to jpg
VB.NET PDF - Convert PDF with VB.NET WPF PDF Viewer
Convert PDF to image file formats with high quality, support converting PDF to PNG, JPG, BMP and GIF. VB.NET WPF PDF Viewer: Convert and Export PDF.
convert pdf to jpg; change format from pdf to jpg
Copyright © 2014, SAS Institute Inc. All rights reserved.
EXPORTING PROCEDURE OUTPUT VIA ODS
5
Destination
Type of FileCreated
CSV and CSVALL
CSV 
MSOFFICE2K
HTML
MSOFFICE2K_X 
HTML
TABLEEDITOR 
HTML
EXCELXP 
XML
C# WPF PDF Viewer SDK to convert and export PDF document to other
Convert PDF to image file formats with high quality, support converting PDF to PNG, JPG, BMP and GIF. C#.NET WPF PDF Viewer Tool: Convert and Export PDF.
convert pdf document to jpg; change pdf to jpg file
VB.NET Create PDF from images Library to convert Jpeg, png images
Support create PDF from multiple image formats in VB.NET, including Jpg, Png, Bmp, Gif, Tiff, Bitmap, .NET Graphics, and REImage.
convert multiple pdf to jpg online; change from pdf to jpg on
Copyright © 2014, SAS Institute Inc. All rights reserved.
SAS/ACCESS INTERFACE TO PC FILES
SAS/ACCESS Interface to PC Files imports various PC file formats to SAS 
data sets and exports SAS data sets to various PC file formats.
It provides several methods for data transfer, including the following:
Import and Export Wizards
IMPORT and EXPORT procedures
Microsoft Excel LIBNAME engine
6
Copyright © 2014, SAS Institute Inc. All rights reserved.
proc export data=orion.employees
outfile="&path\Employees.xls" 
dbms=excelcs replace;
sheet="All_Employees"; 
run;
EXPORT PROCEDURE SYNTAX
PROC EXPORT DATA=SAS-data-set<(SAS-data-set-options)>
OUTFILE="workbook-name
DBMS=identifier<REPLACE><LABEL>;
<SHEET="worksheet-name";
RUN;
Copyright © 2014, SAS Institute Inc. All rights reserved.
EXCEL LIBNAME ENGINE 
The SAS/ACCESS LIBNAME statement extends the LIBNAME statement to 
support assigning a library reference name (libref) to Microsoft Excel 
workbooks.
libname xlsdata a "&path\libname.xls";
data xlsdata.addresses(drop=numzip);
set orion.addresses(rename=(zipcode=numzip));
zipcode=put(numzip, z5.);
run;
libname xlsdata clear;
LIBNAMElibref <EXCEL>'location-of-Excel-workbook.xls<options>;
“Bitness” Matches
Copyright © 2014, SAS Institute Inc. All rights reserved.
libname xlsdata a pcfiles s path="&path\libname.xls";
data xlsdata.addresses(drop=numzip);
set orion.addresses(rename=(zipcode=numzip));
zipcode=put(numzip, z5.);
run;
libname xlsdata clear;
PCFILES LIBNAME ENGINE 
The SAS PC Files Server is an additional client installation that is required when
64-bit SAS is communicating to 32-bit Office
32-bit SAS is communicating to 64-bit Office
you work on the UNIX platform.
LIBNAMElibref PCFILES  
PATH='location-of-Excel-workbook.xls
<SERVER='machinename.domain.com|IP-address'>
<PORT=9621|8621>
Copyright © 2014, SAS Institute Inc. All rights reserved.
CSV DESTINATION
The CSV destination creates a comma-separated-value file that can be 
opened in Excel. 
ods csv file="&path\empsummary.csv";
proc report data=orion.employees nowd;
title 'Summary of Salaries from Orion.Employees';
column country gender salary;
define country/group;
define gender/group;
define salary/mean 'Average Salary';
run;
ods csv close;
ODSCSVFILE='filename.csv';
… SAS code …
ODS CSVCLOSE;
Documents you may be interested
Documents you may be interested