Learning SAS? Welcome to the exclusive online community for all SAS learners.

Import data from exel

Reply
Contributor
Posts: 35

Import data from exel

I keep getting this erros message when I'm trying to import data from excel. Please help

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 

57           58         proc import datafile="C:\\Users\\Ruzeina\\Desktop\\SASdiab.xls";

ERROR: Output SAS data set must be provided. 

NOTE: The SAS System stopped processing this step because of errors. 

NOTE: PROCEDURE IMPORT used (Total process time):        real time           0.00 seconds        cpu time            0.01 seconds          59         out=work.SASdiab;  60         dbms=xls;  61         replace;  62         run;  63           64       

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;  76        

Super User
Posts: 19,878

Re: Import data from exel

This is a commonly asked question on the SAS UE page.

Please see the MORE LIKE THIS section on the left hand side of the page.

Or review the answers here:

Ask a Question
Discussion stats
  • 1 reply
  • 303 views
  • 0 likes
  • 2 in conversation