Advanced Search

Import from and Export to Excel

/ Published in: SAS
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.