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

Help with loading excel into SAS University Edition

Reply
New Contributor
Posts: 2

Help with loading excel into SAS University Edition

Hi,

I am new to SAS and keen to learn.  I have successfully loaded the SAS University Edition and setup the myfolders folder.  However I am now struggling to import an excel data file into SAS University Edition for the first time. 

The process I have followed is to doubleclick on "Import Data" under the Utilities tab in SAS Studio and update the name of the file to be imported, to the name of the excel dataset in the myfolders folder, in this case "Gift".  

The code generated looks correct, however after I submit the code, the log only contains the options statement and the results tab is blank.  There are no errors, warnings or notes.  Any help would be appreciated.

Thanks,

Anne

 

importcode.JPG

 

logoutput.JPG

Super User
Posts: 19,822

Re: Help with loading excel into SAS University Edition

There doesn't appear to be anything incorrect with your code. Do you see the dataset in the work library? 

 

What if you copy the code code to a program editor and run it from there? 

I would remove the %web.. portions. 

New Contributor
Posts: 2

Re: Help with loading excel into SAS University Edition

Thanks Reeza.

I removed the %web parts as you suggested.

I also removed the Getnames = yes; statement and then it worked!

 

Ask a Question
Discussion stats
  • 2 replies
  • 287 views
  • 0 likes
  • 2 in conversation