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

[chittamsri1_gmail_com]

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

[Amir]

Hi,

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

Regards,

Amir.

[pp2014]

Use

PROC IMPORT OUT= want

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

     DBMS=EXCEL2007 REPLACE;

     GETNAMES=YES;  

     Sheet=”sheet1”;

RUN;