topic Importing Excel file to SAS Studio in SAS Programming

Importing Excel file to SAS Studio

K23 — Wed, 21 Oct 2015 19:45:34 GMT

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.

Re: Importing Excel file to SAS Studio

Reeza — Thu, 22 Oct 2015 05:02:46 GMT

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.

Re: Importing Excel file to SAS Studio

RW9 — Thu, 22 Oct 2015 08:41:12 GMT

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?