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

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

chittamsri1_gmail_com — Thu, 15 May 2014 16:35:34 GMT

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

Amir — Thu, 15 May 2014 17:07:59 GMT

Hi,

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

Regards,

Amir.

pp2014 — Thu, 15 May 2014 17:10:35 GMT

Use

PROC IMPORT OUT= want

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

DBMS=EXCEL2007 REPLACE;

GETNAMES=YES;

Sheet=”sheet1”;

RUN;