how we import excel file having extension .xlsx in to dataset - SAS Support Communities

Calcite | Level 5

Calcite | Level 5

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

Posted 05-15-2014 12:35 PM (1278 views)

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

2 REPLIES 2

PROC Star

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

Posted 05-15-2014 01:07 PM (1111 views) | In reply to chittamsri1_gmail_com

Hi,

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

Regards,

Amir.

Fluorite | Level 6

Fluorite | Level 6

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

Posted 05-15-2014 01:10 PM (1111 views) | In reply to Amir

Use

PROC IMPORT OUT= want

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

DBMS=EXCEL2007 REPLACE;

GETNAMES=YES;

Sheet=”sheet1”;

RUN;