DATA Step, Macro, Functions and more

Importing Excel file to SAS Studio

Reply
Occasional Contributor K23
Occasional Contributor
Posts: 5

Importing Excel file to SAS Studio

[ Edited ]

Hello,

I have data which are originally in Excel . I am trying to import these into SAS Studio.  There are 5 columns and in each row there are three entries. How can I import these data?

 

Thanks.

Super User
Posts: 17,815

Re: Importing Excel file to SAS Studio

When you say SAS studio, are you referring to SAS University Edition or SAS Studio that connects to a full version of SAS? If UE look at posts under the Find a Community>Learning>SAS Analytics U. There are a lot of examples for import Excel files.
Super User
Super User
Posts: 7,401

Re: Importing Excel file to SAS Studio

Just to add, the file you posted is a Word file, that wouldn't be easy to use.  As its only small data why not just copy and paste it directly into a code window?

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