Help using Base SAS procedures

how we import excel file having extension .xlsx in to dataset

Reply
Occasional Contributor
Posts: 12

how we import excel file having extension .xlsx in to dataset

how we import excel file having extension .xlsx in to dataset

Super Contributor
Posts: 282

Re: how we import excel file having extension .xlsx in to dataset

Hi,

Depending on your version of SAS, the following "Answered" question has a number of suggestions:

Regards,

Amir.

Frequent Contributor
Posts: 124

Re: how we import excel file having extension .xlsx in to dataset

Use

PROC IMPORT OUT= want

DATAFILE= "c:\temp\have.xlsx"

     DBMS=EXCEL2007 REPLACE;

     GETNAMES=YES;  

     Sheet=”sheet1”;

RUN;

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