Import from and Export to Excel


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



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.