Your Ad Here

advanced code snippet search

Posted By

statsplank on 04/29/09


Tagged

import excel export proc sas


Versions (?)

Import from and Export to Excel

 / Published in: SAS
 
Expand | Embed | Plain Text 
  1. /* Import from Excel */
  2. PROC IMPORT OUT= test  
  3.             DATAFILE= "D:\May08\Final.xls" 
  4.             DBMS=EXCEL REPLACE; 
  5.             SHEET="Final Data$"; 
  6.             GETNAMES=YES; 
  7.             MIXED=Yes; 
  8.             SCANTEXT=YES; 
  9.             USEDATE=YES; 
  10.             SCANTIME=YES;
  11. RUN;
  12.  
  13.  
  14. /* Export to Excel */
  15. PROC EXPORT DATA= P.FINAL_CALC 
  16.             OUTFILE= "D:\Feb09\sas\Final.xls" 
  17.             DBMS=EXCEL REPLACE;
  18. RUN;

Report this snippet  

You need to login to post a comment.