—•Today is •—

This example illustrates how to write a SAS data set to an Excel file using PROC DBLOAD. In this example, the SAS variable labels will be written out as the Excel column names.

This program writes a SAS Data Set to EXCEL using DBLOAD. 


  proc dbload dbms=xls data=sasuser.testdata;
    path='c:\Winnt\Profiles\Administrator\Personal\testdata.xls';
    putnames=yes;
    label;
    reset all;
    limit=0;
    load;
  run;

Print Document

Copyright © 2006 www.nycinformatics®.com All Rights Reserved
Last edited on: May 28, 2006
SAS product or service names are registered trademarks of SAS Institute, Inc. in the USA and other countries.
® indicates USA registration.