Posted By

statsplank on 04/29/09


Tagged

import excel export proc sas


Versions (?)

Import from and Export to Excel


 / Published in: SAS
 

  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.